Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: operationsengineer1Date: 2006-06-23 22:52:22
Subject: Re: Copy Data Question - SOLVED
Previous:From: Richard Broersma JrDate: 2006-06-23 21:54:35
Subject: Re: Copy Data Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group