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
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 |