Charley Tiggs <lists(at)tiggs(dot)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?
regards, tom lane