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 83F219DCC01 for ; Fri, 17 Mar 2006 04:42:40 -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 14459-10 for ; Fri, 17 Mar 2006 04:42:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id B26389DCBFC for ; Fri, 17 Mar 2006 04:42:36 -0400 (AST) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id k2H9mROp027337; Fri, 17 Mar 2006 11:48:27 +0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id k2H9mRHQ027333; Fri, 17 Mar 2006 11:48:27 +0200 Date: Fri, 17 Mar 2006 11:48:27 +0200 (EET) From: Achilleus Mantzios To: "rcolmegna@tiscali.it" cc: pgsql-sql@postgresql.org Subject: Re: R: R: Re: schema inspection In-Reply-To: <24440777.1142528308568.JavaMail.root@ps19> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.112 required=5 tests=[AWL=0.112] X-Spam-Score: 0.112 X-Spam-Level: X-Archive-Number: 200603/246 X-Sequence-Number: 24592 O rcolmegna@tiscali.it Ýãñáøå óôéò Mar 16, 2006 : > > pg_catalog.pg_constraint is your (only?) friend. > > I have already examintated this table without results. Seem not to be > a "human-readable" table .... :( Right you will have to join against pg_class, and make it readable. SELECT c1.relname,c2.relname from pg_constraint cons,pg_class c1, pg_class c2 where cons.conrelid=c1.oid and cons.confrelid = c2.oid; for column(s) names you will have to do extra homework. > > TIA > Roberto Colmegna > > > > > > Tiscali ADSL 4 Mega Flat > Naviga senza limiti con l'unica Adsl a 4 Mega di velocità a soli 19,95 € al mese! > Attivala subito e hai GRATIS 2 MESI e l'ATTIVAZIONE. > http://abbonati.tiscali.it/banner/middlepagetracking.html?c=webmailadsl&r=http://abbonati.tiscali.it/adsl/sa/4flat_tc/&a=webmail&z=webmail&t=14 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > -- -Achilleus