Add PostGIS spatial functions to a custom schema other than “public” in PostgreSQL
Table of Content
Add PostGIS spatial functions to a custom schema other than “public” in PostgreSQL
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;