Re: Transfer from MySQL to PostgreSQL

On 28/3/06 10:49 am, "Andrea" <andrea(dot)b73(at)email(dot)it> wrote:

> I have both MySQL (5.0) and PostgreSQL (8.1) database servers on my PC.
>
> On MySQL I have a table (very simple, only 7 char fields) filled with
> about 35000 records. On PostgreSQL I have created the same table
> structure (same fields, names, indexes, etc...). I would like to
> transfer all records from MySQL to PostgreSQL.
> Which is the easiest and shortest way to do this??
>
> I know this question is related to a software extern to PostgreSQL,
> however, I hope someone can help me. Thank.

If you can get the data out of the MySQL table into a simple tab delimited
text file, then that is very easy to get it into PostgreSQL using the COPY
command

http://www.postgresql.org/docs/8.1/static/sql-copy.html

(I don't use MySQL though, so can't tell you how to get it into the file)

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.