Questions tagged [schema]

Definition of a database structure (blueprint) including table layout, integrity constraints, embedded functions, sequences, triggers, domains, etc.

Filter by
Sorted by
Tagged with
0
votes
1answer
24 views

Making PostGIS extension persist in the search_path of a PostgreSQL database?

Context I have a script to set up a PostgreSQL database along with the postgis extension which I decided to install in an other schema than public, namely, the postgis schema. In my script, this ...
3
votes
1answer
81 views

Use PostGIS functions from an other schema (than public)

Context I have to set up a postgresql database with several schemas. To separate things, I decided to install postgis elsewhere than the public schema, based on https://postgis.net/2017/11/07/tip-...