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

From Lee Wu
Subject Re: select * and save into a text file failed
Date
Msg-id E1F0E4D89D8FA44789DFC065C8E755281A360C@mxlhq-exch01.corp.mxlogic.com
Whole thread Raw
In response to select * and save into a text file failed  ("Lee Wu" <Lwu@mxlogic.com>)
List pgsql-admin
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.
_______________________________

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL default data location
Next
From: Tom Lane
Date:
Subject: Re: How to recover when can't start database