Re: Scheme conversion MySQL to PGSQL

Hello Igal

Am 2017-12-24 hackte Igal @ Lucee.org in die Tasten:
> I agree with Andreas.  First create the tables, then create the
> indexes.  If you can copy the data before creating the indexes then
> you
> will probably save some time on all of the INSERTs.
>
> I am doing a similar thing migrating from SQL Server, and I am
> considering to publish an open source Migrator.
>
> Can you tell me about some of the data types that you had to change
> moving from MySQL to Postgres?

I convert only those four CREATE TABLE from mySQL to pgSQL which
is the forum pluging for squirrelmail.

auto_increment -> serial
int(NN) -> int
datetime -> timestamptz (attention: it is NOT timestamp)
longtext -> text

ENGINE=MyISAM hast to be removed.

This are things, which I found on the internet.

Greetings
Michelle

--
Michelle Konzack
00372-54541400