Re: Getting Mysql data into Postgres: least painful methods?

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, ktanzer(at)desc(dot)org
Subject: Re: Getting Mysql data into Postgres: least painful methods?
Date: 2013-01-12 00:12:29
Message-ID: 50F0AA6D.1010502@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01/11/2013 03:54 PM, Ken Tanzer wrote:
>
>
>
> but that didn't bring me much success. I figure this has to be a fairly
> common need, and hopefully by 2013 there's an easy solution. Thanks in
> advance!

Have you looked at Foreign Data Wrappers(FDW):

http://www.postgresql.org/docs/9.1/static/sql-createforeigndatawrapper.html

If you use Python there is Multicorn:
http://www.postgresql.org/docs/9.1/static/sql-createforeigndatawrapper.html

There is also mysql_fdw:
http://wiki.postgresql.org/wiki/Foreign_data_wrappers#mysql_fdw

>
> Ken
>
> --

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message wd 2013-01-12 00:30:29 Re: Getting Mysql data into Postgres: least painful methods?
Previous Message Ken Tanzer 2013-01-11 23:54:44 Getting Mysql data into Postgres: least painful methods?