Convert Postgresql to MySql?

[eluser]kea13[/eluser]
Hi zimco,

I haven't done any PostgreSQL to something else migration, but maybe I can help a little:

you have a table called "thing" which has a primary key of type serial (MySQL's notion of this is AFAIK 'unique') named "id".
In table "transaction" for example you find "author_id int references thing" which tells you that "author_id" is a foreign key to table "thing", referencing "thing"'s column "id".

Any clearer now?

Regards,
Roman


20100122 13:56: weeded out typo