[gdal-dev] RE: ogr2ogr PostgreSQL to shp

[Randy George]

Hi,

 

I'm attempting to extract a subset of a PostGIS table to shp using this
windows command line:

 

"C:\Program Files\FWTools2.1.0\bin\ogr2ogr" --debug on -where " fips =
'08041' " -f "ESRI Shapefile" out.shp PG:"user=user dbname=db host=localhost
password=pass port=5432" gnis

 

Here is the debug output:

OGR_PG: DBName="db"

OGR_PG: PostSIS version string: '1.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1' ->
'1.3'

 

OGR_PG: POSTGIS_VERSION=1.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

ERROR 1: PG:user=user dbname=db host=localhost password=pass port=54

32 is neither a file or directory, Geoconcept access failed.

 

FAILURE:

Unable to open datasource `PG:user=user dbname=db host=localhost
password=pass port=5432' with the following drivers.

 

Where am I going wrong?

 

thanks

randy

 

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