Re: Explicit NULL for no INTEGER data? -- Update - Mailing list pgsql-general

From Mike Christensen
Subject Re: Explicit NULL for no INTEGER data? -- Update
Date
Msg-id AANLkTimwxUUqTeYKFZa=uC3jGqAktEfGfwnHtPoFZRO6@mail.gmail.com
Whole thread Raw
In response to Re: Explicit NULL for no INTEGER data? -- Update  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Explicit NULL for no INTEGER data? -- Update
List pgsql-general
Judging from:

http://www.postgresql.org/docs/8.1/static/sql-copy.html

It looks like you have to specify your own NULL string with the NULL
AS parameter of the COPY command.

On Fri, Feb 18, 2011 at 3:12 PM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> On Fri, 18 Feb 2011, Rich Shepard wrote:
>
>> Do I need an explicit NULL in that column?
>
>  Update: Placing NULL or a blank produces the same error.
>
>  How should I represent no value for an integer column in a .csv file?
>
> Rich
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Explicit NULL for no INTEGER data? -- Update
Next
From: Radosław Smogura
Date:
Subject: Postgresql prepared transactions