Re: Do not output header line in psql - Mailing list pgsql-novice

From Hans Ginzel
Subject Re: Do not output header line in psql
Date
Msg-id 20150202170640.GB52451@artax.karlin.mff.cuni.cz
Whole thread Raw
In response to Re: Do not output header line in psql  (Yaser Raja <yrraja@gmail.com>)
Responses Re: Do not output header line in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Mon, Feb 02, 2015 at 11:48:45AM -0500, Yaser Raja wrote:
>   You can use "grep -v" to exclude this line as follows:
>   echo '\dt' |psql -nqaA -Pfooter=off | grep -v 'List of relations'
>   Regards
>   Yaser

Thank you, but that is ugly. There must not be table/view named like this, etc.
Which all strings need to be filtered – relations, roles,…?
Is there a clean solution, please?

Regards,
H.

>
>   On Mon, Feb 2, 2015 at 4:00 AM, Hans Ginzel <[1]hans@matfyz.cz> wrote:
>
>     Hello!
>     How can I please get rid of the header line "List of relations" in
>     the example below, please?
>     echo '\dt' |psql -nqaA -Pfooter=off
>     I can use the -t option, but it also removes the column headers I
>     want to keep.


pgsql-novice by date:

Previous
From: Yaser Raja
Date:
Subject: Re: Do not output header line in psql
Next
From: Tom Lane
Date:
Subject: Re: Do not output header line in psql