Quoting Tom Lane <tgl@sss.pgh.pa.us>:
Quoting Tom Lane <tgl@sss.pgh.pa.us>:
Can this info be obtained by querying the system tables,
especially in the case of views? I am using 'scripting' languages and using C
will be quite awkward.
> Frank Church <pgsql@adontendev.net> writes:
> > Is there way to determine the table a query or a view's columns come from?
>
> Yeah, there's some support for that in the protocol. libpq exposes it
> as PQftable() and PQftablecol().
>
> regards, tom lane
>