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

[Paragon Corporation]

Bruno,
If you are using postgis 1.4+, you can run the populate_geometry_columns
functions.


The only thing to be cautious of is that if you specify it without a table
argument -- it will delete all entries in the geometry_columns table and
rebuild from the constraint definitions or by inspecting the tables/views
that lack constraints but have geometries.  

http://www.postgis.org/documentation/manual-svn/Populate_Geometry_Columns.ht
ml

This is generally okay as it will also take care of views too, but you may
end up with more entries than you bargained for and may be a bit slow if you
have a huge database with many geometry tables that lack spatial
constraints.

Hope that helps,
Regina
 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Bruno
Friedmann
Sent: Saturday, October 10, 2009 5:16 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] real noob question about moving a table from
public to another schema

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


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users