In article <[EMAIL PROTECTED]>, Theo Galanakis <[EMAIL PROTECTED]> writes:
> 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; It's a MySQL bug/misfeature that it doesn't translate CRs into '\r'. Nevertheless, you can import a MySQL tab delimited file into PostgreSQL - just pipe it through a small sed script. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
