Re: Export tab delimited from mysql to postgres.

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Export tab delimited from mysql to postgres.
Дата
Msg-id 20041011234050.GA17772@wolff.to
обсуждение исходный текст
Ответ на Re: Export tab delimited from mysql to postgres.  (Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>)
Список pgsql-sql
On Tue, Oct 12, 2004 at 09:23:41 +1000, Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au> wrote:
> 
>     Could you provide a example of how to do this?
> 
>     I actually ended up exporting the data as Insert statements, which
> strips out cf/lf within varchars. However it takes an eternity to import
> 200,000 records... 24 hours infact???? Is this normal?

Are you doing the load in one transaction?


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

Предыдущее
От: Theo Galanakis
Дата:
Сообщение: Re: Export tab delimited from mysql to postgres.
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: Export tab delimited from mysql to postgres.