| From: | Bill Todd <pg(at)dbginc(dot)com> |
|---|---|
| To: | jd(at)commandprompt(dot)com, "pgsql-general(at)postgresql(dot)org >> PgSQL General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: COPY error with null date |
| Date: | 2008-12-08 00:13:50 |
| Message-ID: | 493C66BE.4000503@dbginc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Joshua D. Drake wrote:
> On Fri, 2008-12-05 at 12:00 -0700, Bill Todd wrote:
>
>> Joshua D. Drake wrote:
>>
>>> On Thu, 2008-12-04 at 19:35 -0700, Bill Todd wrote:
>>>
>>>>
>>>>
>> null as IS NULL results in the following error.
>>
>> ERROR: syntax error at or near "is"
>> LINE 5: null as is null
>> ^
>>
>> ********** Error **********
>>
>> ERROR: syntax error at or near "is"
>> SQL state: 42601
>> Character: 109
>>
>> Any other suggestions?
>>
>
>
> COPY foo FROM '/tmp/bar' NULL as 'NULL'
>
>
copy billing.contact from 'c:/export/contact.csv'
with csv delimiter as ','
null as 'NULL'
quote as '"';
produces the same error. I am beginning to suspect this is impossible. :-(
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-12-08 00:22:40 | Re: COPY error with null date |
| Previous Message | Tom Lane | 2008-12-07 22:31:38 | Re: ALTER TABLE .....Error: Must be owner of the table |