From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: insert into: NULL in date column |
Date: | 2019-01-12 00:00:52 |
Message-ID: | alpine.LNX.2.20.1901111557460.8922@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 11 Jan 2019, Ken Tanzer wrote:
> I think the problem is actually that you're trying to represent your NULL
> dates with '', which PG doesn't like.
Ken,
That's certainly how I saw the error message.
> cat test.csv
>
> my_text,my_date,my_int
> 'Some Text','1/1/18',3
> 'More Text,,2
> 'Enough','',1
>
> CREATE TEMP TABLE my_test (my_text TEXT, my_date DATE, my_int INT);
>
> \copy my_test FROM test.csv WITH CSV HEADER
>
> ERROR: invalid input syntax for type date: "''"
> CONTEXT: COPY my_test, line 4, column my_date: "''"
>
>
> You'll note that it breaks on the last line, which is like yours, not
> the one before it.
Huh! I'll leave off the quote marks and see if that makes a difference ...
tomorrow morning. Since dates are treated as strings I thought their absence
also needed the quotes. Stay tuned to this mail list for test results.
Thanks,
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2019-01-12 00:18:15 | Re: insert into: NULL in date column |
Previous Message | Rich Shepard | 2019-01-11 23:57:40 | Re: insert into: NULL in date column |