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-22 19:47:04
Message-ID: 25bc040b0811221147w6c115edj368e13b16e3274c6@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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Csaba Együd 2008-11-25 14:06:23 Separate Sessions?? (View data <-> Query tool)
Previous Message johnf 2008-11-21 14:45:34 Re: dumb ?