[postgis-users] real noob question about moving a table from public to another schema

Bruno Friedmann bruno at ioda-net.ch
Sat Oct 10 02:16:02 PDT 2009


Thank you Mike, I've also discover that if you restore a postgis table with the pg_restore, It doesn't automagically recreate
the corresponding record in geometry_columns even if the table have contrainst and gist index.
(But that's easy to do manually)


Mike Toews wrote:
> For PostgreSQL 8.1 and above, this should work:
> 
> ALTER TABLE name SET SCHEMA new_schema;
> 
> http://www.postgresql.org/docs/current/interactive/sql-altertable.html
> 
> -Mike
> 
> Bruno Friedmann wrote:
>> I receive some dump (compress -custom) which restore table inside
>> public schema.
>>
>> I need to move them into another schema (postgis table).
>> Postgis is installed inside public.
>> Is there a quick way to move it without a new dump ?
>> (some hundred of gigabit and milions of rows to move)
>>
>>   



-- 

     Bruno Friedmann





More information about the postgis-users mailing list