From: | "Jan Meyland Andersen" <jma(at)agile(dot)dk> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Related tables to a view |
Date: | 2006-12-25 21:52:03 |
Message-ID: | 1404.62.66.218.59.1167083523.squirrel@mail.agile.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi
I need a function which are able to return the underlying tables to a view.
If I have a view which is a selection from field1 and field2 from table1
and field1 and field2 from table2.
How can I make a selection which returns the relation for the fields in a
way so I am able to se which field belongs to which table.
SELECT * FROM pg_views WHERE viewname='TestView' will return the schema
and the definition for me.
SELECT * FROM pg_class WHERE relname = 'TestView' will return some oids etc.
SELECT * FROM pg_attribute JOIN pg_class ON attrelid = pg_class.oid AND
pg_class.relname='TestView' will return the fields including oids etc.
But I just cant find out how to find the tables for each field.
I hope someone are able to help me with this problem.
Regards
Jan Andersen
From | Date | Subject | |
---|---|---|---|
Next Message | Guy Rouillier | 2006-12-25 23:45:31 | Re: NEED URGENT HELP.... |
Previous Message | Harpreet Dhaliwal | 2006-12-25 17:32:17 | Re: [GENERAL] NEED URGENT HELP.... |