postgres -> other databases

Michael Lush mjlush at ebi.ac.uk
Wed Jan 30 07:25:46 PST 2008


Some moons ago I heard of a perl project that allowed a postgres database
to treat tables in other databases as part of itself.

I have a postgres database that updates a MySQL server that runs our 
public database.  It would be nice to update it with

SELECT * INTO mysql_production_table FROM postgres_table;

Alas I can't remember the projects name or any googletastic searchterms to 
find it

Can anyone prop up my failing faculties (and save me from writing a two
handle SELECT -> INSERT script)


--
Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael John Lush PhD			Tel:44-1223 492626
Bioinformatician 
HUGO Gene Nomenclature Committee	Email: hgnc at genenames.org
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


More information about the MiltonKeynes-pm mailing list