Re: List of FKeys ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: List of FKeys ?
Date: 2007-08-27 03:48:32
Message-ID: 12827.1188186512@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Andreas <maps(dot)on(at)gmx(dot)net> writes:
> could I get a list of foreign keys that refer to a column?

The information_schema views constraint_column_usage and
referential_constraints might help you, or you could dive into the
underlying system catalogs.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kristo Kaiv 2007-08-27 07:52:38 Re: [GENERAL] table column vs. out param [1:0]
Previous Message Bruce Momjian 2007-08-27 02:49:41 Re: Block size with pg_dump?