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
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 |