schema inspection

From: "rcolmegna(at)tiscali(dot)it" <rcolmegna(at)tiscali(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: schema inspection
Date: 2006-03-16 14:55:51
Message-ID: 9099192.1142520951367.JavaMail.root@ps10
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

supposing to have a small DB:

TABLE a (
id SERIAL PRIMARY KEY
);

TABLE b (
id SERIAL PRIMARY KEY,
idA INTEGER NOT NULL REFERENCES a(id)
);

How can I inspect pg_schema/information_schema to "detect" the
relation between "b" and "a" via "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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message lacou 2006-03-16 15:06:16 help with function
Previous Message Stefan Becker 2006-03-16 06:46:27 Re: group by function, make SQL cleaner?