Newlines in pg_dump output?

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Newlines in pg_dump output?
Date: 2011-02-03 16:52:26
Message-ID: alpine.LNX.2.00.1102030848060.25032@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

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

Responses

Browse pdxpug by date

  From Date Subject
Next Message David E. Wheeler 2011-02-03 16:55:38 Re: Date Format Question
Previous Message Rich Shepard 2011-02-03 16:14:43 Date Format Question