| From: | "Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)com> |
|---|---|
| To: | Jérôme Kestener <jerome(dot)kestener(at)yahoo(dot)fr> |
| Cc: | pgsql-novice(at)postgresql(dot)org, pgsql-novice-owner(at)postgresql(dot)org |
| Subject: | Re: NewBie |
| Date: | 2003-01-23 23:24:59 |
| Message-ID: | OFB5617B4F.963E9977-ON86256CB7.00807B58@ipaper.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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(dot)kestener(at)yahoo(dot)fr>
Sent by: pgsql-novice-owner(at)postgresql(dot)org
01/21/2003 08:49 AM
To: pgsql-novice(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mark malik | 2003-01-23 23:59:51 | postgre sql to run a java program |
| Previous Message | Chad Thompson | 2003-01-23 23:21:22 | Re: [May be Spam]NewBie |