Re: Res: Finding all tables that have foreign keys referencing a table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
Cc: pgsql-sql(at)postgresql(dot)org, paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
Subject: Re: Res: Finding all tables that have foreign keys referencing a table
Date: 2008-11-07 20:45:16
Message-ID: 23487.1226090716@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Andreas Joseph Krogh <andreak(at)officenet(dot)no> writes:
> Needless to say that it would be nice if this information was available in the information_schema, I'm probably not the only one spending lots of time in there. It's probably not in in the standard, but i would be a nice PG-extention to allow retrieving 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Osvaldo Kussama 2008-11-07 20:51:03 Resp.: need help in building a query
Previous Message Andreas Joseph Krogh 2008-11-07 20:34:44 Re: Res: Finding all tables that have foreign keys referencing a table