PostgreSQL to MySQL schema differences

[Lennart Sorensen]

On Tue, Nov 22, 2005 at 02:43:54PM -0500, Madison Kelly wrote:
>   The trick is, I am looking for information on the differences on the 
> two DBMS. I need the details because I am trying to extend my program to 
> support MySQL. My program is written for different distros so I don't 
> want to rely on any specific program if I can avoid it.
> 
>   I've actually got the schema modified to create the tables in MySQL 
> now (you can't set a default for a 'text' table in MySQL!?). Now I am 
> trying to figure out the MySQL equivelant of 'COPY...' and then modify 
> the default values to load into mysql.

Might be simpler to do the pgdump as insert format rather than copy
format.  I am not sure if mysql has an squivalant of copy, or if it does
if it is anything at all similar in syntax.  All sql databases should
support the insert syntax easily, and although much slower, unless you
have thousands of default entries, that doesn't matter.

Lennart Sorensen
--
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