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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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