Re: Res: Finding all tables that have foreign keys referencing a table - Mailing list pgsql-sql

From Tom Lane
Subject Re: Res: Finding all tables that have foreign keys referencing a table
Date
Msg-id 23487.1226090716@sss.pgh.pa.us
Whole thread Raw
In response to Re: Res: Finding all tables that have foreign keys referencing a table  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-sql
Andreas Joseph Krogh <andreak@officenet.no> writes:
> Needless to say that it would be nice if this information was available in the information_schema, I'm probably not
theonly one spending lots of time in there. It's probably not in in the standard, but i would be a nice PG-extention to
allowretrieving that info in a more intuitive way.
 

Unfortunately, the whole point of information_schema is to be
standardized; the notion of a "PG extension" to it is just wrong.
Feel free to lobby the SQL committee to fix their oversight ...
        regards, tom lane


pgsql-sql by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: Res: Finding all tables that have foreign keys referencing a table
Next
From: "Osvaldo Kussama"
Date:
Subject: Resp.: need help in building a query