[SQL] view vs. tables used to define that view

[Emi Lu]

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


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql