[postgis-users] rename tables

[Don Drake]

Try running probe_geometry_columns() after renaming.

-Don

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
christian.michels at eifelgeist.com
Sent: Monday, January 30, 2006 2:53 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] rename tables

hi,

I import shp files into postgres and want to rename the imported table. The
problem is that when I rename the table using "alter table foo rename to
foo_1" the entry in the geometry_colums table still points to the foo table.

Is there any postgis function which handles the renaming of tables or do I
have to take care of that by myself using a sql query ?

Thanx for any help

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