We assume you have already created a database
datab, where datab
is the name of any database.
Presupposing the name of your
PostgreSQL's superuser is
postgres
, type:
shell> psql -U postgres -c 'CREATE EXTENSION pg_sphere' datab
Depending on your system, it may be necessary to give more
psql
options like port or host name.
Please have a look at the
PostgreSQL documentation for more
details.
To get the version of installed pgSphere software, simply call:
pgsql> SELECT pg_sphere_version();