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 D61D09DCAC5 for ; Thu, 16 Mar 2006 10:55:55 -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 23116-08 for ; Thu, 16 Mar 2006 10:55:59 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 06BBC9DC9E7 for ; Thu, 16 Mar 2006 10:55:53 -0400 (AST) Received: from mrqout2.tiscali.it (mrqout2.tiscali.it [195.130.225.12]) by svr4.postgresql.org (Postfix) with ESMTP id 473BC5AF848 for ; Thu, 16 Mar 2006 14:55:58 +0000 (GMT) Received: from 10.39.115.27 by mrq-2 with esmtp (Exim) id 1FJttH-0007lH-L7; Thu, 16 Mar 2006 15:55:52 +0100 Received: from ps10 (10.39.75.80) by mail-7.mail.tiscali.sys (7.2.066.3) id 4417DC5800005B5F for pgsql-sql@postgresql.org; Thu, 16 Mar 2006 15:55:51 +0100 Message-ID: <9099192.1142520951367.JavaMail.root@ps10> Date: Thu, 16 Mar 2006 15:55:51 +0100 (CET) From: "rcolmegna@tiscali.it" Reply-To: "rcolmegna@tiscali.it" To: pgsql-sql@postgresql.org Subject: schema inspection 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/229 X-Sequence-Number: 24575 Hi, supposing to have a small DB: TABLE a ( id SERIAL PRIMARY KEY ); TABLE b ( id SERIAL PRIMARY KEY, idA INTEGER NOT NULL REFERENCES a(id) ); How can I inspect pg_schema/information_schema to "detect" the=20 relation between "b" and "a" via "idB"? 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