Thanks Regina! Il 09/10/20 15:26, Regina Obe ha scritto: >> 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@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. > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users >
-- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users