>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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
