Outputting select into file. - Mailing list pgsql-general

Hello,

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.

For example

SELECT * FROM TABLE >> test.out

So that test.out would have the results from that SQL Statement.

Thank you for your time,

Troy Campano