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

[Bruno Friedmann]

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: 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

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