Re: select column to text file - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: select column to text file
Date
Msg-id Pine.LNX.4.30.0102041143290.20913-100000@chapelperilous.net
Whole thread Raw
In response to select column to text file  ("Thomas T. Thai" <tom@minnesota.com>)
List pgsql-general
On Sun, 4 Feb 2001, Thomas T. Thai wrote:

> i have a URL column in my table, i would like to select that and dump it
> to a local file. ideas?

If you use the \o <file> command in psql, it will send all query output to
the file designated with \o.  You turn off the file output by using \o
without a filename.  You can also pipe stuff into a file with \o.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
My opinions may have changed, but not the fact that I am right.


pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: select column to text file
Next
From: Lincoln Yeoh
Date:
Subject: Re: Memory requirements for web-project