Re: Where's The Primary Key?

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: Jim Louis <jim(dot)louis(at)worldnet(dot)att(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Where's The Primary Key?
Date: 2003-07-28 03:56:33
Message-ID: Pine.LNX.4.44.0307280924020.1209-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> db01=> \d junk_t
> Table "junk_t"
> Attribute | Type | Modifier
> -----------+---------+----------
> idx | integer | not null
> dat | integer |
> Index: junk_idx

Primary key is the combination of unique index + not null. In your case,
both are listed. For further details refer pg_indexes system view.

regards,
bhuvaneswaran

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message bruce 2003-07-28 04:53:32 Re: [PHP] Accessing Postgres db from apache using PHP
Previous Message A.Bhuvaneswaran 2003-07-28 03:52:10 Re: Accessing Postgres db from apache using PHP