Quoting Tom Lane <tgl@xxxxxxxxxxxxx>: Quoting Tom Lane <tgl@xxxxxxxxxxxxx>: 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@xxxxxxxxxxxxxx> 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 >
