We assume you have already created a database userdb, where userdb is the name of any database. Assume that the name of PostgreSQL's superuser is postgres.

shell> psql -U postgres -c 'CREATE EXTENSION pg_sphere' userdb
  

It may be necessary to give more psql options, like port or host name, depending on your system configuration. Please, take a look at the psql user manual for details. The psql user manual for the latest PostgreSQL version can be found at PostgreSQL site .

To get the version of installed pgSphere software:

pgsql> SELECT pg_sphere_version();