On 02/25/2013 11:21 AM, Frank Cavaliero wrote:
Hi Adrian, Thanks a lot! I will certainly look into the multiple datasources as an option.
Just remember, as John pointed out, a MySQL database and a Postgres database are not equivalent. You will not be able to do cross database operations(with the core tools). If you want that then you will need to use Postgres schemas instead. There is work going forward on a Postgres foreign data wrapper(http://www.postgresql.org/docs/devel/static/postgres-fdw.html) that will allow cross database operations, but it is only in the development code and is very basic at this point. There is also the dblink module(http://www.postgresql.org/docs/9.2/static/dblink.html).
-Frank
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
