Skip site navigation (1) Skip section navigation (2)

Re: How to view geometry fields as text?

From: "Stefan Keller" <sfkeller(at)gmail(dot)com>
To: "Guillaume Lelarge" <guillaume(at)lelarge(dot)info>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: How to view geometry fields as text?
Date: 2008-11-29 17:18:52
Message-ID: 25bc040b0811290918n7b5d2d8dyae161f1badf67598@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
Salut Guillaume,

Guillaume Lelarge wrote:
>> (...) 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.

Ok, fine.

But what about extending pgadmin with such a functionality?
This could be useful for many data types.

Stefan
2008/11/29 Guillaume Lelarge <guillaume(at)lelarge(dot)info>:
> 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

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2008-11-29 17:24:13
Subject: Re: How to view geometry fields as text?
Previous:From: Guillaume LelargeDate: 2008-11-29 15:48:16
Subject: Re: How to view geometry fields as text?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group