Re: What Would You Like To Do?
От | Hannu Krosing |
---|---|
Тема | Re: What Would You Like To Do? |
Дата | |
Msg-id | 1316004009.9523.4.camel@hvost обсуждение исходный текст |
Ответ на | Re: What Would You Like To Do? (Rodrigo Gonzalez <rjgonzale@estrads.com.ar>) |
Список | pgsql-hackers |
On Tue, 2011-09-13 at 17:02 -0300, Rodrigo Gonzalez wrote: > On 09/13/2011 04:52 PM, Tom Lane wrote: > > Rodrigo Gonzalez<rjgonzale@estrads.com.ar> writes: > >>> In a perfect world, it would be nice if one could do combined queries > >>> linking a PostgreSQL database with an Oracle one, or a MySQL one, > >> Can't you do that with FDW that is present in 9.1? > > FDW provides the structure within which that will eventually be > > possible, but there's no Oracle or MySQL wrapper today ... and there are > > a lot of FDW restrictions that need to be worked on, too. > > > > regards, tom lane > > > They are both listed at wiki > I know there are a lot of limitations....but OP message says "Even > something that is several hundred times slower is going to be faster > than merging the databases together. When I do this today, I have to > write a program (in perl or php) that accesses both databases and merges > it by hand." > Am I wrong that this is currently possible using FDW? Yes, to some extent. And before FDW it was also possible (to some extent) using pl/python or pl/perl to turn remote tables into set returning functions (and if really needed then you could put a view over this function and almost get "a remote view") > Thanks > > Rodrigo Gonzalez > >
В списке pgsql-hackers по дате отправления: