Re: How to view geometry fields as text?

Поиск
Список
Период
Сортировка
От Stefan Keller
Тема Re: How to view geometry fields as text?
Дата
Msg-id 25bc040b0811290918n7b5d2d8dyae161f1badf67598@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to view geometry fields as text?  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: How to view geometry fields as text?  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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@lelarge.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
>


В списке pgadmin-support по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: How to view geometry fields as text?
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: How to view geometry fields as text?