Re: psql wrapped format default for backslash-d commands - Mailing list pgsql-hackers

From Bryce Nesbitt
Subject Re: psql wrapped format default for backslash-d commands
Date
Msg-id 48294072.20806@obviously.com
Whole thread Raw
In response to Re: psql wrapped format default for backslash-d commands  ("Brendan Jurd" <direvus@gmail.com>)
Responses Re: psql wrapped format default for backslash-d commands  (Bruce Momjian <bruce@momjian.us>)
Re: psql wrapped format default for backslash-d commands  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Brendan Jurd wrote:
> I really like the idea of wrapping, but after playing with the format
> a bit myself, I have to agree with Tom that breaking in the middle of
> words produces some very nasty output.
>
> If the format could be improved to only wrap on word boudaries, that
> would increase its appeal dramatically.
>
> Anybody got a rough idea how difficult it would be to add
> word-awareness int o the wrapping code?
>
> Cheers,
> BJ
>   
It's not that hard to do.

I chose not to, when writing the patch, because it makes the result flow 
over many more lines.
And regardless, it pretty much has to cut long "words", of which there 
are many in typical SQL output.
And, I hardly ever read actual large blocks of English at the SQL 
prompt, so: designing for that use case did
not float my boat at the time.
And, word wrapping messes with the cell contents more than I was 
comfortable doing. With the current wrapping all whitespace is preserved 
and apparent.

But, if your boat is floated, then by all means go for it.
                           -Bryce



pgsql-hackers by date:

Previous
From: "Brendan Jurd"
Date:
Subject: Re: psql wrapped format default for backslash-d commands
Next
From: "Dave Page"
Date:
Subject: Re: odd output in restore mode