Controlling psql output

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема Controlling psql output
Дата
Msg-id 482E80323A35A54498B8B70FF2B87980040106E94B@azsmsx504.amr.corp.intel.com
обсуждение исходный текст
Ответы Re: Controlling psql output
Re: Controlling psql output
Re: Controlling psql output
Список pgsql-general

Hi:

 

Using a single psql command to generate stdout in linux that will be redirected to a file.  Many rows with 1 column are returned.  I want no header, no footer, no blank lines at the top or bottom, no initial space before each record.  This is what I’m trying...

 

psql –P tuples_only=on,footer=off,border=0 mydb

 

This gets rid of the header and footer OK.  But there is still a blank line as the first line in stdout.  Also, each record has a preceding space before the column value.

 

Is there a way to do what I want?

 

-dave

В списке pgsql-general по дате отправления: