Same:
My_db=# select * from a_table \o 'test2.dat'
My_db-# ;
Killed
-----Original Message-----
From: Bricklen Anderson [mailto:BAnderson@PresiNET.com]
Sent: Friday, June 10, 2005 9:35 AM
To: Lee Wu
Cc: pgsql-admin@postgresql.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.
_______________________________
