| From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Controlling psql output |
| Date: | 2009-05-08 16:51:05 |
| Message-ID: | 482E80323A35A54498B8B70FF2B87980040106E94B@azsmsx504.amr.corp.intel.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2009-05-08 17:10:09 | Re: Controlling psql output |
| Previous Message | Gevik Babakhani | 2009-05-08 16:28:36 | Re: structure of query does not match error during RETURN QUERY. |