A linefeed is not the same as '\n' !! On 15/04/16 00:13, Knezevic Nikola wrote:
Hi Martin,
Thanks for the tip, but I get nothing (I also tried playing with different delimiters, just to be sure)
% mclient -d some_db -s "COPY 15 RECORDS INTO errortable FROM STDIN USING DELIMITERS '\t','\n','\r','\'' best effort;" -
mclient -u monetdb -d some_db password: Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015-SP4) Database: MonetDB v11.21.19 (Jul2015-SP4), 'mapi:monetdb://internal:50000/some_db' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select * from sys.rejects; +-------+-------+---------+-------+ | rowid | fldid | message | input | +=======+=======+=========+=======+ +-------+-------+---------+-------+ 0 tuples (1.779ms) sql>select * from some_db.errortable; +--------------+------+ | rejectreason | text | +==============+======+ +--------------+------+ 0 tuples (1.851ms)
% mclient -d some_db -s "COPY 15 RECORDS INTO errortable FROM STDIN USING DELIMITERS '\t','\n','\'' best effort;" -
Lines in the file are delimited by 0x0a (LF) and columns with 0x09 (TAB).