Received: from qube1.digital-arts.co.uk ([193.243.249.193]) by hub.org (8.10.1/8.10.1) with ESMTP id e9BFttr98423 for ; Wed, 11 Oct 2000 11:55:57 -0400 (EDT) Received: from COLLEENS_PC.digital-arts.co.uk ([192.168.1.61]) by qube1.digital-arts.co.uk (8.9.2/8.9.2) with ESMTP id QAA27353 for ; Wed, 11 Oct 2000 16:55:28 +0100 (BST) Message-Id: <4.3.2.7.2.20001011165232.00b2a2d8@192.168.1.253> X-Sender: colleen@192.168.1.253 X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Wed, 11 Oct 2000 16:56:16 +0100 To: pgsql-sql@postgresql.org From: Colleen Williams Subject: SQL to retrieve foreign keys Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200010/107 X-Sequence-Number: 1769 Hi, I would like to write some SQL to extend the phpPgAdmin tool where it only displays primary keys related to a table. I have looked at the programmers doco and searched the discussions on foreign keys but was not able to decipher how to write the SQL. It is probably really trivial for someone who knows how the PostgreSQL catalog tables are related. Can someone please help me. Many Thanks. Colleen.