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.