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