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.
I have got to find if libpq's output is exposed in PHP or Ruby.
> 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 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
