RowDescription for a function does not include table OID - Mailing list pgsql-interfaces

From Maxwell Dreytser
Subject RowDescription for a function does not include table OID
Date
Msg-id LV3PR16MB6001AF4D05893E9FF4B3C746E6CE2@LV3PR16MB6001.namprd16.prod.outlook.com
Whole thread Raw
Responses Re: RowDescription for a function does not include table OID
List pgsql-interfaces
Hello,

I am working on a meta-programming use-case where I need to scrape some detailed information about the results of a
functioncall that "RETURNS TABLE (LIKE physical_table)". Unfortunately RowDescription messages don't contain nearly
enoughinformation (no nullability). In pg_type the pg_proc.prorettype of this function shows up as a composite type
witha valid typrelid. I am interested in getting this typrelid in the RowDescription field table OID field and the
respectiveattribute number field. This would allow me to figure out all the necessary information by looking up in
pg_attribute.

If this is something that might be accepted, I would be willing to work on a patch to implement this change.

Thank you,
Maxwell.


pgsql-interfaces by date:

Previous
From: Ibrahim Shaame
Date:
Subject: [MASSMAIL]can't run setup.py in pgAdmin4
Next
From: Tom Lane
Date:
Subject: Re: RowDescription for a function does not include table OID