A Query on PG_ tables

From: NRonayette <r97m10(at)socotec(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: A Query on PG_ tables
Date: 2000-06-19 08:52:20
Message-ID: 394DDF44.79636CEE@socotec.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everybody,

I'm using Postgresql 7.0.

I want to find, by a query on the postgres table (like pg_class,
pg_attribute, pg_trigger, etc....), the name of all the colonnes that
are foreign key on my base.

Pg_trigger gives me some information about the foreigns key i added on
my tables (name, id etc..) but i don't know how to join this information
with another pg_<table> (for example, pg_attribute or else) to find the
name of my colonnes that are foreign key.

Someone have an idear ?

I hope i was clear with my poor English...

Thanks for your answers.

Nicolas.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holger Klawitter 2000-06-19 10:31:19 Re: aggregate functions
Previous Message Joost Kraaijeveld 2000-06-19 08:43:34 RE: Weird error on NT