Re: some psql table output flaws - Mailing list pgsql-hackers

From Erik Rijkers
Subject Re: some psql table output flaws
Date
Msg-id b529ca1fd8f322bdce38d2db0f0f946f.squirrel@webmail.xs4all.nl
Whole thread Raw
In response to some psql table output flaws  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Fri, February 1, 2013 21:22, Peter Eisentraut wrote:
> I have encountered two unrelated flaws in the psql table output.
>
> First, when using unaligned vertical mode (\a \x on), there is always an
> empty line after the last record.  This also means that an empty result
> set prints an empty line, instead of nothing.
>
> Second, when using aligned vertical mode (\x on), an empty result set
> prints "(No rows)".  That's fine, but there is no way to turn this off.
>  I intuitively attempted to use \t (tuples only), but that had no
> effect.  \t doesn't really have a meaning in vertical mode, because the
> field names are always printed, but I think it could/should have the
> effect of shutting off footer lines.
>
> Patch for both issues attached.
>

+1

I'd be very glad not to have to 'grep -v' this stuff away all the time





pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: some psql table output flaws
Next
From: Robert Haas
Date:
Subject: Re: GetOldestXmin going backwards is dangerous after all