Re: Do not output header line in psql

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(at)matfyz(dot)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.