In this article, we will see how to save query result to a file in PostgreSQL. We can save query result to txt, csv,.. files.
We have three methods to save/export query results to a file in PostgreSQL:
1) copy command
2) from Linux shell using psql tool.
3) \o method.
Continue reading How to save query result to a file in PostgreSQL