Search Postgresql Archives

Re: Controlling psql output

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

 



On Fri, 2009-05-08 at 09:51 -0700, Gauthier, Dave wrote:
> 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 

psql -A -t

jd@jd-laptop:~$ psql -A -t -U postgres -c "select * from bool_test"
f
jd@jd-laptop:~$

Sincerely,

Joshua D. Drake

> 
> 
-- 
PostgreSQL - XMPP: jdrake@xxxxxxxxxxxxxxxxxxxxx
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[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