[postgis-users] Moving PostGIS to a different schema

[Regina Obe]

> alter extension postgis set schema public ; returns, in PostGIS 3.0
> ERROR:  extension "postgis" does not support SET SCHEMA
> 
> any solution to this?
> Thanks.
> --
> Paolo Cavallini
> www.faunalia.eu - QGIS.org
> training, support, development on QGIS, PostGIS and more
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

Documented in this tip article


https://postgis.net/2017/11/07/tip-move-postgis-schema/



I need to update it a bit, for newer versions you should be able to use


SELECT postgis_extensions_upgrade();


Instead of the ALTER UPDATE TO ...

That way you don't need to know the version you are on.