Re: select * and save into a text file failed

From: Bricklen Anderson <BAnderson(at)PresiNET(dot)com>
To: Lee Wu <Lwu(at)mxlogic(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: select * and save into a text file failed
Date: 2005-06-10 15:35:29
Message-ID: 42A9B341.20004@PresiNET.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Lee Wu wrote:
>
> How can I save PG data into text file without using pg_dump?
>
did you try

select * from table \o '/var/tmp/textfile.txt'
;

--
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message James Herbers 2005-06-10 15:39:43 Re: select * and save into a text file failed
Previous Message Colin E. Freas 2005-06-10 15:33:13 Re: How to recover when can't start database