Re: MySQL to Postgres.

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: MySQL to Postgres.
Дата
Msg-id 40D1B7F5.9090802@archonet.com
обсуждение исходный текст
Ответ на MySQL to Postgres.  (Prabu Subroto <prabu_subroto@yahoo.com>)
Список pgsql-general
Prabu Subroto wrote:
> Dear my friends...
>
> I am planning to migrate my database from MySQL to
> Postgres since the MySQL does not have subquery except
> it 4.1. And I can not wait until the 4.1 stable
> version released and included in SuSE distro.
>
> I did mysqldump (into a file, basisdata.txt) and I am
> going to do its query qith pgaccess or pgsql.

You'll probably want \copy or COPY FROM if you've got tab/whatever
separated data.

You might want to look at http://techdocs.postgresql.org/ for notes on
converting from MySQL to PostgreSQL too.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Paul Thomas
Дата:
Сообщение: Re: Database accesss using plperl
Следующее
От: "John Wells"
Дата:
Сообщение: 7.4 for Windows?