From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Frank Cavaliero <fcavalie(at)us(dot)ibm(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Use, Set Catalog and JDBC questions |
Date: | 2013-02-25 21:30:27 |
Message-ID: | 512BD7F3.1020504@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | a f | 2013-02-26 00:33:55 | a f |
Previous Message | Frank Cavaliero | 2013-02-25 19:21:25 | Re: [GENERAL] Use, Set Catalog and JDBC questions |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2013-02-26 07:48:09 | Re: Floating point error |
Previous Message | Shawn Chisholm | 2013-02-25 20:04:09 | Windows build question |