I have find the solution you must do COPY INTO from PROMPT OF DOS like this: C:\Program Files\MonetDB\MonetDB5> mclient -d demo -s " COPY INTO LINEORDER FROM STDIN USING DELIMITERS '|','\n'" - < G:\BDC\DATA\LINEORDER.tbl LINEORDER IS the table in database and LINEORER.tbl is the text file that contain data to load, and demo is the name of database 万萌 wrote:
Hi guys,
i got the following error when COPY INTO TABLE test:
sql>COPY INTO test from ('/home/svom/log3'); COPY INTO: insufficient privileges: binary COPY INTO requires administrator rights
the file "log3" is in mode 777, so i dont know why this happend, thanks for help!
Wan meng
SVOM, NAOC
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://old.nabble.com/COPY-INTO%3A-insufficient-privileges%3A-binary-COPY-IN... Sent from the monetdb-users mailing list archive at Nabble.com.