Re: Database Conversion

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Database Conversion
Дата
Msg-id 200809041641.29301.achill@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Database Conversion  (Carol Walter <walterc@indiana.edu>)
Ответы Re: Database Conversion  (Ben Kim <bkim@tamu.edu>)
Список pgsql-admin
Στις Thursday 04 September 2008 16:24:34 ο/η Carol Walter έγραψε:
> Hello, All,
>
> I have a new faculty member who has a large database that is in
> MySQL.  We don't support MySQL so the database needs to be ported to
> PostgreSQL.  Her GA, who know MySQL, says that he has a query that he
> will run that will put the data into postgres.  I thought that the
> data would have to be output to a text file and then copied into
> postgres.  I don't know MySQL.  I've done a conversion from Oracle
> and this is how I did it.  Is he correct that he can put the data
> into a postgres database by running a MySQL query?  It doesn't sound
> possible to me.

If his query is like:

SELECT 'INSERT INTO PostgreSqlTable(...) VALUES(''||somevalue...||'')' FROM mysqltable ....

then it is possible

>
> Carol
>



--
Achilleas Mantzios

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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Database Conversion
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_dump etc. versions