[postgis-users] Removed double quotes from column and table names

[Birgit Laggner]

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