Skip site navigation (1) Skip section navigation (2)

Utility to Convert MySQL to PostgreSQL

From: "Michael Avila" <mavila(at)mich(dot)com>
To: "Pgsql-Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Utility to Convert MySQL to PostgreSQL
Date: 2005-07-24 16:59:48
Message-ID: NBBBLNPHAMCFENDFHIDCOEECEDAA.mavila@mich.com (view raw or flat)
Thread:
Lists: pgsql-novice
I've seen messages on the PostgreSQL website referring to a utility that
converts MySQL statements to PostgreSQL statements. I see that it is
convert(). However, there is no other indication on how it used or where it
is located. I looked in the PostgreSQL 8.0 docs and I could not find it. I
looked in the index for convert and found nothing.

I have a MySQL database table that uses auto increment and other
non-PostgreSQL statements so I would love an easy way to convert MySQL to
PostgreSQL statements and use PostgreSQL instead of MySQL in my project.
This project has the potential to be used throughout the US by volunteer
organizations so it is important that the database be $0, easy to use, and
interface with PHP. I am using a PHP add-in ADODB that should make the last
two easy. But I started the development in MySQL. 

If anyone has any info about how to convert MySQL to PostgreSQL PLEASE let
me know!

Thanks.

Mike



Attachment: winmail.dat
Description: application/ms-tnef (1.8 KB)

Responses

pgsql-novice by date

Next:From: Derrick BettsDate: 2005-07-24 17:00:01
Subject: Re: help with a simple SQL query
Previous:From: Sean DavisDate: 2005-07-24 16:37:55
Subject: Re: XML

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group