[postgis-users] PostGIS/Mapserver Mapfile Question

[Stephen Woodbridge]

Mark,

Awesome, that worked great.

So, what is the "correct" procedure if you want to move a table with 
geometry from database to another. Obviously, backup/restore does not do 
the "whole" thing.

-Steve

Mark Cave-Ayland wrote:
>>-----Original Message-----
>>From: postgis-users-bounces at postgis.refractions.net 
>>[mailto:postgis-users-bounces at postgis.refractions.net] On 
>>Behalf Of Stephen Woodbridge
>>Sent: 28 June 2005 18:22
>>To: PostGIS Users Discussion
>>Subject: Re: [postgis-users] PostGIS/Mapserver Mapfile Question
>>
>>
>>OK, it looks like there are no entries in the geometry_columns table. 
>>The zcta table is the only one that currently has a geometry column. 
>>When I did the backup/restore, I did not save the 
>>geometry_columns table 
>>it there and easy way to regenerate this?
>>
>>-Steve
> 
> 
> 
> Hi Steve,
> 
> Sorry if it wasn't clear; the SQL given before should do that job for you.
> The corrected version is:
> 
> BEGIN;
> CREATE TABLE old_geometry_columns WITH OIDS AS SELECT * FROM
> geometry_columns;
> DELETE FROM geometry_columns;
> SELECT probe_geometry_columns();
> COMMIT;
> 
> 
> You can probably delete the old_geometry_columns table once you're done,
> especially as in your case it was empty to begin with :)
> 
> 
> Kind regards,
> 
> Mark.
> 
> ------------------------
> WebBased Ltd
> 17 Research Way
> Tamar Science Park
> Plymouth
> PL6 8BT 
> 
> T: +44 (0)1752 797131
> F: +44 (0)1752 791023
> W: http://www.webbased.co.uk
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>