I hadn't noticed that for that table I left out the with NULL AS
'NULL'. That did fix the problem. I appreciate the help. I now have
a completed database from mysql!
On Sep 17, 2004, at 12:37 PM, M. Bastin wrote:
> At 12:31 PM -0400 9/17/04, Sean Davis wrote:
>> 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: invalid input syntax for integer: "NULL"
>> CONTEXT: COPY cgap_lib,line 1, column clones: "NULL"
> Your text columns will probably have imported the text "NULL."
> From http://www.postgresql.org/docs/7.4/interactive/sql-copy.html
> "null string
> The string that represents a null value. The default is \N
> (backslash-N). You might prefer an empty string, for example."
> You can choose your own null string with:
> [ NULL [ AS ] 'null string' ] ]
In response to
pgsql-novice by date
|Next:||From: Alexander Jochum||Date: 2004-09-17 18:41:58|
|Subject: Re: Installation problem... |
|Previous:||From: M. Bastin||Date: 2004-09-17 16:37:35|
|Subject: Re: Looking for postgres equivalent of mysqlimport|