Postgres Pro
Downloads
Home   >   mailing lists

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

From Yaser Raja
Subject Re: Do not output header line in psql
Date
Msg-id CALkbEVnNqHN=c1GDsr6a8x3PKtQMD+hEHOtXNQTbm=EXTFM=Rg@mail.gmail.com
Whole thread Raw
In response to Do not output header line in psql  (Hans Ginzel <hans@matfyz.cz>)
Responses Re: Do not output header line in psql
List pgsql-novice
Tree view
You can use "grep -v" to exclude this line as follows:

echo '\dt' |psql -nqaA -Pfooter=off | grep -v 'List of relations'

Regards
Yaser


On Mon, Feb 2, 2015 at 4:00 AM, Hans Ginzel <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.

Regards,
Hans


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

pgsql-novice by date:

Previous
From: Hans Ginzel
Date:
Subject: Do not output header line in psql
Next
From: Hans Ginzel
Date:
Subject: Re: Do not output header line in psql