Outputting select into file.

[Lee Kindness <lkindness(at)csl(dot)co(dot)uk>]

Troy(dot)Campano(at)LibertyMutual(dot)com writes:
 > I have postgres 7 running on RedHat Linux.
 > I was wondering if you knew of a way to run a select and output it to a
 > file.
 > SELECT * FROM TABLE >> test.out
 > So that test.out would have the results from that SQL Statement.

Either: 

 SELECT * FROM table \g filename

to just output to the file 'filename', or:

 select * from lineshoot \g |cat >> /solsolute/path/filename

to append to the file. Both in psql, or:

 echo 'SELECT * FROM table' | psql database >> test.out

from your terminal.

Regards, Lee Kindness.