MYSQL query output to a file

select
*
from
table
where
condition
into
outfile '/tmp/result'

psql output to file

Below is the command to redirect psql output to a file.

psql> \o /tmp/file.txt
psql> select * from table

This should allow output to custom file.