<!DOCTYPE html><html><head>
<style type="text/css">"body { font-family:'Times New Roman'; font-size:13px"}</style>
</head>
<body><div>Thanks all for the suggestions.</div><div>S<br>On Tue, 20 Mar 2012 05:10:28 +1100, Lee Hachadoorian <Lee.Hachadoorian+L@gmail.com> wrote:<br></div><br><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex">This option is not available via SPIT, but ogr2ogr does allow it as a layer creation option:<br><br>"LAUNDER: This may be "YES" to force new fields created on this layer to have their field names "laundered" into a form more compatible with PostgreSQL. This converts to lower case and converts some special characters like "-" and "#" to "_". If "NO" exact names are preserved. The default value is "YES". If enabled the table (layer) name will also be laundered." (<a href="http://www.gdal.org/ogr/drv_pg.html">http://www.gdal.org/ogr/drv_pg.html</a>)<br>
<br>Also shp2pgsql defaults to forcing lower case names (the correct choice, IMHO), but has an option to specify preserving case.<br><br>Best,<br>--Lee<br><br><br><div class="gmail_quote">On Mon, Mar 19, 2012 at 6:58 AM, Simon Greener <span dir="ltr"><<a href="mailto:simon@spatialdbadvisor.com">simon@spatialdbadvisor.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Birgit,<br>
<br>
I realise that I can do this manually. I was looking for a method for doing<br>
this at the point of loading the shapefile into PostGIS using QGIS. I will<br>
have a look at ogr2ogr to see if that helps.<br>
<br>
Thanks<br>
regards<br><font color="#888888">
Simon</font><div><div class="h5"><br>
On Mon, 19 Mar 2012 21:00:27 +1100, Birgit Laggner <<a href="mailto:birgit.laggner@vti.bund.de" target="_blank">birgit.laggner@vti.bund.de</a>> wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Hi Simon,<br>
<br>
I would think RENAME would do what you want:<br>
<br>
ALTER TABLE schema."TableName" RENAME TO tablename;<br>
<br>
ALTER TABLE schema.tablename RENAME COLUMN "ColumnName" TO columnname;<br>
<br>
Hope that helps,<br>
<br>
Birgit.<br>
<br>
<br>
Am 19.03.2012 06:03, schrieb Simon Greener:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Is there any way to remove the double quotes created around a table or<br>
its column names?<br>
My names do NOT include spaces but do include mixed case. I wish to<br>
remove the quotes and<br>
lower case all names.<br>
How can this be done?<br>
Note: the tables were loaded by QGIS into PostgreSQL. In the DBF file<br>
the names are mixed case.<br>
I can see nothing in the PostGIS/QGIS plugin SPIT that allows me to<br>
tell it to lower case all names.<br>
S<br>
</blockquote>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
</blockquote>
<br>
<br></div></div><div class="im">
-- <br>
Holder of "2011 Oracle Spatial Excellence Award for Education and Research."<br>
SpatialDB Advice and Design, Solutions Architecture and Programming,<br>
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional<br>
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.<br>
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.<br>
Website: <a href="http://www.spatialdbadvisor.com" target="_blank">www.spatialdbadvisor.com</a><br>
Email: <a href="mailto:simon@spatialdbadvisor.com" target="_blank">simon@spatialdbadvisor.com</a><br>
Voice: <a href="tel:%2B61%20362%20396397" value="+61362396397" target="_blank">+61 362 396397</a><br>
Mobile: <a href="tel:%2B61%20418%20396391" value="+61418396391" target="_blank">+61 418 396391</a><br>
Skype: sggreener<br>
Longitude: 147.20515 (147° 12' 18" E)<br>
Latitude: -43.01530 (43° 00' 55" S)<br>
GeoHash: r22em9r98wg<br>
NAC:W80CK 7SWP3<br></div><div><div class="h5">
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br>
</blockquote><br><br><br><div id="M2Signature"><div>-- </div><div>Holder of "2011 Oracle Spatial Excellence Award for Education and Research."<br>SpatialDB Advice and Design, Solutions Architecture and Programming,<br>Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional<br>Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.<br>39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.<br>Website: www.spatialdbadvisor.com<br> Email: simon@spatialdbadvisor.com<br> Voice: +61 362 396397<br>Mobile: +61 418 396391<br>Skype: sggreener<br>Longitude: 147.20515 (147° 12' 18" E)<br>Latitude: -43.01530 (43° 00' 55" S)<br>GeoHash: r22em9r98wg<br>NAC:W80CK 7SWP3</div></div></body></html>