Re: Hiding row counts in psql

Hi,

Use "\pset footer [on|off]".

test=# select 1 as "Col1";
Col1
------
1
(1 row)

test=#
test=# \pset footer
Default footer is off.
test=#
test=# select 1 as "Col1";
Col1
------
1

test=# \pset footer
Default footer is on.
test=#
test=#
test=# select 1 as "Col1";
Col1
------
1
(1 row)

test=# \pset footer off
Default footer is off.
test=#
test=#
test=# select 1 as "Col1";
Col1
------
1

test=#
test=# \pset footer on
Default footer is on.
test=#
test=#
test=# select 1 as "Col1";
Col1
------
1
(1 row)

test=#

Hope this helps.

Regards,
Lubomir Petrov

Ben Chobot wrote:
> Is there a way in psql to hide the row counts but keep the column
> headers? The man page talks about \t and --tuples-only, but both of
> those also suppress column headers.
>