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