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

Re: Newlines in pg_dump output?

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pdxpug(at)postgresql(dot)org
Subject: Re: Newlines in pg_dump output?
Date: 2011-02-03 16:56:50
Message-ID: 8081F685-EFEB-4AFE-91C4-933BA0D36669@kineticode.com (view raw or flat)
Thread:
Lists: pdxpug
On Feb 3, 2011, at 8:52 AM, Rich Shepard 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.

Those are NULLs.

Best,

David


In response to

pdxpug by date

Next:From: Rich ShepardDate: 2011-02-03 16:58:38
Subject: Re: Date Format Question
Previous:From: Brent DombrowskiDate: 2011-02-03 16:56:04
Subject: Re: Newlines in pg_dump output?

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