Re: Transfer from MySQL to PostgreSQL

Поиск
Список
Период
Сортировка
От Christoph Frick
Тема Re: Transfer from MySQL to PostgreSQL
Дата
Msg-id 20060328100722.GZ13909@byleth.sc-networks.de
обсуждение исходный текст
Ответ на Transfer from MySQL to PostgreSQL  (Andrea <andrea.b73@email.it>)
Ответы Re: Transfer from MySQL to PostgreSQL
Список pgsql-novice
On Tue, Mar 28, 2006 at 11:49:16AM +0200, Andrea 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??

dump the database with insert statements (maybe newer versions of
mysqldump can also dump only one table's data), remove the stuff, that
is not needed with postgres, fix the table names and so on with an
editor of your choice and run the resulting file with psql.

--
cu

Вложения

В списке pgsql-novice по дате отправления:

Предыдущее
От: Adam Witney
Дата:
Сообщение: Re: Transfer from MySQL to PostgreSQL
Следующее
От: ann hedley
Дата:
Сообщение: delete from joined tables