Quoting Tom Lane <[EMAIL PROTECTED]>: Quoting Tom Lane <[EMAIL PROTECTED]>:
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 <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings