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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/