Skip site navigation (1) Skip section navigation (2)

Re: Newlines in pg_dump output?

From: Brent Dombrowski <brent(dot)dombrowski(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>,pdxpug(at)postgresql(dot)org
Subject: Re: Newlines in pg_dump output?
Date: 2011-02-03 16:56:04
Message-ID: 25181480-1292-46f2-9058-9d68b8c09ac0@email.android.com (view raw or flat)
Thread:
Lists: pdxpug
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 

In response to

Responses

pdxpug by date

Next:From: David E. WheelerDate: 2011-02-03 16:56:50
Subject: Re: Newlines in pg_dump output?
Previous:From: David E. WheelerDate: 2011-02-03 16:55:38
Subject: Re: Date Format Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group