Re: Explicit NULL for no INTEGER data? -- Update

From: Mike Christensen <mike(at)kitchenpc(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Explicit NULL for no INTEGER data? -- Update
Date: 2011-02-18 23:18:04
Message-ID: AANLkTimwxUUqTeYKFZa=uC3jGqAktEfGfwnHtPoFZRO6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)appl-ecosys(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Radosław Smogura 2011-02-18 23:29:59 Postgresql prepared transactions
Previous Message Rich Shepard 2011-02-18 23:12:05 Re: Explicit NULL for no INTEGER data? -- Update