Re: constraints in table - Mailing list pgsql-general

From Leif B. Kristensen
Subject Re: constraints in table
Date
Msg-id 200801240220.15169.leif@solumslekt.org
Whole thread Raw
In response to constraints in table  ("Dominique Bessette - Halsema" <dbhalsema@gmail.com>)
List pgsql-general
On Thursday 24. January 2008, Dominique Bessette - Halsema wrote:
>Hello,
>
>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

You should really read the psql documentation:
http://www.postgresql.org/docs/8.2/static/app-psql.html

As for a starter, try to write "\d tablename" from the psql prompt.

--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Best practices for protect applications agains Sql injection.
Next
From: "Gregory Williamson"
Date:
Subject: Re: constraints in table