pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Adrian Klaver <adrian.klaver@gmail.com>
To: Frank Cavaliero <fcavalie@us.ibm.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: Use, Set Catalog and JDBC questions
Date: Mon, 25 Feb 2013 13:30:27 -0800
Message-ID: <512BD7F3.1020504@gmail.com> (raw)
In-Reply-To: <OF6F4F651B.D28C08CE-ON85257B1D.006A7107-85257B1D.006A9B1B@us.ibm.com>
References: <OF452CD15F.978F2C6E-ON85257B1D.0063F9C0-85257B1D.00653F7F@us.ibm.com>
	<512BAE9A.2000401@gmail.com>
	<OF634F0290.B126088B-ON85257B1D.00681DCA-85257B1D.0068631C@us.ibm.com>
	<512BB5AD.3080505@gmail.com>
	<OF6F4F651B.D28C08CE-ON85257B1D.006A7107-85257B1D.006A9B1B@us.ibm.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.klaver@gmail.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



view thread (12+ messages)

Message-ID: <512BD7F3.1020504@gmail.com>
Permalink:  ../512BD7F3.1020504@gmail.com/
Also on:    postgresql.org/message-id/512BD7F3.1020504@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: adrian.klaver@gmail.com, fcavalie@us.ibm.com, pgsql-general@postgresql.org
  Subject: Re: Use, Set Catalog and JDBC questions
  In-Reply-To: <512BD7F3.1020504@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox