Re: Testing / debuging data import

Поиск
Список
Период
Сортировка
От Shoaib Mir
Тема Re: Testing / debuging data import
Дата
Msg-id bf54be870610041250w77c66afw36b78b21128a27a8@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Testing / debuging data import  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-novice
There is this open source tool "mysql2psql" which is bascially a Perl script that can take as an input MySQL dump file and covnert that to a PostgreSQL specific dump file so that you can restore the dump file easily in PostgreSQL.

You can find the tool at --> http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

Thanks,
----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 10/4/06, Michael Fuhr <mike@fuhr.org > wrote:
On Wed, Oct 04, 2006 at 09:03:50AM +0200, Brendon Gleeson wrote:
> Basically what I want to do is simulate a data import (from a file with
> full insert statements and no table creation), I want the offending
> record/line to be printed to stdout with a verbose / helpful error.

This doesn't quite meet your requirements, but have you looked at
pgloader?

http://pgfoundry.org/projects/pgloader/

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: restart error
Следующее
От: Ray Stell
Дата:
Сообщение: postgresql db account