Thread: Cursor metadata

Cursor metadata

From
"Andy Chambers"
Date:
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

From
Tom Lane
Date:
"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