Re: Copy Data Question

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: operationsengineer1(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Copy Data Question
Date: 2006-06-23 22:01:01
Message-ID: 20060623220101.46489.qmail@web31815.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2006-06-23 22:52:22 Re: Copy Data Question - SOLVED
Previous Message Richard Broersma Jr 2006-06-23 21:54:35 Re: Copy Data Question