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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.