From: | Theo Galanakis <Theo(dot)Galanakis(at)lonelyplanet(dot)com(dot)au> |
---|---|
To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Export tab delimited from mysql to postgres. |
Date: | 2004-10-10 22:59:40 |
Message-ID: | 82E30406384FFB44AFD1012BAB230B5505F40D3A@shiva.au.lpint.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-10-11 09:21:31 | Re: SQL doubt - Date Add |
Previous Message | Gaetano Mendola | 2004-10-10 14:37:36 | Re: SQL doubt - Date Add |