Transfer from MySQL to PostgreSQL

From: Andrea <andrea(dot)b73(at)email(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Transfer from MySQL to PostgreSQL
Date: 2006-03-28 09:49:16
Message-ID: 4429069C.6090404@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Christoph Frick 2006-03-28 10:07:22 Re: Transfer from MySQL to PostgreSQL
Previous Message Adam Witney 2006-03-28 09:44:38 Re: Transfer from MySQL to PostgreSQL