Thanks Regina, not yet 1.4 ( only 1.3 for the moment ) But I retain the tips, which would be very usefull.
For the moment I simply populate geometry_columns in public by hand ( only 12 entries to create so quiet simple) Paragon Corporation wrote: > 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 Ioda-Net Sàrl 2830 Vellerat - Switzerland Tél : ++41 32 435 7171 Fax : ++41 32 435 7172 gsm : ++41 78 802 6760 www.ioda-net.ch Centre de Formation et de Coaching En Ligne www.cfcel.com _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
