Andrej Ricnik-Bay wrote:
> On 10/01/2008, Charley Tiggs <lists(at)tiggs(dot)net> 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.
In response to
pgsql-novice by date
|Next:||From: Oeschey, Lars (I/EK-142, extern)||Date: 2008-01-10 15:29:12|
|Subject: Re: Problem restoring database |
|Previous:||From: kenneth d'souza||Date: 2008-01-10 12:15:28|
|Subject: Re: two postgres binaries|