| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | ingram(at)samsix(dot)com |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: NULLs on datetime problem (for me at least :) ) |
| Date: | 2002-01-18 01:19:58 |
| Message-ID: | 1011316800.6385.55.camel@linda |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, 2002-01-17 at 16:09, Stephen Ingram wrote:
> I am having problems loading data into a datetime field when
> the table allows NULL for the date.
>
> I assume I am doing something silly. Can anyone help me?
> Preferably technical rather than medical :)
Represent nulls by \N in your input file. An empty string is not the
same.
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"And, behold, I come quickly; and my reward is with me,
to give every man according as his work shall be."
Revelation 22:12
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Hesketh | 2002-01-18 05:33:25 | Re: PL/PGSQL function problem |
| Previous Message | Doug Royer | 2002-01-18 00:05:35 | Re: [ANNOUNCE] Commercial: New Book!! PostgreSQL book is |