So, do you know where I can find out an example for that? *Fran*
On 14 November 2010 14:13, Leif Biberg Kristensen [via PostgreSQL] < ml-node+3264406-1436673590-144...@n5.nabble.com<ml-node%2b3264406-1436673590-144...@n5.nabble.com> > wrote: > On Sunday 14. November 2010 13.44.53 franrtorres77 wrote: > > > > Hi there > > > > I need to add periodically some data from a remote mysql database into > our > > postgresql database. So, does anyone know how to do it having in mind > that > > it must be runned every minute or so for adding new records to the > > postresql? > > It should be trivial to write a Perl script that pulls the data from MySQL, > > inserts them into PostgreSQL, and then goes to sleep for 60 seconds. > > regards, > Leif B. Kristensen > > -- > Sent via pgsql-general mailing list ([hidden > email]<http://user/SendEmail.jtp?type=node&node=3264406&i=0>) > > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > > ------------------------------ > View message @ > http://postgresql.1045698.n5.nabble.com/Adding-data-from-mysql-to-postgresql-periodically-tp3264392p3264406.html > To unsubscribe from Adding data from mysql to postgresql periodically, click > here<http://postgresql.1045698.n5.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=3264392&code=ZnJhbnJ0b3JyZXM3N0BnbWFpbC5jb218MzI2NDM5MnwtMTgwNDc3ODEwMw==>. > > > -- View this message in context: http://postgresql.1045698.n5.nabble.com/Adding-data-from-mysql-to-postgresql-periodically-tp3264392p3264415.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
