Re: psql record separator - Mailing list pgsql-novice

From Tom Lane
Subject Re: psql record separator
Date
Msg-id 18985.1199916793@sss.pgh.pa.us
Whole thread Raw
In response to psql record separator  (Charley Tiggs <lists@tiggs.net>)
Responses Re: psql record separator  (Charley Tiggs <lists@tiggs.net>)
List pgsql-novice
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?

            regards, tom lane

pgsql-novice by date:

Previous
From: Charley Tiggs
Date:
Subject: psql record separator
Next
From: Charley Tiggs
Date:
Subject: Re: psql record separator