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.