<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<STYLE type=text/css><!-- DIV {margin:0px;} --></STYLE>
<META name=GENERATOR content="MSHTML 8.00.7600.16625"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Calibri>Thanks Henri</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>How do I extract it from the server to a text
file??</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>Bob</FONT></DIV>
<DIV style="FONT: 10pt Tahoma">
<DIV><BR></DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=feraudyh@yahoo.com
href="mailto:feraudyh@yahoo.com">Henri De Feraudy</A> </DIV>
<DIV><B>Sent:</B> Wednesday, September 22, 2010 10:09 AM</DIV>
<DIV><B>To:</B> <A title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users Discussion</A>
</DIV>
<DIV><B>Subject:</B> Re: [postgis-users] Postgis to Text File</DIV></DIV></DIV>
<DIV><BR></DIV>
<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 <<A
href="mailto:rjpawley@shaw.ca">rjpawley@shaw.ca</A>><BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><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>
<P>
<HR>
<P></P>_______________________________________________<BR>postgis-users mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></BODY></HTML>