Thread: Hiding row counts in psql

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.

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.
>