Re: How to view geometry fields as text?

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Stefan Keller <sfkeller(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: How to view geometry fields as text?
Date: 2008-11-29 15:48:16
Message-ID: 49316440.3070609@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Stefan Keller a écrit :
> Hi all,
>
> I'm using geometry fields which are stored in a large binary
> representation (so called Well Known Binary). Now I'd like to see the
> lines and coordinates stored in it as human readable text.
> Unfortunately, I think, there's currently no way to do this?
>

Nope.

> If yes, I have an idea: There exists a pgsql function called
> 'st_astext(geometry)'. What about extending the dialog 'View filtered
> data' with the possibility to apply functions like this in order to
> view data?
>

You can use this function to filter data, but you can't use it to change
the column's way to display the data.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Stefan Keller 2008-11-29 17:18:52 Re: How to view geometry fields as text?
Previous Message Csaba Együd 2008-11-29 05:33:59 Re: Separate Sessions?? (View data <-> Query tool)