psql - save results of command to a file

Question

I'm using psql's `\dt` to list all tables in a database and I need to save the results. What is the syntax to export the results of a psql command to a file?

Accepted Answer

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
```

psql - save results of command to a file

Solution

Problem

Related problems