Re: PL/Python result metadata - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: PL/Python result metadata
Date
Msg-id 1326312916-sup-6114@alvh.no-ip.org
Whole thread Raw
In response to PL/Python result metadata  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: PL/Python result metadata  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Excerpts from Peter Eisentraut's message of mié ene 11 17:05:34 -0300 2012:
> There is currently no reliable way to retrieve from a result object in
> PL/Python the number, name, or type of the result columns.  You can get
> the number and name if the query returned more than zero rows by looking
> at the row dicts, but that is unreliable.  The type information isn't
> available at all.
>
> I propose to add two functions to the result object:
>
> .colnames() returns a list of column names (strings)
> .coltypes() returns a list of type OIDs (integers)

No typmods?

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: PL/Python result metadata
Next
From: Peter Eisentraut
Date:
Subject: psql case preserving completion