| From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: select column to text file |
| Date: | 2001-02-04 16:46:55 |
| Message-ID: | Pine.LNX.4.30.0102041143290.20913-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lincoln Yeoh | 2001-02-04 16:51:37 | Re: Memory requirements for web-project |
| Previous Message | GH | 2001-02-04 16:46:54 | Re: Memory requirements for web-project |