psql record separator

From: Charley Tiggs <lists(at)tiggs(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: psql record separator
Date: 2008-01-09 22:06:40
Message-ID: 47854570.6030306@tiggs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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)?

Charley

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2008-01-09 22:13:13 Re: psql record separator
Previous Message Charley Tiggs 2008-01-09 22:03:55 Re: Command line output - How to output values only?