try:psql <dbname>\d <table_name>The constraints will be listed at the bottom of the table.HTH,
Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474 | "Jérôme Kestener" <jerome.kestener@yahoo.fr> Sent by: pgsql-novice-owner@postgresql.org01/21/2003 08:49 AM
| To: pgsql-novice@postgresql.org cc: Subject: [NOVICE] NewBie |
I want to find the primary key of a table, but i don't know in witch system table this information is store. I suppose that is pg_constraint, but i can't acces to it . I get the message :Relation "pg_constraint" does not exist
Could you help me.?
My version of postgresql is 7.2.2-16 under linux suse 8