[postgis] pgsql2shp

[simon mercier]

tank's dave
the answer is: \' BETWEEN single quote...

>>pgsql2shp -s 'select * from pclp_s WHERE the_geom && Geome
    tryFromText('\''BOX3D(-71.593372 46.788388,-71.545372
46.836388)'\''::BOX3D,-1)'
    -f /tmp/pclp_s test test

Dave Blasby a écrit :

> 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
>
>
> 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/

--
Simon Mercier
Technicien en Géomatique
Direction des technologies de l'information
La Financière agricole du Québec
5825, rue Saint-Georges
Lévis, Québec,Canada G6V 4L2
http://www.financiereagricole.qc.ca/

Tel:(418)-838-5614 ext:6043
Fax:(418)-833-6145



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/