Re: \d+ for long view definitions?

On Tue, Sep 1, 2009 at 3:01 PM, David Fetter<david(at)fetter(dot)org> wrote:
> On Tue, Sep 01, 2009 at 02:29:12PM -0400, Tom Lane wrote:
>> Robert Haas <robertmhaas(at)gmail(dot)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