Re: How to determine the table a query or a views columns come from?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Frank Church <pgsql(at)adontendev(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to determine the table a query or a views columns come from?
Date: 2006-03-03 23:53:13
Message-ID: 9208.1141429993@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2006-03-04 00:36:14 Re: Updates to my PostgreSQL Wiki
Previous Message Frank Church 2006-03-03 23:21:53 How to determine the table a query or a views columns come from?