view vs. tables used to define that view - Mailing list pgsql-sql

From Emi Lu
Subject view vs. tables used to define that view
Date
Msg-id 4A049E97.7070600@encs.concordia.ca
Whole thread Raw
List 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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Distinct oddity
Next
From: Maximilian Tyrtania
Date:
Subject: Re: Distinct oddity