Re: Do not output header line in psql
От | Hans Ginzel |
---|---|
Тема | Re: Do not output header line in psql |
Дата | |
Msg-id | 20150202170640.GB52451@artax.karlin.mff.cuni.cz обсуждение исходный текст |
Ответ на | Re: Do not output header line in psql (Yaser Raja <yrraja@gmail.com>) |
Ответы |
Re: Do not output header line in psql
|
Список | pgsql-novice |
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.
В списке pgsql-novice по дате отправления: