On Wed, Jan 13, 2010 at 05:03:33PM -0500, Robert Haas wrote:
On Wed, Jan 13, 2010 at 4:47 PM, Tom Lane t...@sss.pgh.pa.us 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
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 |
Peter Eisentraut pete...@gmx.net 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
On Wed, Jan 13, 2010 at 4:47 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Peter Eisentraut pete...@gmx.net writes:
I think we could easily improve that by having it look something like
this instead:
Table public.test2
Column | Type | Modifiers
+-+---
a |