George Pavlov wrote: > 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 ''? -- Bruce Momjian | http://candle.pha.pa.us pgman@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
