On Wed, Dec 15, 2010 at 1:25 PM, Daniele Varrazzo <[email protected]> wrote: > Hello, > > when a query returns a composite type, the libpq PQftype() function > reports the oid of the "record" type. In psycopg: > > >>> cur.execute("select (1,2)") > >>> cur.description > (('row', 2249, None, -1, None, None, None),) > > test=# select typname from pg_type where oid = 2249; > typname > --------- > record > > Is there a way to recursively retrieve the types for the record components?
not without talking to the server, unless you had previously pulled pg_attribute data. select * from pg_attribute where attrelid = 2249; This question is more appropriate for -general, but what are you trying to do? merlin -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
