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.
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users
