export a table to a tab delimited file

[theo.galanakis]

Trying to export a tab delimited file with the following command, however it does not appear to strip out the CR/LF within a varchar column.

select * into outfile '/tmp/users.txt' FIELDS ESCAPED BY '\\' LINES TERMINATED BY '\r\n' from users;

However when I use the below function to export as an insert statement, it escapes all the CR/LF within each column.

mysqldump --database mydatabase --password --user myusername --verbose --complete-insert --tables users > myfile.sql

Does anyone have any insigt into why the above select does not escape CR/LF within varchar columns?

I really want to get the export as tab delimited working to import into postgres,which is much faster than insert statements.

Theo