How to view geometry fields as text? - Mailing list pgadmin-support

From Stefan Keller
Subject How to view geometry fields as text?
Date
Msg-id 25bc040b0811281545k2e62081bvc856a4524b470c6e@mail.gmail.com
Whole thread Raw
In response to How to view geometry fields as text?  ("Stefan Keller" <sfkeller@gmail.com>)
Responses Re: How to view geometry fields as text?  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
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?

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?

Stefan


pgadmin-support by date:

Previous
From: "Willy-Bas Loos"
Date:
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Next
From: Csaba Együd
Date:
Subject: Re: Separate Sessions?? (View data <-> Query tool)