Re: Newlines in pg_dump output?

Null values?

Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:

I've not before looked at the output of a pg_dump. However, the text file is the only way for me to clean up inconsistencies I did not catch while importing modified spreadsheet exports. I've seen the .sql output from sqlite3 before, but not from postgres. There appear to be \n (but uppercase) in the file, but not consistently. I want to understand why they're there and if they should be removed. Here are a few lines: \N '96-A001787' 'BC-0.5' 1996-06-02 'Alkalinity, Bicarbonate' 212 'mg/L CaCO3' \N \N '96-A001787' 'BC-0.5' 1996-06-02 'Alkalinity, Carbonate' \N 'mg/L CaCO3' \N \N '96-A001787' 'BC-0.5' 1996-06-02 'Alkalinity, Hydroxide' \N 'mg/L CaCO3' \N \N '96-A001787' 'BC-0.5' 1996-06-02 'Alkalinity, Total' 212 'mg/L CaCO3' \N \N '96-A001787' 'BC-0.5' 1996-06-02 'Conductance, Specific' 731 'umhos/cm' \N \N '96-A001787' 'BC-0.5' 1996-06-02 'Nitrate, Nitrogen' 0.09 'mg/L' \N \N '96-A001787' 'BC-0.5' 1996-06-02 'Nitrite, Nitrogen' \N 'mg/L' \N
\N '96-A001787' 'BC-0.5' 1996-06-02 'pH' 8.46 \N \N \N '96-A001787' 'BC-0.5' 1996-06-02 'Sulfate' 194 'mg/L' \N \N TIA, Rich -- Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org) To make changes to your subscription: http://www.postgresql.org/mailpref/pdxpug