[postgis-users] rename tables

christian.michels at eifelgeist.com christian.michels at eifelgeist.com
Mon Jan 30 00:52:40 PST 2006


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



More information about the postgis-users mailing list