Postgres Pro
Downloads
Home   >   mailing lists

About transform SQL grammar from postgresql 8.0 to mysql 3.0 - Mailing list pgsql-general

From Emi Lu
Subject About transform SQL grammar from postgresql 8.0 to mysql 3.0
Date
Msg-id 434BDB95.1090004@cs.concordia.ca
Whole thread Raw
Responses Re: About transform SQL grammar from postgresql 8.0 to  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-general
Tree view 
Hello,

I know there is a script in perl can transform all sql commands in mysql
into the queries supported by postgreSQL.

Since we have not finished moving all data from mysql into postgresql,
we need dump around 60 tables from postgresql 8.0 to mysql 3.0 on a
daily basis.

So, I am looking for some existing scripts that can change postgresql
SQL grammar (E.g., filtering "set search_path") into the ones supported
by mysql 3.0?

Thanks a lot!
Emi

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: PostgreSQL terminated abnormally
Next
From: Ludwig Isaac Lim
Date:
Subject: \dD does not show check constraint for domain on version 8.0.4?