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

From Guillaume Lelarge
Subject Re: How to view geometry fields as text?
Date
Msg-id 49316440.3070609@lelarge.info
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?  ("Stefan Keller" <sfkeller@gmail.com>)
List 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.orghttp://dalibo.com


pgadmin-support by date:

Previous
From: Csaba Együd
Date:
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Next
From: "Stefan Keller"
Date:
Subject: Re: How to view geometry fields as text?