Re: Getting Mysql data into Postgres: least painful methods? - Mailing list 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.klaver@gmail.com