[postgis] pgsql2shp

[Dave Blasby]

simon mercier wrote:
> But if I need to use  the function GeometryFromText(), I need the <'>
> character, the getopt() function in pgsql2shp.c return error...
> 
> pgsql2shp -s 'SELECT * FROM pclp_s WHERE the_geom &&
> GeometryFromText('BOX3D(-71.593372 46.788388,-71.545372
> 46.836388)'::BOX3D,-1)' -f  /tmp/pclp_s test pclp_s
> =
> bash: syntax error near unexpected token `GeometryFromText('BOX3D(-'

Try using the full quote (") instead of the single quote (') around
the sql:
 
pgsql2shp -s "SELECT * FROM pclp_s WHERE the_geom &&
 GeometryFromText('BOX3D(-71.593372 46.788388,-71.545372
 46.836388)'::BOX3D,-1)" -f  /tmp/pclp_s test pclp_s

If that doesnt work, then you could try to escape the innner quotes.

The 'bash' man page should have details on how to do this.

dave

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Tiny Wireless Camera under $80!
Order Now! FREE VCR Commander!
Click Here - Only 1 Day Left!
http://us.click.yahoo.com/WoOlbB/7.PDAA/ySSFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/