[postgis-users] pgsql2shp postgres

[Mark Cave-Ayland]

On Fri, 2007-04-20 at 01:01 -0700, anhtin wrote:
> hi all
> i have command export post to shap file
> pgsql2shp -f myshp -h myserver -u apguser -P apgpassword mygisdb
>  "select * from province WHERE id IN(1,2,3,4,67,34)
>  and geom && SetSRID('BOX3D(295149 2315499, 465992 2163790)'::box3d,-1)"
> but i want run this command on Database Postgres
> How can i do that ????


Hi Anhtin,

You're not far off in your example above: change mygisdb to the name of
your database. Have you tried reading the help file? See pgsql2shp -?
for more information.

Also, the postgres database is actually designed for internal usage
(similar to template0/template1) so you don't really want to be putting
any user data in there...


Kind regards,

Mark.