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.