Check out the pg_* system tables table, you should be able to bulk update the appropriate table to have lower case column names only...
P On Mon, Mar 19, 2012 at 3:58 AM, Simon Greener <si...@spatialdbadvisor.com> wrote: > Birgit, > > I realise that I can do this manually. I was looking for a method for doing > this at the point of loading the shapefile into PostGIS using QGIS. I will > have a look at ogr2ogr to see if that helps. > > Thanks > regards > Simon > > On Mon, 19 Mar 2012 21:00:27 +1100, Birgit Laggner > <birgit.lagg...@vti.bund.de> wrote: > >> 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 >> > > > -- > 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: si...@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 > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
