Re: [postgis-users] ogr2ogr S57 question
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 postgis821.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@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
Re: [postgis-users] ogr2ogr S57 question
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 postgis821.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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ogr2ogr S57 question
Try: SELECT * FROM "FAIRWY"; uppercase column names must be quoted to preserve the case. -Steve 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 postgis821.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 ___ 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
[postgis-users] ogr2ogr S57 question
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 postgis821.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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users