Re: How to detect primary key of a table

\d your_table
will show it


>> create table foobar ( foo int primary key, bar int );
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"foobar_pkey" for table "foobar"
CREATE TABLE

>> \d foobar
    Table "public.foobar"
Column |  Type   | Modifiers
--------+---------+-----------
foo    | integer | not null
bar    | integer |
Indexes:
    "foobar_pkey" PRIMARY KEY, btree (foo)

________________________________

From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Sergey Karin
Sent: Thursday, March 30, 2006 1:13 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to detect primary key of a table


Hi, List!

I use PG8.1

Are there any abilities to detect primary key of a table?

Sergey Karin