Skip site navigation (1) Skip section navigation (2)

Re: How does one determine which columns are

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Damon Fasching <fasching(at)design(dot)lbl(dot)gov>,pgsql-novice(at)postgresql(dot)org
Subject: Re: How does one determine which columns are
Date: 2002-02-28 16:40:52
Message-ID: web-812840@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-02-28 16:42:12
Subject: Re: ElseIF in PLPGSQL
Previous:From: Stephan SzaboDate: 2002-02-28 16:09:31
Subject: Re: Help formulating multi-table SELECT statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group