Re: Where's The Primary Key? - Mailing list pgsql-novice

From A.Bhuvaneswaran
Subject Re: Where's The Primary Key?
Date
Msg-id Pine.LNX.4.44.0307280924020.1209-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Where's The Primary Key?  ("Jim Louis" <jim.louis@worldnet.att.net>)
Responses Re: Where's The Primary Key?  (Bruno Wolff III <bruno@wolff.to>)
List 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



pgsql-novice by date:

Previous
From: "A.Bhuvaneswaran"
Date:
Subject: Re: Accessing Postgres db from apache using PHP
Next
From: "bruce"
Date:
Subject: Re: [PHP] Accessing Postgres db from apache using PHP