[postgis-users] ogr2ogr S57 question

[Kurt Schwehr]

Mark and Stephen,

Thanks much!!!  That did it.

-kurt

On Jun 24, 2007, at 1:07 PM, Mark Cave-Ayland wrote:

> On Sun, 2007-06-24 at 12:34 -0400, Kurt Schwehr wrote:
>> Hi All,
>>
>> I'm having trouble with a NOAA electronic chart that I am trying to
>> put into postgres without success.  I don't seem to be able to access
>> the tables.
>>
>> http://vislab-ccom.unh.edu/~schwehr/ENC/NOAA/US5NH02M.000.bz2
>>
>> Here is what I am doing an the error that I am getting... using Mac
>> OSX 10.4.10 with fink
>>
>> i   postgis82            1.2.1-1024      PostgreSQL geographic object
>> support
>> i   postgresql82         8.2.4-1021      PostgreSQL open-source  
>> database
>> i   postgresql82-dev     8.2.4-1021      PostgreSQL development
>> headers and libraries
>> i   postgresql82-shlibs  8.2.4-1021      PostgreSQL shared libraries
>>
>> createdb s57
>> sudo -u postgres /sw/bin/psql-8.2 -f /sw/share/doc/postgis82/
>> lwpostgis.sql -d s57
>> ogr2ogr -f PostgreSQL PGL:dbname=s57 US5NH02M.000
>>
>> psql -l
>>          List of databases
>>     Name    |  Owner   | Encoding
>> -----------+----------+-----------
>> ais       | postgres | SQL_ASCII
>> postgres  | postgres | SQL_ASCII
>> s57       | schwehr  | SQL_ASCII
>> template0 | postgres | SQL_ASCII
>> template1 | postgres | SQL_ASCII
>>
>>
>> psql s57
>> # Paste in the create command from pgadmin
>> ERROR:  relation "FAIRWY" already exists
>> # Okay... so it looks like it is there until I try to select anything
>> from it...
>> s57=# SELECT * FROM FAIRWY;
>> ERROR:  relation "fairwy" does not exist
>>
>> What am I doing wrong?
>>
>> Thanks!
>> -kurt
>
> Hi Kurt,
>
> PostgreSQL folds table names to lower case unless they are quoted in
> double quotes - what does SELECT * FROM "FAIRWY" give you? Also
> you can get a listing of tables in the database by using \d in psql.
>
>
> HTH,
>
> Mark.
>
> -- 
> ILande - Open Source Consultancy
> http://www.ilande.co.uk
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users