A Query on PG_ tables - Mailing list pgsql-general

From NRonayette
Subject A Query on PG_ tables
Date
Msg-id 394DDF44.79636CEE@socotec.fr
Whole thread Raw
List 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.

pgsql-general by date:

Previous
From: Herbert Liechti
Date:
Subject: Re: Lock rekord
Next
From: Joost Kraaijeveld
Date:
Subject: RE: PostgreSQL on NT: new cygwin?