Re: psql record separator

On 10/01/2008, Charley Tiggs <lists@tiggs.net> wrote:

> I added the "-A" switch and it output the string "\r\n" instead of an
> actual CRLF.
>
> psql -A -R "\r\n" -t dbname username -c "select * from foo" > data_file.txt
I can't tell you what the proper incantation is (I didn't manage to get
it to play nice within 10 minutes), but how about a hackish solution like:
psql -A -t dbname username -c "select * from foo"|todos > data_file.txt

> Charley
Cheers,
Andrej



--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm