Re: Where's The Primary Key?

> 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