[SQL] how to get the source table & field name of a view field

[Prime Ho]

Hi,

Could you tell me how to get view field's source table and field name?
another word, how could I know the view field come from?

Regards,
Ho



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] get source table.field name from view's field

[Prime Ho]

Hi,
Firstly , sorry about my poor english, I'll do my best to explain what I
want.
Actually, in most cases, We do query via view, in order to improve
the query speed, we'll create index in physical table field that is mapped
in view's where statement. So, I got an idea to store view statement in a
DataDictionay,
while I maintain the DataDictionary's sql statement, program will trigger a
function
to  parse the sql statement, and create index in relative table field
automatically.
So, the problem is how to get the source table & field name for create
index,
could it achieve by oid or postgresql already have function to do that?

Regards,
Ho.



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]