Hi Simon,
I would think RENAME would do what you want:
ALTER TABLE schema."TableName" RENAME TO tablename;
ALTER TABLE schema.tablename RENAME COLUMN "ColumnName" TO columnname;
Hope that helps,
Birgit.
Am 19.03.2012 06:03, schrieb Simon Greener:
Is there any way to remove the double quotes created around a table or
its column names?
My names do NOT include spaces but do include mixed case. I wish to
remove the quotes and
lower case all names.
How can this be done?
Note: the tables were loaded by QGIS into PostgreSQL. In the DBF file
the names are mixed case.
I can see nothing in the PostGIS/QGIS plugin SPIT that allows me to
tell it to lower case all names.
S
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
