Re: [MonetDB-users] Copy Into problem

Alfred Nordman wrote:

Hi Fabian,

It happens even if i change the table declartion so that column A is timestamp.

The last couple of days the COPY functionality has been improved and made more robust. It might be that you hit one of the bugs solved. The following experiment runs:

mk> mclient -lsql sql>create table tmp_date ( d timestamp, s string); 0 tuples sql>COPY 1 RECORDs INTO tmp_date FROM stdin USING DELIMITERS '|', '\n'; more>1997-01-01 00:00:00|City Mall Rows affected 1 sql>select * from tmp_date; +----------------------------+-----------+ | d | s | +============================+===========+ | 1997-01-01 00:00:00.000000 | City Mall | +----------------------------+-----------+ 1 tuple