Related tables to a view

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

Responses

Browse pgsql-sql by date

  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....