<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'Courier New', courier, monaco, monospace, sans-serif;font-size:12pt"><div>Hi,</div><div> The ST_AsText function is useful in this regards for converting a geometry into Well Known Text.</div><div> So SELECT ST_AsText(the_geom) from my table;</div><div> will return the geometry information as strings.</div><div> The inverse is accomplished with ST_GeomAsText</div><div>hth</div><div>Henri</div><div style="font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><br><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Bob Pawley <rjpawley@shaw.ca><br><b><span style="font-weight: bold;">To:</span></b> postgis-users@postgis.refractions.net<br><b><span
style="font-weight: bold;">Sent:</span></b> Wed, September 22, 2010 6:01:14 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [postgis-users] Postgis to Text File<br></font><br>
<div><font face="Calibri">Hi</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">I have forgotten how to extract postgis information
to a text file and haven't found any info on it.</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">Any help would be appreciated.</font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">Bob</font></div>
</div></div><div style="position:fixed"></div>
</div></body></html>