Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B50C6475ADD for ; Tue, 15 Oct 2002 07:46:35 -0400 (EDT) Received: from hotmail.com (f37.law9.hotmail.com [64.4.9.37]) by postgresql.org (Postfix) with ESMTP id 1CBF1474E44 for ; Tue, 15 Oct 2002 07:46:35 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 15 Oct 2002 04:46:38 -0700 Received: from 203.195.201.67 by lw9fd.law9.hotmail.msn.com with HTTP; Tue, 15 Oct 2002 11:46:37 GMT X-Originating-IP: [203.195.201.67] From: "wishy wishy" To: pgsql-sql@postgresql.org Subject: Re: foreign keys again Date: Tue, 15 Oct 2002 11:46:37 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 15 Oct 2002 11:46:38.0044 (UTC) FILETIME=[8526D9C0:01C27440] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/231 X-Sequence-Number: 9948 hi folks, For a certain table A, I need to find out the names of the columns who have a foreign key to a specific table B using the catalog.Has anyone done this before entirely using pgsql.I have been through the archieves and have not been able to find the required information. thanks kprasad _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com