[postgis-users] pgsql2shp help

[Obe, Regina]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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

rwburgholzer at deq.virginia.gov

804-698-4405

Open Source Modeling Tools:

http://sourceforge.net/projects/npsource/

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Dara
Olson
Sent: Friday, October 31, 2008 12:51 PM
To: postgis-users at postgis.refractions.net
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081031/dec748ef/attachment.html>