[postgis-users] Postgis to Text File

[Henri De Feraudy]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100922/8e096170/attachment.html>