Re: new format for describe (repost #2)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: new format for describe (repost #2)
Date: 2003-03-07 16:34:15
Message-ID: 200303071634.h27GYFN16818@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Peter Eisentraut wrote:
> Christopher Kings-Lynne writes:
>
> > I mean, what's easier to read at a glance:
> >
> > "$1" FOREIGN KEY (referrer) REFERENCES users_users(userid) ON DELETE SET
> > NULL
> >
> > or
> >
> > > Foreign Keys
> > > Name | Referencing Col | Referenced Tbl | Referenced Col | Delete Action
> > > ------+-----------------+----------------+----------------+---------------
> > ...
> > > $1 | referrer | users_users | userid | SET NULL
>
> The second.

If there is only one line, the top one may be easier to read, but for
many lines, the table format is probably clearer.

Ideally, it would be good to see a before/after output for a typical
table so we can see the changes more easily.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Rod Taylor 2003-03-07 16:35:23 Re: [PATCHES] ALTER SEQUENCE
Previous Message Bruce Momjian 2003-03-07 16:27:13 Re: [PATCHES] ALTER SEQUENCE