[Gdal-dev] Newbie queston concerning ogr2ogr for PostgreSQL

[Richard Matsunaga]

Try 'user=postgres' instead. You may need a 'host=' in there as well.
 
Richard

  _____  

From: gdal-dev-bounces at lists.maptools.org
[mailto:gdal-dev-bounces at lists.maptools.org] On Behalf Of Brent Edwards
Sent: January 3, 2007 3:16 PM
To: gdal-dev at lists.maptools.org
Subject: [Gdal-dev] Newbie queston concerning ogr2ogr for PostgreSQL


Why won't this work?:

ogr2ogr -f KML kmltest.kml "PG:dbname=postg
is username=postgres password=pword" -sql "SELECT * FROM district;"

ERROR 1: PQconnectdb failed.
invalid connection option "username"

FAILURE:
Unable to open datasource `PG:dbname=postgis username=postgres
password=pword' w
ith the following drivers.
  -> ESRI Shapefile
  -> MapInfo File
  -> UK .NTF
  -> SDTS
  -> TIGER
  -> S57
  -> DGN
  -> VRT
  -> AVCBin
  -> REC
  -> Memory
  -> CSV
  -> GML
  -> KML
  -> Interlis 1
  -> Interlis 2
  -> SQLite
  -> ODBC
  -> PGeo
  -> OGDI
  -> PostgreSQL
  -> MySQL



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20070103/f9c606ac/attachment.html