Re: \d+ for long view definitions?

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: \d+ for long view definitions?
Date: 2009-09-01 18:17:31
Message-ID: 603c8f070909011117x166004a1j65c2dcea8709c849@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 1, 2009 at 1:31 PM, Josh Berkus<josh(at)agliodbs(dot)com> wrote:
> On 8/31/09 1:13 PM, Peter Eisentraut wrote:
>> I guess my premise is that if I use \d, I'm primarily interested in the
>> column names and types.  The view definition is secondary.  If the view
>> definition is a single line or uses a single table, it's interesting
>> because it might describe something about the schema design, but if it's
>> 20 lines it's an implementation detail.
>
> I agree with Peter here.

I think we should always or never show the view definition, not sometimes.

And I also agree with Tom's point that we should fix the pager. The
way that it works now is really annoying.

...Robert

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-09-01 18:29:12 Re: \d+ for long view definitions?
Previous Message Tom Lane 2009-09-01 18:10:24 Re: remove flatfiles.c