[postgis-users] RE: pgsql2shp

[anhtin]

thanks very much all support to me

How can i customize the Query 
Ex: i have Box (295149 2315499, 465992 2163790) 
can I export this box ???




Obe, Regina     DND\MIS wrote:
> 
>  pgsql2shp -f myshp -h myserver -u apguser -P apgpassword mygisdb
> "select * from province WHERE id IN(1,2,3,4,67,34,23,22)"
> 
> Note the myshp is the shapefile name without the suffix
> So if you wanted to output  province.shp and province.dbf you would just
> type in province for myshp
> 
> Hope that helps,
> Regina
> 
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> anhtin
> Sent: Thursday, April 12, 2007 5:34 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] pgsql2shp
> 
> 
> Hi all 
> I am developing application Web use Mapserver and Database Postgis
> I want Export Data Corrdinate in Post Gis to shapfile. But Export with
> condition
> ex: select * from Province where id in '1,2,3,4,67,34,23,22' 
> How can i do that ???
> 
> 
> -- 
> View this message in context:
> http://www.nabble.com/pgsql2shp-tf3564424.html#a9956047
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> -----------------------------------------
> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://www.nabble.com/pgsql2shp-tf3564424.html#a9971889
Sent from the PostGIS - User mailing list archive at Nabble.com.