Re: Cursor metadata

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cursor metadata
Дата
Msg-id 6935.1302713434@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Cursor metadata  ("Andy Chambers" <achambers@mcna.net>)
Список pgsql-general
"Andy Chambers" <achambers@mcna.net> writes:
> Is there anywhere in the postgres catalog where one can access metadata
> about a held cursor.

The pg_cursors system view offers some info ...

> Type information
> in particular would be really useful.

... but not that.  Usually the best way to get information about the
columns of a table/view/cursor is to fetch a row from it and use the
metadata that's provided by the fetch mechanism.

            regards, tom lane

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Adding a default value to a column after it exists
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: updating rows which have a common value forconsecutive dates