Skip site navigation (1) Skip section navigation (2)

Viewing Foreign key constraints in psql

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: Viewing Foreign key constraints in psql
Date: 2002-11-22 09:36:50
Message-ID: 20021122093650.40787.qmail@web80312.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi:

  How do I view the foreign key constraints (name and
definition) in psql? I can only see the triggers
created by the constraint when I use the "\d <table>"
command in psql.


Thank you ,

ludwig

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

Responses

pgsql-novice by date

Next:From: HKDate: 2002-11-22 11:44:26
Subject: how to know backend crashed ??
Previous:From: Josh BerkusDate: 2002-11-21 23:36:32
Subject: Re: function does not exist error...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group