Re: Do not output header line in psql

Hans Ginzel <hans(at)matfyz(dot)cz> writes:
> 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'

> 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?

I agree that grep seems like a pretty dangerous solution, but
"tail -n +2" would work reliably.

Or, instead of relying on \dt, you could do your own select from
information_schema.tables, and then you'd have more control over
the formatting, column headers, etc.

regards, tom lane