Re: PL/Python result metadata

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-01-11T20:16:00Z
Lists: 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