OGR2OGR Postgresql field names

[Frank Warmerdam]

Tyler Mitchell wrote:
> Frank, I'm using ogr2ogr to postgis and, as I believe you have noted, I
> find that the field names end up being a bit irritating and I have to quote
> them and capitalize them when I'm running queries, etc. Is there any plan
> to convert the field names to simple lower case names? Know what I mean?
> In all, ogr2ogr sure works great with coverages. Sure beats doing
> coverage->OGR->shp->shp2pgsql which is the other alternative.

Tyler,

I can imagine a few ways of doing this.

One would be to provide a way of overriding output column names in ogr2ogr
but then you would have to set each column by hand.

Another would be to provide a "layer creation option" to the Postgres/PostGIS
driver that would cause it to flatten the names.

I don't have any immediate plans on doing this but I would be interested
in opinion on how it should be done.

Best regards,

-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam at p...
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent