PL/Python result metadata

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: PL/Python result metadata
Date: 2012-01-11 20:05:34
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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)

I just made that up because there is no guidance in the other standard
PLs for this sort of thing, AFAICT.

Patch attached. Comments welcome.

Attachment Content-Type Size
plpy-result-metadata.patch text/x-patch 5.8 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2012-01-11 20:16:00 Re: PL/Python result metadata
Previous Message Josh Berkus 2012-01-11 18:59:40 Re: Sending notifications from the master to the standby