Thom Brown <thom(at)linux(dot)com> writes:
> I can see the same output as you if I get it to ignore my .psqlrc file:
> # select * from colours2;
> --
> (5 rows)
> Turns out it's "\x auto" causing it.
Ah. Seems like a bug in the expanded-mode printout logic then.
But, in any case, it's been like that a very long time. You
could do this at least as far back as 8.4:
regression=# create table foo();
CREATE TABLE
regression=# insert into foo default values;
INSERT 0 1
regression=# insert into foo default values;
INSERT 0 1
regression=# select * from foo;
--
(2 rows)
regression=# \x on
Expanded display is on.
regression=# select * from foo;
(No rows)
regards, tom lane