<p><font face="Times New Roman">Has anyone been able to export and import a tab delimited file from mysql to postgres
successfully?</font><br/><font face="Times New Roman">This is my dilemma which I have posted on mysql sites with no
response,however postgres users may have come across the same issue:</font><p><font face="Times New Roman">Trying to
exporta tab delimited file with the following command, however it does not appear to strip out the CR/LF within a
varcharcolumn.<br /><br /> select * into outfile '/tmp/users.txt' FIELDS ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
fromusers;<br /><br /> However when I use the below function to export as an insert statement, it escapes all the CR/LF
withineach column.<br /><br /> mysqldump --database mydatabase --password --user myusername --verbose --complete-insert
--tablesusers > myfile.sql<br /><br /> Does anyone have any insigt into why the above select does not escape CR/LF
withinvarchar columns?<br /><br /> I really want to get the export as tab delimited working to import into
postgres,whichis much faster than insert statements.<br /><br /> Theo</font><table><tr><td bgcolor="#ffffff"><font
color="#000000">______________________________________________________________________<br/>This email, including
attachments,is intended only for the addressee<br />and may be confidential, privileged and subject to copyright. If
you<br/>have received this email in error, please advise the sender and delete<br />it. If you are not the intended
recipientof this email, you must not<br />use, copy or disclose its content to anyone. You must not copy or <br
/>communicateto others content that is confidential or subject to <br />copyright, unless you have the consent of the
contentowner.<br /></font></td></tr></table>
