Search Postgresql Archives

Controlling psql output

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux