Postgres Pro
Downloads
Home   >   mailing lists

Re: Blank Numeric Column For INSERT - Mailing list pgsql-general

From Rich Shepard
Subject Re: Blank Numeric Column For INSERT
Date
Msg-id alpine.LNX.2.00.1111231209330.28204@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Blank Numeric Column For INSERT  (Richard Broersma <richard.broersma@gmail.com>)
Responses Re: Blank Numeric Column For INSERT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Wed, 23 Nov 2011, Richard Broersma wrote:

> My pg.dump files show nulls as:
> \N

Richard,

   Mine do, too. But, that's not what postgres wants to see in the .sql file.
It takes it as a newline (\n) whether quoted or not.

Thanks,

Rich

pgsql-general by date:

Previous
From: Richard Broersma
Date:
Subject: Re: Blank Numeric Column For INSERT
Next
From: Tom Lane
Date:
Subject: Re: Blank Numeric Column For INSERT