From: Bing Du <bdu@iastate.edu>
To: pgsql-sql@postgresql.org
Subject: can insert 'null' into timestamp type field from command line but not from input file?
Date: Tue, 13 Jan 2004 11:28:41 -0600 (CST)
Message-ID: <2498.129.186.197.127.1074014921.squirrel@mail.eng.iastate.edu> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bdu@iastate.edu
Subject: Re: can insert 'null' into timestamp type field from command line but not from input file?
In-Reply-To: <2498.129.186.197.127.1074014921.squirrel@mail.eng.iastate.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox