psql – save results of command to a file

September 23, 2022 by Tarik

From psql’s help (\?):

\o [FILE] send all query results to file or |pipe

The sequence of commands will look like this:

[wist@scifres ~]$ psql db
Welcome to psql 8.3.6, the PostgreSQL interactive terminal

db=>\o out.txt
db=>\dt

Then any db operation output will be written to out.txt.
Enter ‘\o’ to revert the output back to console.

db=>\o