Re: Related tables to a view

["Jan Meyland Andersen" <jma(at)agile(dot)dk>]

> You could query pg_depend to find out which tables and columns the
> view's rewrite rule depends on but that's not as specific as what
> you're requesting.  I'm not aware of a way to associate a particular
> table column with a particular view column short of parsing the view
> definition or rule action; doing so would have to allow for the
> possibility of a view column deriving its value from an arbitrarily
> complex expression involving multiple tables, subqueries, etc.

I have been thinking the problem through again, and I think I am able to
solve the problem if I just know which tables the view is using.

But how do I get this information from the pg_depend table?

Regards

Jan