PSQL and -R (record separator)

[gacaccia]

my understanding is that when outputting a select statment to file, the default record separator is a newline character (LF). i need to change this to CR/LF. i see documentation about the -R option when running a query from PSQL, but i can't find any documentation on what valid values are for the -R option. anyone know how to specify CR/LF for the record separator?

for example, i have something like...

psql -h localhost -p 5555 -U puser -d pdatabase -o c:\tabledump.txt -A -t -c "select * from ptable"

i want to add the -R option to specify CR/LF for record separator.

thanks,

glenn

 

[feherke]

Hi

On Linux/Unix using [tt]bash[/tt] :

psql -h localhost -p 5555 -U puser -d pdatabase -o c:\tabledump.txt -A -t [red]-R $'\r\n'[/red] -c "select * from ptable"

If nobody else knows the answer, then ask in a Windows forum for [tt]'\r\n'[/tt]'s alternative.

Feherke.

http://rootshell.be/~feherke/