[Gdal-dev] Newbie queston concerning ogr2ogr for PostgreSQL

[Brent Edwards]

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/504ee63b/attachment.html