Re: \d+ for long view definitions? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: \d+ for long view definitions?
Date
Msg-id 603c8f070909011211v6272ecffvd402a3a5b0d549c5@mail.gmail.com
Whole thread Raw
In response to Re: \d+ for long view definitions?  (David Fetter <david@fetter.org>)
List pgsql-hackers
On Tue, Sep 1, 2009 at 3:01 PM, David Fetter<david@fetter.org> wrote:
> On Tue, Sep 01, 2009 at 02:29:12PM -0400, Tom Lane wrote:
>> Robert Haas <robertmhaas@gmail.com> writes:
>> > I think we should always or never show the view definition, not
>> > sometimes.
>>
>> Yeah.  I can live with \d not showing it and \d+ showing it --- as
>> Peter already mentioned, that would be consistent with \df behavior.
>> Making it depend on the length is just weird.
>
> As I see it, there are two independent issues here:
>
> * "Smart" display based on number of columns in the query and the psql window
> * Whether to display the view definition.
>
> I'm thinking on the second, \d should not display the definition, and
> \d+ should.
>
> On the first...could we go to \x-type display if the columns will
> overflow the terminal?

I don't understand exactly what you're proposing, but I don't think
flipping into \x mode based on the window size is ever a good idea.

...Robert


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Adding \ev view editor?
Next
From: Andrew Dunstan
Date:
Subject: Re: 8.5 release notes idea