The U should be lower case u.
pgsql2shp -f "/path/to/streets" -h myserver -u apguser -P apgpassword
mygisdb ma.streets
This cheatsheet might help
http://www.bostongis.com/pgsql2shp_shp2pgsql_quickguide.bqg?outputformat
=PDF
Hope that helps,
Regina
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Burgholzer,Robert
Sent: Friday, October 31, 2008 4:01 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] pgsql2shp help
Dara,
I think that it might have a problem with your file path. As I think the
previous respondent was indicating, it may work OK if you use a file
name without directory prefixes.
Robert W. Burgholzer
Surface Water Modeler
Office of Water Supply and Planning
Virginia Department of Environmental Quality
[EMAIL PROTECTED]
804-698-4405
Open Source Modeling Tools:
http://sourceforge.net/projects/npsource/
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dara
Olson
Sent: Friday, October 31, 2008 12:51 PM
To: [email protected]
Subject: [postgis-users] pgsql2shp help
Greetings. I am VERY new to all of this and teaching myself, but I am
attempting to convert one of the tables back to an ESRI shapefile using
the following:
pgsql2shp -f d:/shapefiles/dara -p 5432 -U dara -g the_geom postgis
invspp
[postgis (database) and invspp (table)]
I get an error stating "invalid option or command parameters". I have
done many searches and used various examples, but can't seem to get it
to work. Would anyone know what is wrong with the command?
Any help would be greatly appreciated!
miigwech!
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
