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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Copy Data Question



> 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.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group