Pipe the output of a SQL query to a text file.

Pipe SQL Query Output to a Text File

PostgreSQL
----------
After logging in to the PSQL console:

db=> \o /path/to/where/you/want/the/file/saved
db=> the sql query
db=>

Output is saved, though there is no feedback from the console.

MySQL
-----
SELECT order_id,product_name,qty
FROM orders
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'