pgsql2shp Examples

Database on different machine, authentication required

pgsql2shp -f myshp -h myserver -u apguser -P mypassword -g mygeomfield mydatabase mytable

Database on same machine, trusted user, no need for host

pgsql2shp -f myshp mydatabase mytable

Using an sql statement instead of table

pgsql2shp -f myshp -h myserver -u apguser -P mypassword -g mygeomfield mydatabase "select parcel_id, the_geom from parcels where neighborhood='DORCHESTER'"

Where myshp is the shapefile name without the .shp extension