Postgres Pro
Downloads
Home   >   mailing lists

Re: constraints in table - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: constraints in table
Date
Msg-id 4797E5C1.1050005@iol.ie
Whole thread Raw
In response to constraints in table  ("Dominique Bessette - Halsema" <dbhalsema@gmail.com>)
List pgsql-general
Tree view 
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@iol.ie
---------------------------------------------------------------

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: pg_xlog and standby
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Best practices for protect applications agains Sql injection.