Dominique Bessette - Halsema asked:
>
> 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
>
>From the psql prompt, \d works for me:
billing=# \d work.clients
Table "work.clients"
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
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
will show the constraints.
Ray.
---
