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

  • Lubomir Petrov at Mar 6, 2009 at 2:50 am
    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.

Related Discussions

Discussion Navigation
viewthread | post
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