Cursor metadata

Started by Andy Chambersalmost 15 years ago2 messagesgeneral
Jump to latest
#1Andy Chambers
achambers@mcna.net

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Andy Chambers (#1)
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