Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D03BA9F95BB for ; Sun, 26 Aug 2007 20:35:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 63947-07 for ; Sun, 26 Aug 2007 20:35:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 72BAA9F95B9 for ; Sun, 26 Aug 2007 20:35:36 -0300 (ADT) Received: (qmail invoked by alias); 26 Aug 2007 23:35:34 -0000 Received: from i3ED6D8A9.versanet.de (EHLO [192.168.0.112]) [62.214.216.169] by mail.gmx.net (mp037) with SMTP; 27 Aug 2007 01:35:34 +0200 X-Authenticated: #14269776 X-Provags-ID: V01U2FsdGVkX18xmNN+Xacx9LqA2yT27SdNqwSGv1g6QYRPs5el3H AftGUpQM3rqeF7 Message-ID: <46D20E56.10101@gmx.net> Date: Mon, 27 Aug 2007 01:35:50 +0200 From: Andreas User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8.1.6) Gecko/20070802 SeaMonkey/1.1.4 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: List of FKeys ? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/208 X-Sequence-Number: 29146 Hi, could I get a list of foreign keys that refer to a column? Say I have a table_1 (t1_id integer ......) and a lot of other tables that may refer to table 1. Is there a command that lists all tables that have a foreign key that points to t1_id? Preferably with the "on update/delete" options of the relation. Regards Andreas