How to view geometry fields as text?

From: "Stefan Keller" <sfkeller(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: How to view geometry fields as text?
Date: 2008-11-28 23:45:42
Message-ID: 25bc040b0811281545k2e62081bvc856a4524b470c6e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Csaba Együd 2008-11-29 05:33:59 Re: Separate Sessions?? (View data <-> Query tool)
Previous Message Willy-Bas Loos 2008-11-28 21:20:20 Re: Separate Sessions?? (View data <-> Query tool)