Same: My_db=# select * from a_table \o 'test2.dat' My_db-# ; Killed
-----Original Message----- From: Bricklen Anderson [mailto:[EMAIL PROTECTED] 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. _______________________________ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
