Re: Copy Data Question - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: Copy Data Question
Date
Msg-id 20060623220101.46489.qmail@web31815.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Copy Data Question  (<operationsengineer1@yahoo.com>)
Responses Re: Copy Data Question  (<operationsengineer1@yahoo.com>)
List pgsql-novice
> okay, so i took away the max 4 character
> restriction...  it passed through that column fine,
> but now i get...
> ERROR:  invalid input syntax for integer: "'Nuls'"
> CONTEXT:  COPY t_temp, line 1, column
> assembly_instructions_revision: "'Nuls'"
> again, it seems to want to actually insert 'Nuls'
> instead of interpret it as NULL value.
> also notice the error capitalizes Nuls, even though i
> call it as lowercase.

Can you give an example of a record that has "Nuls" stored in the CVS file?

Regards,

Richard Broersma Jr.

pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Copy Data Question
Next
From:
Date:
Subject: Re: Copy Data Question - SOLVED