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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to