pw <p(dot)willis(at)telus(dot)net> writes:
>> I am curious if there is a postgresql function that will
>> return a list of header names based on an input query text.
No, but there is support for such things at the wire protocol level
--- specifically, Parse followed by Describe Statement would get you
the result column names and types. How much of that is exposed by
the interface library you use would depend on the library; in recent
libpq versions you would use PQprepare then PQdescribePrepared.
regards, tom lane