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.

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedFeb 27, '09 at 5:58p
activeMar 6, '09 at 2:50a
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Lubomir Petrov: 1 post Ben Chobot: 1 post

People

Translate

site design / logo © 2022 Grokbase