| From: | "George Pavlov" <gpavlov(at)mynewplace(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Quoted NULLs with COPY FROM |
| Date: | 2006-01-24 03:32:31 |
| Message-ID: | CCB89282FCE1024EA3DCE687A96A51640471F401@ehost010-6.exch010.intermedia.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > I need to load CSV files that have quotes in data fields
> > that I want to
> > map to NULLs in the destination table. So if I see
> > ...,"",... that needs
> > to be mapped to a NULL (in an INTEGER field in this
> > particular case).
> > Are there any COPY command options that can do that? It
> > seems that PgSQL
> > COPY expects the NULL to be always unquoted. There is an
> > option (FORCE
> > NOT NULL) for doing the opposite. How do I specify that the
> > NULLs are quoted? I am on 8.0.5.
>
> Did you try NULL AS ''?
yes i did. that is the default and does not change the outcome (same
errors about trying to insert an empty string into a numeric field.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Caduto | 2006-01-24 03:34:29 | Re: Does this look ethical to you? |
| Previous Message | Bruce Momjian | 2006-01-24 03:27:28 | Re: Does this look ethical to you? |