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

>Well thats it if you use only *single column* Foreign keys.
>In the general case the above will need extra work.

Are you sure? I have tested query with 3 table with multiple FK and
it works (see below) [as you can see
"C" table have two FK to A and B]

test=> SELECT
test-> (SELECT relname FROM pg_catalog.pg_class WHERE oid=conrelid)
AS fromTbl,
test-> (SELECT relname FROM pg_catalog.pg_class WHERE oid=confrelid)
AS toTbl,
test-> (SELECT attname FROM pg_catalog.pg_attribute WHERE
attrelid=conrelid AND conkey[1]=attnum) AS viaCol
test-> FROM pg_catalog.pg_constraint AS rel WHERE contype='f' ORDER BY
fromTbl;
fromtbl | totbl | viacol
---------+-------+--------
b | a | ida
c | a | ida
c | b | idb

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