moving from postgres to mysql

[Alex Beamish]

On 8/2/05, JM <jerome-mhXWc29+iYPyG1zEObXtfA at public.gmane.org> wrote:
> hi all,
> 
>         is there an available application that can migrate postgres data to mysql

Hi there,

I've used both, and the main differences I can think of are that MySQL
does a little less .. no sub-selects, no referential integrity. I'm
not up to date with the latest version 4 of MySQL, so that may have
changed. My baseline is 3.2.2 of MySQL and 7.4.3 of PostgreSQL.

If you do a pg_dump from PostgreSQL, and then load the result into
MySQL (it's been too long, I don't remember the comamnd) I'm guesing
that will work. Then you just have to get used to the differences in
how the command prompt works -- show tables instead of \d; and
describe table foo instead of \d foo.

When you talk about changing a database, I presume this also means you
need to change an application, and that may be work involved work.
What versions of MySQL and PostgreSQL are you working with?

Alex

-- 
----------
Linux, Firefox and GMail .. what a combination.
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml