[Gdal-dev] ogr2ogr issue with postgis

[Frank Warmerdam]

Tommie M. Jones wrote:
> Hello,
> I am trying to use ogr2ogr on postgres7.4 and postgis. It converts tiger
> data to postgis. My command line looks like the following
> 
> /usr/local/gz-packages/openev_FW/bin/ogr2ogr -f PostgreSQL PG:dbname=billboard TGR13001 -lco LAUNDER=YES
> 
> I do a \dt and all the tables list.
> However when I try and look at an individual table the following happens.
> 
> billboard=# select * from ZipPlus4
> billboard-# ;
> ERROR:  relation "zipplus4" does not exist
> billboard=# \d zipplus4
> Did not find any relation named "zipplus4".

Tommie,

The problem is related to use of mixed case in table names.  You need to
quote mixed case table names.  I think something like:

  select * from "ZipPlus4";

I thought I had changed the code to "launder" table names as well as
field names.  Apparently I did not.

Best regards,

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