Saving an output of PostgreSQL query to a text file

Latest Linux Jobs

LinuxCareer.com

Poll

Do you own or wish to have iPhone?

Yes, I own iPhone.

No, I do not own iPhone. It's not a Linux.

No, I prefer MeeGo device.

No, I prefer Android device.

No, I hate everything which starts with "i".

Yes, I must have all i* devices.

Recently added ....

Linux eBooks FREE Download

A guide to programming Linux kernel modules

Introduction to Linux - A Hands on Guide

A Newbie's Getting Started Guide to Linux

Linux from Scratch - Create Your Own Linux System - Free eBook

Linux: The Hacking Solution (v.3.0)

SQLite 3 with PHP Essential Training – Free Video Training Tutorials

This guide will introduce you to the world of GNU/Linux

The GNU/Linux Advanced Administration

A Complete Beginner's Manual for Ubuntu 10.04 (Lucid Lynx)

Advanced Bash-Scripting Guide

Set up, maintain, and secure a small office email server

Partner Linux Sites:
How-To.LinuxCareer.com
Jobs.LinuxCareer.com
TuxMachines
Monsterb
LinuxBloggers
AdamsInfo
LinuxScrew
All For Linux

LinuxCareer.com - Linux Howtos & Tutorials

Saving an output of PostgreSQL query to a text file

Last Updated on Thursday, 18 March 2010 13:12

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 )