[postgis-users] Postgis to Text File

[Bob Pawley]

Thanks Henri

How do I extract it from the server to a text file??

Bob


From: Henri De Feraudy 
Sent: Wednesday, September 22, 2010 10:09 AM
To: PostGIS Users Discussion 
Subject: Re: [postgis-users] Postgis to Text File


Hi,
  The ST_AsText function is useful in this regards for converting a geometry into Well Known Text.
  So SELECT ST_AsText(the_geom) from my table;
  will return the geometry information as strings.
  The inverse is accomplished with ST_GeomAsText
hth
Henri



--------------------------------------------------------------------------------
From: Bob Pawley <rjpawley at shaw.ca>
To: postgis-users at postgis.refractions.net
Sent: Wed, September 22, 2010 6:01:14 PM
Subject: [postgis-users] Postgis to Text File


Hi

I have forgotten how to extract postgis information to a text file and haven't found any info on it.

Any help would be appreciated.

Bob


--------------------------------------------------------------------------------


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100922/3abbfbce/attachment.html>