Re: pgsql: Allow empty target list in SELECT.

Thom Brown <thom@linux.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