How to remove eol (plus sign) character in postgres batch output

Question

I am running a psql batch script and formatting the output as xml. The problem I am running into is that there is a + character in the output. I want to simply use a newline character instead of a plus. I have tried quite a few different arguments and surprised a thorough google search didn't turn up an answer. I am assuming I can use the pset option to change the output eol character but I was unable to get this to work. The script calls query_to_xml on a stored function.

Calling Batch Script

psql -t -q -U user -h database-qa.example.com -f db_test_query.sql -o output.xml DatabaseToUse 

Example Output

<row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">        +
                                                                   +
   <order_id>12345</order_id>                                      +
   <status_id>ORDER_COMPLETED</status_id>                          +
   <customer_id>9999</customer_id>                                 +
   <company_name>ExampleComany</company_name>                      +
   <main_contact_name>user</main_contact_name>                     +
   <email_address>[email protected]</email_address>                +
   <country_code xsi:nil="true"/>                                  +
   <local_number>1112223333</local_number>                         +
   <address1>1009 Customer Ln</address1>                           +
   <address2></address2>                                           +
   <city>Houston</city>                                            +
   <state_province_geo_id>TX</state_province_geo_id>               +
   <postal_code>77380</postal_code>                                +
   ...

Answer 1

Use unaligned output mode.

psql -qAtX ....

will suppress informational output (quiet), use unaligned mode, output tuples only, suppress psqlrc reading.