On Wed, Jan 13, 2010 at 05:03:33PM -0500, Robert Haas wrote:
> On Wed, Jan 13, 2010 at 4:47 PM, Tom Lane wrote:
> >
> > Spelling out "primary key" would seem to be more in keeping with existing
> > entries in that column, eg we have "not null" not "NN".
> >
> > I think this is a sensible proposal
On Wed, Jan 13, 2010 at 4:47 PM, Tom Lane wrote:
> Peter Eisentraut writes:
>> I think we could easily improve that by having it look something like
>> this instead:
>
>> Table "public.test2"
>> Column | Type | Modifiers
>> +-+---
>> a | integer | PK
>> b
Peter Eisentraut writes:
> I think we could easily improve that by having it look something like
> this instead:
> Table "public.test2"
> Column | Type | Modifiers
> +-+---
> a | integer | PK
> b | integer | PK
> Indexes:
> "test2_pkey" PRIMARY KEY,
When you look at a table definition with psql \d, one of the arguably
most important pieces of information -- the primary key -- is hidden
somewhere below under "indexes":
Table "public.test2"
Column | Type | Modifiers
+-+---
a | integer | not null
b | i
