Hans Ginzel <hans@matfyz.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