| From: | "Bing Du" <bdu(at)iastate(dot)edu> | 
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org | 
| Subject: | can insert 'null' into timestamp type field from command line but not from input file? | 
| Date: | 2004-01-13 17:28:41 | 
| Message-ID: | 2498.129.186.197.127.1074014921.squirrel@mail.eng.iastate.edu | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-sql | 
The table is like this:
========
maxware=# \d test;
               Table "public.test"
 Column |            Type             | Modifiers
--------+-----------------------------+-----------
 a      | timestamp without time zone |
 b      | integer                     |
=========
The following insert command works fine:
maxware=# insert into test (a,b) values (null,'1');
But importing from an input data file does not seem to work as shown below:
=========
maxware=# copy tbl_spcase from '/home/bdu/test/input.data' delimiter as '|';
ERROR:  invalid input syntax for integer: "null"
CONTEXT:  COPY tbl_spcase, line 1, column col_id_spcase: "null"
==========
The input.data file just has one line.  But no matter what I did, neither
of the following input format worked.
1. null|1
2. |1
3. ''|1
How should I represent blank value for the field that's of timestamp type?
Thanks in advance for any help,
Bing
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-01-13 17:31:32 | Re: can insert 'null' into timestamp type field from command | 
| Previous Message | Reinoud van Leeuwen | 2004-01-13 16:32:26 | Re: Copying rows between tables? |