> 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 > [email protected] > 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. _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
