| 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: | Whole Thread | Raw Message | 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.... |