save query result to a file

# start
\o data.txt

# ...run the psql commands...e.g. \dt

# ended
\o

docker-compose --file docker-compose-dev.yml exec postgres cat data.txt