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

Frank Church wrote:
> Quoting Tom Lane <tgl@sss.pgh.pa.us>:
>
> 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 <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().

Do you need this?

test=# \d x
               View "public.x"
  Column |         Type          | Modifiers
--------+-----------------------+-----------
  name   | character varying(50) |
View definition:
  SELECT questions.name
    FROM questions;


If you need to see what query "\d x" is running, start psql with -E and
it will show it.

--
Postgresql & php tutorials
http://www.designmagick.com/