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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
