Thread: R: Re: R: R: Re: schema inspection

R: Re: R: R: Re: schema inspection

From
"rcolmegna@tiscali.it"
Date:
>
>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.tiscali.it/adsl/sa/4flat_tc/&a=webmail&z=webmail&t=14