[postgis-users] Moving PostGIS to a different schema

[Paolo Cavallini]

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 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.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at 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