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: [email protected] [mailto:[email protected]] 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
