Take the 2-minute tour ×  I want to rename one of my postGIS
tables. However, when I do this by applying a simple  ALTER
TABLE old_name RENAME TO new_name;  The spatial data, as I
understand it, isn't updated with the new name. First, can these
references be fixed by running the function:  SELECT
probe_geometry_columns()  Is the table itself OK after this? Or
should other measures be taken also? Second, how do I update
GeoServer so that it finds this new table? As of now, if I run
the above commands, and edit the layer info on the GeoServer to
point to the new name... I still get an error (GeoServer still
tries to find it under the old name). Exactly, where should the
layer name be changed on the GeoServer?  share|improve this
question add comment  4 Answers  up vote 2 down vote accepted
In order to rename the table you will have to change the name in
the metadata of two places. First on PostGIS, then on the
Geoserver config.  To change the PostGIS one, you can update the
geometry_columns directly. Although