Re: foreign key's in system tables - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: foreign key's in system tables
Date
Msg-id 20060105003153.GA27861@winnie.fuhr.org
Whole thread Raw
In response to foreign key's in system tables  ("Tjibbe Rijpma" <tjibbe@hotmail.com>)
List pgsql-novice
On Wed, Jan 04, 2006 at 11:57:45PM -0800, Tjibbe Rijpma wrote:
> From a table I want to know all the foreign key en their references.
> This goes well, but if there is more than one column in a FOREIGN KEY
> is goes wrong.

Are you familiar with the pg_get_constraintdef() function?  That's
what psql's "\d tablename" command uses.

http://www.postgresql.org/docs/8.1/interactive/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE

--
Michael Fuhr

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: Problem UPDATE Statement
Next
From: "Justin W. Reagor"
Date:
Subject: pg_xlog directory