Add PostGIS spatial functions to a custom schema other than “public” in PostgreSQL

Table of Contents

Add PostGIS spatial functions to a custom schema other than “public” in PostgreSQL

https://gis.stackexchange.com/questions/87212/add-postgis-spatial-functions-to-a-custom-schema-other-than-public-in-postgres

Add new

CREATE SCHEMA gc;

CREATE EXTENSION postgis SCHEMA gc;

Move PostGIS installed to other schema

UPDATE pg_extension 
  SET extrelocatable = TRUE 
    WHERE extname = 'postgis';

ALTER EXTENSION postgis 
  SET SCHEMA gc;

Leave a Reply Cancel reply