Обсуждение: Cursor metadata

Поиск
Список
Период
Сортировка

Cursor metadata

От
"Andy Chambers"
Дата:
Hi All,

Is there anywhere in the postgres catalog where one can access metadata
about a held cursor.  Type information
in particular would be really useful.

Cheers,
Andy

--
Andy Chambers

Re: Cursor metadata

От
Tom Lane
Дата:
"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