X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 472C69DC805 for ; Fri, 17 Mar 2006 04:56:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19466-04 for ; Fri, 17 Mar 2006 04:56:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mrqout1.tiscali.it (mrqout1-sorbs.tiscali.it [195.130.225.22]) by postgresql.org (Postfix) with ESMTP id 3915A9DC84C for ; Fri, 17 Mar 2006 04:56:54 -0400 (AST) Received: from 10.39.115.34 by mrq-1 with esmtp (Exim) id 1FKAlS-0004Xs-OH; Fri, 17 Mar 2006 09:56:55 +0100 Received: from ps20 (10.39.75.90) by mail-9.mail.tiscali.sys (7.2.071) id 4417DC8100008ED4; Fri, 17 Mar 2006 09:56:54 +0100 Message-ID: <19570915.1142585814389.JavaMail.root@ps20> Date: Fri, 17 Mar 2006 09:56:54 +0100 (CET) From: "rcolmegna@tiscali.it" Reply-To: "rcolmegna@tiscali.it" To: Achilleus Mantzios Subject: R: Re: R: R: Re: schema inspection Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain;charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200603/269 X-Sequence-Number: 24615 > >SELECT c1.relname,c2.relname from pg_constraint cons,pg_class c1,=20 pg_class >c2 where cons.conrelid=3Dc1.oid and cons.confrelid =3D c2.oid; > >for column(s) names you will have to do extra homework. Thanks! I have obtained my query! Here is: SELECT=20 (SELECT relname FROM pg_catalog.pg_class WHERE oid=3Dconrelid) AS=20 fromTbl, (SELECT relname FROM pg_catalog.pg_class WHERE oid=3Dconfrelid) AS=20 toTbl, (SELECT attname FROM pg_catalog.pg_attribute WHERE attrelid=3Dconrelid=20 AND conkey[1]=3Dattnum) AS viaCol FROM pg_catalog.pg_constraint AS rel WHERE contype=3D'f'; TIA Roberto Colmegna =09=09 Tiscali ADSL 4 Mega Flat Naviga senza limiti con l'unica Adsl a 4 Mega di velocit=C3=A0 a soli 19,95= =E2=82=AC al mese! Attivala subito e hai GRATIS 2 MESI e l'ATTIVAZIONE.=20 http://abbonati.tiscali.it/banner/middlepagetracking.html?c=3Dwebmailadsl&r= =3Dhttp://abbonati.tiscali.it/adsl/sa/4flat_tc/&a=3Dwebmail&z=3Dwebmail&t= =3D14