Re: select * and save into a text file failed - Mailing list pgsql-admin

From Bricklen Anderson
Subject Re: select * and save into a text file failed
Date
Msg-id 42A9B341.20004@PresiNET.com
Whole thread Raw
In response to select * and save into a text file failed  ("Lee Wu" <Lwu@mxlogic.com>)
List 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.
_______________________________

pgsql-admin by date:

Previous
From: "Lee Wu"
Date:
Subject: select * and save into a text file failed
Next
From: James Herbers
Date:
Subject: Re: select * and save into a text file failed