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