In PostgreSQL database it is possible to save / export and results of a database query to a simple text file. By default all query result are displayed on the screen. This default behavior can be overwritten by \o command:

postresql=> \o /path/to/your/text/file.txt
postresql=> postgresql query ( here place your query )
postresql=> \o ( set back the default output behavior )

Free Linux eBooks

Do you have the right skills?

Our IT Skills Watch page reflects an up to date IT skills demand leaning towards the Linux and Unix environment. We have considered a number of skills and operating systems.

See the result...

Go to top