how to show foreign keys of a table

From: "T(dot) Dekany" <linux_ch(at)scientist(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to show foreign keys of a table
Date: 2000-12-26 15:15:01
Message-ID: 3A48B5F5.707@scientist.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
in psql, the command "\d <table>" gives me the table-definitions, but
the defined foreign keys don't show up. How can I get those? How can I
check, what foreign keys a table has?
Thanx

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ioseph Kim 2000-12-26 15:15:56 How I can join between the other database's tables?
Previous Message Uro Gruber 2000-12-26 14:40:08 RETURN multiple columns in FUNCTION