How can I insert NULL into column with the type of timestamp?

From: "bookman bookman" <bookmanb(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How can I insert NULL into column with the type of timestamp?
Date: 2007-12-11 02:29:04
Message-ID: 28a0e9620712101829i17cb2b80m4074c242e331c02b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

H i ,

I want to tansfer a database from sqlserver2005 to postgresql8.2.5.I
use bcp to export a table named admin in sqlserver to a text file:

--table T_admin
id name key regDate
isLock realName
1 rison 998877 2007-08-27 10:24:57 False admin
2 lijun 778899 NULL False NULL
3 guanliyuan 111111 2007-11-05 10:30:08 False myAdmin

--admin.txt
id name key regDate
isLock realname
1 ris 998877 2007-08-27 10:24:57.000 0 admin
2 lij 778899 0
3 guanliyuan 111111 2007-11-05 10:30:08.813 0 myAdmin

I created a table in postgresql,and I use "copy" to import datas

create table T_Admin(
adminID serial not null primary key,
name varchar(30) null,
key varchar(30) null,
regDate timestamp null,
isLock bool null,
realName varchar(30) null
)

copy admin from "/home/postgres/data/admin.txt"

Then error occured:
error:invalid input syntax for type timestamp:""
context:copy T_Admin ,line 2,column regDate:""
It seemed that the column REGDATE cannot accept a NULL.I tested it use:
insert into T_Admin(name,key,regDate,isLock,realName)
values('aaa','aaa','','1','aaa');
The same error occured.

So it means that the column with type timestamp cannot accept a NULL
.Is there any way I can tansfer this table into postgre?How can i deal
with NULL in this case?
Thank you!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-12-11 04:18:40 Re: partitioned table query question
Previous Message Alvaro Herrera 2007-12-11 02:10:19 Re: SQL design pattern for a delta trigger?