Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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(at)adontendev(dot)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
>