Postgres Pro
Downloads
Home   >   mailing lists

Re: Extracting data from the view to retrieve the foreign key is not declared - Mailing list pgsql-general

From nill
Subject Re: Extracting data from the view to retrieve the foreign key is not declared
Date
Msg-id 1394547181838-5795524.post@n5.nabble.com
Whole thread Raw
In response to Re: Extracting data from the view to retrieve the foreign key is not declared  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view 
Laurenz Thanks for your reply, it is going to help me.

I use this query to get the dependencies of view with the objects in the db
SELECT *
FROM INFORMATION_SCHEMA.view_column_usage

I now have to explain the attributes of the join tree, that is JOIN
expressions e JOIN clauses.

Thanks




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Extracting-data-from-the-view-to-retrieve-the-foreign-key-is-not-declared-tp5795408p5795524.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: matshyeq
Date:
Subject: Re: libpq - lack of support to set the fetch size
Next
From: Tom Lane
Date:
Subject: Re: How to make PG use work_mem?