R: Re: R: Re: R: R: Re: schema inspection - Mailing list pgsql-sql

From rcolmegna@tiscali.it
Subject R: Re: R: Re: R: R: Re: schema inspection
Date
Msg-id 33326472.1142588286517.JavaMail.root@ps20
Whole thread Raw
List pgsql-sql
>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     | idac       | a     | idac       | 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


pgsql-sql by date:

Previous
From: "rcolmegna@tiscali.it"
Date:
Subject: R: Re: R: R: Re: schema inspection
Next
From: Stefan Meyer
Date:
Subject: rowcount for all tables