PostgreSQL to File

PostgreSQL (or simply Postgres) is powerful and extremely popular database management system. It comes with easy to use tool that makes it possible to export output of any query into text file. If you are familiar with Mysql you may know about SELECT … INTO OUTFILE syntax already so here is its equivalent to output PostgreSQL to file: 1. Connect to PostgreSQL DBA: $ psql -U postgres -p 5432 databasename$ […]

Read more →