[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Moving PostGIS to a different schema
From:       Paolo Cavallini <cavallini () faunalia ! it>
Date:       2020-10-09 13:40:27
Message-ID: f86b6661-f784-eaed-591a-05916a5a1050 () faunalia ! it
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]