Re: psql record separator

Tom Lane wrote:
> Charley Tiggs <lists@tiggs.net> writes:
>> I'm trying to create a CRLF record separator using the following syntax:
>> psql -R "\r\n" dbname username -c "select * from foo" > data_file.txt
>
>> But, no matter what I do, it only outputs a newline (\n).  How can I
>> force the separator to be a windows line break (CRLF)?
>
> According to the code, -R only affects the output in "unaligned" output
> mode.  Can you use that?

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

Charley