Re: Cursor metadata - Mailing list pgsql-general

From Tom Lane
Subject Re: Cursor metadata
Date
Msg-id 6935.1302713434@sss.pgh.pa.us
Whole thread Raw
In response to Cursor metadata  ("Andy Chambers" <achambers@mcna.net>)
List 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 by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Adding a default value to a column after it exists
Next
From: "David Johnston"
Date:
Subject: Re: updating rows which have a common value forconsecutive dates