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

Simon Greener simon at spatialdbadvisor.com
Sun Mar 18 22:03:50 PDT 2012


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
-- 
Holder of "2011 Oracle Spatial Excellence Award for Education and Research."
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
   Email: simon at spatialdbadvisor.com
   Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
NAC:W80CK 7SWP3



More information about the postgis-users mailing list