From: rcolmegna@tiscali.it <rcolmegna@tiscali.it>
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-sql@postgresql.org
Subject: R: Re: R: R: Re: schema inspection
Date: Fri, 17 Mar 2006 09:56:54 +0100 (CET)
Message-ID: <19570915.1142585814389.JavaMail.root@ps20> (raw)
>
>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.
Thanks! I have obtained my query! Here is:
SELECT
(SELECT relname FROM pg_catalog.pg_class WHERE oid=conrelid) AS
fromTbl,
(SELECT relname FROM pg_catalog.pg_class WHERE oid=confrelid) AS
toTbl,
(SELECT attname FROM pg_catalog.pg_attribute WHERE attrelid=conrelid
AND conkey[1]=attnum) AS viaCol
FROM pg_catalog.pg_constraint AS rel WHERE contype='f';
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.tiscal...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rcolmegna@tiscali.it, achill@matrix.gatewaynet.com
Subject: Re: R: Re: R: R: Re: schema inspection
In-Reply-To: <19570915.1142585814389.JavaMail.root@ps20>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox