<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=481141221-03012007>Try 'user=postgres' instead. You may need a 'host=' in
there as well.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=481141221-03012007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=481141221-03012007>Richard</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> gdal-dev-bounces@lists.maptools.org
[mailto:gdal-dev-bounces@lists.maptools.org] <B>On Behalf Of </B>Brent
Edwards<BR><B>Sent:</B> January 3, 2007 3:16 PM<BR><B>To:</B>
gdal-dev@lists.maptools.org<BR><B>Subject:</B> [Gdal-dev] Newbie queston
concerning ogr2ogr for PostgreSQL<BR></FONT><BR></DIV>
<DIV></DIV>Why won't this work?:<BR><BR>ogr2ogr -f KML kmltest.kml
"PG:dbname=postg<BR>is username=postgres password=pword" -sql "SELECT * FROM
district;"<BR><BR>ERROR 1: PQconnectdb failed.<BR>invalid connection option
"username"<BR><BR>FAILURE:<BR>Unable to open datasource `PG:dbname=postgis
username=postgres password=pword' w<BR>ith the following drivers.<BR>
-> ESRI Shapefile<BR> -> MapInfo File<BR> -> UK
.NTF<BR> -> SDTS<BR> -> TIGER<BR> -> S57<BR>
-> DGN<BR> -> VRT<BR> -> AVCBin<BR> ->
REC<BR> -> Memory<BR> -> CSV<BR> -> GML<BR>
-> KML<BR> -> Interlis 1<BR> -> Interlis 2<BR> ->
SQLite<BR> -> ODBC<BR> -> PGeo<BR> -> OGDI<BR>
-> PostgreSQL<BR> -> MySQL<BR><BR>
<P>__________________________________________________<BR>Do You Yahoo!?<BR>Tired
of spam? Yahoo! Mail has the best spam protection around
<BR>http://mail.yahoo.com </P></BODY></HTML>