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: | Raw Message | Whole Thread | 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? |