[postgis-users] Removed double quotes from column and table names
birgit.laggner at vti.bund.de
Mon Mar 19 03:00:27 PDT 2012
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,
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.
More information about the postgis-users