Re: psql record separator

Andrej Ricnik-Bay wrote:
> On 10/01/2008, Charley Tiggs  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

I got it to work by using the actual character surrounded by quotes. 
That's not ideal but at least I got the line endings I needed.

Charley