view vs. tables used to define that view

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: view vs. tables used to define that view
Date: 2009-05-08 21:05:27
Message-ID: 4A049E97.7070600@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

May I know is it possible to query dictionary table(s) in order to
return relationship between a view and table(s) please?

For example, create view v1 as (select ... from T1 left join T2 ... )

Result:
view Name | Table Name
====================
v1 | T1
v1 | T2

Thanks a lot!
Lu Ying

Browse pgsql-sql by date

  From Date Subject
Next Message Maximilian Tyrtania 2009-05-09 07:22:24 Re: Distinct oddity
Previous Message Tom Lane 2009-05-08 19:52:43 Re: Distinct oddity