Re: constraints in table

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Dominique Bessette - Halsema <dbhalsema(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: constraints in table
Date: 2008-01-24 01:11:29
Message-ID: 4797E5C1.1050005@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 24/01/2008 00:09, Dominique Bessette - Halsema wrote:

> How do i find the constraints on a table in SQL? my database is linux
> based, and I cant seem to find the command. Thanks

In psql,

\d <tablename>

will show the constraints.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-01-24 01:14:36 Re: Best practices for protect applications agains Sql injection.
Previous Message Greg Smith 2008-01-24 01:07:28 Re: pg_xlog and standby