Thanks for getting back. So just to confirm if a string value , we need to take care off it ourselves by escaping any special character and quote (single, double) ? I am not exactly sure off the escaping part for each of the characters - have read that for single quotes, we need to add one more single quote to escape . Is this true ? Please can you confirm this and specifically for any other character. basically i want to ensure that if i get a string say abc'd"e\fgh/" or something which has characters i need to escape, i need to be aware off which are those characters for which copy command can consider it as invalid CSV. Currently using this COPY table(col1,col2,...coln) FROM STDIN WITH CSV NULL AS 'NULL-VAL' , new ByteArrayInputStream(bytes) thanks again. -- View this message in context: http://postgresql.1045698.n5.nabble.com/copymanager-question-tp5817197p5817315.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
