Outputting select into file.

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.