[postgis-users] Postgis to Text File

[MarkW]

Bob - using that sql statement with the COPY command. Examples here:
http://www.postgresql.org/docs/8.4/static/sql-copy.html

Mark

On Wed, Sep 22, 2010 at 1:59 PM, Bob Pawley <rjpawley at shaw.ca> wrote:
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>