X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 704C652B4D for ; Thu, 18 Aug 2005 02:58:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91383-08 for ; Thu, 18 Aug 2005 05:58:22 +0000 (GMT) Received: from web51902.mail.yahoo.com (web51902.mail.yahoo.com [206.190.48.65]) by svr1.postgresql.org (Postfix) with SMTP id D899B52B63 for ; Thu, 18 Aug 2005 02:58:20 -0300 (ADT) Received: (qmail 34705 invoked by uid 60001); 18 Aug 2005 05:58:21 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=scKE/VUyPST3EJZdd1eJ+O7LTvQLt/IgkUGXrr6vgkrFdiO6jYuCkgL4Cez9KDgr54bHs9K1YNuu4fqCLqmszX2tSQs4/gU/uunbAgwsdPT+GRJ9dlUjTVpkp8N2bcIFwl7k8wbhCKLd0bYqypEjLP96MkvCqDdj1QYHqHN1moE= ; Message-ID: <20050818055821.34703.qmail@web51902.mail.yahoo.com> Received: from [80.84.141.227] by web51902.mail.yahoo.com via HTTP; Wed, 17 Aug 2005 22:58:21 PDT Date: Wed, 17 Aug 2005 22:58:21 -0700 (PDT) From: Roger Tannous Subject: Re: Locating ( FKs ) References to a Primary Key To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.573 required=5 tests=[AWL=0.199, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200508/138 X-Sequence-Number: 22366 Dmitri, Thanks !! I got exactly what I wanted :) In fact, I used your query like this: SELECT cl.relname AS FK_table_name, a.attname AS FK_column_name, clf.relname AS PK_table_name, af.attname AS PK_column_name FROM pg_catalog.pg_attribute a JOIN pg_catalog.pg_class cl ON (a.attrelid = cl.oid AND cl.relkind = 'r') JOIN pg_catalog.pg_namespace n ON (n.oid = cl.relnamespace) JOIN pg_catalog.pg_constraint ct ON (a.attrelid = ct.conrelid AND ct.confrelid != 0 AND ct.conkey[1] = a.attnum) JOIN pg_catalog.pg_class clf ON (ct.confrelid = clf.oid AND clf.relkind = 'r') JOIN pg_catalog.pg_namespace nf ON (nf.oid = clf.relnamespace) JOIN pg_catalog.pg_attribute af ON (af.attrelid = ct.confrelid AND af.attnum = ct.confkey[1]) WHERE n.nspname = nf.nspname AND n.nspname = 'public' AND clf.relname like 'sip_emp' AND af.attname = 'id'; Best Regards, Roger Tannous. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com