Cursor metadata
Started by Andy Chambersalmost 15 years ago2 messagesgeneral
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
"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