> > 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.