Has anyone been able to export and import a tab delimited file from mysql to postgres successfully?
This is my dilemma which I have posted on mysql sites with no response, however postgres users may have come across the same issue:
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
| ______________________________________________________________________ This email, including attachments, is intended only for the addressee and may be confidential, privileged and subject to copyright. If you have received this email in error, please advise the sender and delete it. If you are not the intended recipient of this email, you must not use, copy or disclose its content to anyone. You must not copy or communicate to others content that is confidential or subject to copyright, unless you have the consent of the content owner. |
