CODEWITHSUNDEEP
postgresqlpostgis
STALER
STALER

Reputation: 186

How to create a new database with the PostGIS extensions

enter image description here

I installed PostGis in the docker, in the standard database there are all the necessary extensions, but when creating a new one there are none, what do I need to do to fix this?

Upvotes: 1

Views: 433

Answers (1)

Jim Jones
Jim Jones

Reputation: 19623

If you already has the libraries installed in the system, just connect to the database geo and execute the create extension:

CREATE EXTENSION postgis

Keep in mind that you have to additionally CREATE EXTENSION in the database you want, unless you create the database based on a template that already has PostGIS installed.

From the PostGIS documentation :

Once postgis is installed, it needs to be enabled in each individual database you want to use it in.

Upvotes: 1

Related Questions