Postgres Pro
Downloads
Home   >   mailing lists

Re: How does one determine which columns are - Mailing list pgsql-novice

From Josh Berkus
Subject Re: How does one determine which columns are
Date
Msg-id web-812840@davinci.ethosmedia.com
Whole thread Raw
In response to How does one determine which columns are constrained PRIMARY KEY?  (Damon Fasching <fasching@design.lbl.gov>)
Responses Re: How does one determine which columns are constrained PRIMARY KEY?  (Damon Fasching <fasching@design.lbl.gov>)
List pgsql-novice
Tree view 
Damon,

> Is it possible to determine which column(s), if any, are constrained
> with PRIMARY KEY?

From psql, use:

\d table_name

You will get a list of table characteristics, including any
 constraints.

-Josh

pgsql-novice by date:

Previous
From: "Stephan Szabo"
Date:
Subject: Re: Help formulating multi-table SELECT statement
Next
From: "Josh Berkus"
Date:
Subject: Re: ElseIF in PLPGSQL