Re: constraints in table

From: "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: constraints in table
Date: 2008-01-24 01:20:15
Message-ID: 200801240220.15169.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Williamson 2008-01-24 01:21:09 Re: constraints in table
Previous Message Ivan Sergio Borgonovo 2008-01-24 01:14:36 Re: Best practices for protect applications agains Sql injection.