Postgres Pro
Downloads
Home   >   mailing lists

Re: How to determine the table a query or a views columns come from? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to determine the table a query or a views columns come from?
Date
Msg-id 9208.1141429993@sss.pgh.pa.us
Whole thread Raw
In response to How to determine the table a query or a views columns come from?  (Frank Church <pgsql@adontendev.net>)
Responses Re: How to determine the table a query or a views columns come from?  (Frank Church <pgsql@adontendev.net>)
Re: REPOST: How to determine the table a query or a views columns come from?  (Frank Church <pgsql@adontendev.net>)
List pgsql-general
Tree view 
Frank Church <pgsql@adontendev.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

pgsql-general by date:

Previous
From: Frank Church
Date:
Subject: How to determine the table a query or a views columns come from?
Next
From: Michael Glaesemann
Date:
Subject: Re: Updates to my PostgreSQL Wiki