Re: Looking for postgres equivalent of mysqlimport

Marc,

That seemed to get most of the way (setting to NULL). However, it
seems that does not work for integer columns? I'm still getting an
error:

ERROR: invalid input syntax for integer: "NULL"
CONTEXT: COPY cgap_lib,line 1, column clones: "NULL"

Here is the schema:
CREATE TABLE "cgap_lib" (
"cgap_lib_id" character varying(16) NOT NULL,
"organism" character varying(64) NOT NULL,
"libid" character varying(16) NOT NULL,
"unilib_id" character varying(16) NOT NULL,
"descr" character varying(3500),
"keywords" character varying(256),
"clones" smallint,
"strain" character varying(128),
"tissue" character varying(256),
"unique_tissue" character varying(128),
"edit_date" date NOT NULL,
"get_date" date NOT NULL
);

Here is the first line:
cg2_000000027681 Mus musculus 241 78 Mouse liver library liver, normal,
bulk, EST NULL NULL NULL liver 2004-8-17 2004-8-23

Any more insights?

Thanks again,
Sean

On Sep 17, 2004, at 12:15 PM, M. Bastin wrote:

> At 9:37 AM -0400 9/17/04, Sean Davis wrote:
>> Marc,
>>
>> Thanks. That is what I had thought. Another detail--I have fields
>> (including some dates) that include "" (empty fields). What is the
>> best way to deal with those? Should I just convert them to NULL
>> (assuming that was the actual meaning) and then use that as the NULL
>> string in the copy command?
>
> Sean,
>
> I think you could try that. You may leave them empty as well (after
> stripping '"') and use that for NULL with the COPY command.
>
> Marc