Re: select * and save into a text file failed

Same:

My_db=# select * from a_table \o 'test2.dat'
My_db-# ;
Killed

-----Original Message-----
From: Bricklen Anderson [mailto:BAnderson(at)PresiNET(dot)com]
Sent: Friday, June 10, 2005 9:35 AM
To: Lee Wu
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] select * and save into a text file failed

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.
_______________________________