Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-general-owner+M195378=pgsql-general-arkari@postgresql.org>)
	id 1UA5d5-00009G-M0 for pgsql-general@arkaria.postgresql.org;
	Mon, 25 Feb 2013 21:30:35 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-general-owner+M195378=pgsql-general-arkari@postgresql.org>)
	id 1UA5d5-0000gC-6g for pgsql-general@arkaria.postgresql.org;
	Mon, 25 Feb 2013 21:30:35 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>)
	id 1UA5d4-0000g4-5R; Mon, 25 Feb 2013 21:30:34 +0000
Received: from mail-pa0-f42.google.com ([209.85.220.42])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>)
	id 1UA5d0-0002yw-Vx; Mon, 25 Feb 2013 21:30:33 +0000
Received: by mail-pa0-f42.google.com with SMTP id kq12so1987556pab.29
	for <multiple recipients>; Mon, 25 Feb 2013 13:30:29 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=x-received:message-id:date:from:user-agent:mime-version:to:cc
	:subject:references:in-reply-to:content-type
	:content-transfer-encoding;
	bh=oN5cI1RYvuTwYw1Em0zUCt2q0obBXpoVM9OZX/aa1C4=;
	b=gjXD68g+nbO8SXsKc5nT9LOvGUvz1GouHptdRI8GgtlF1BJn2z6iKvdFLstmASjUMe
	uyHJfRifOWkk0wUATOEXp+JQQgOLn05Y9FGcjRq9gViGIK+bdBfzlsDj8sBXU0Mb3XFh
	h5SLF+Mmhk5uvW+M8t+BocNz6YbsS1LrF0aXZtN68it98Hlz4UrfyOW0l2CoW6BwB0/h
	n2Y1XeMkseF3v5lBTUfa+wW9xXNKx7sZot8CZZT5kt3VIlGuDU05O2qQ01jVU15SP/Nf
	rp1GHEtWvbnFqQVGSPM67Y1+ldyGIznyiKr7LJYBNv0eIkVDcmrNkxUPB+Z0ZFkbnlXT
	RI9g==
X-Received: by 10.66.186.164 with SMTP id fl4mr21514001pac.51.1361827829475;
	Mon, 25 Feb 2013 13:30:29 -0800 (PST)
Received: from [192.168.0.2] (c-24-17-164-54.hsd1.wa.comcast.net.
	[24.17.164.54])
	by mx.google.com with ESMTPS id kb3sm13890104pbc.21.2013.02.25.13.30.27
	(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
	Mon, 25 Feb 2013 13:30:28 -0800 (PST)
Message-ID: <512BD7F3.1020504@gmail.com>
Date: Mon, 25 Feb 2013 13:30:27 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
To: Frank Cavaliero <fcavalie@us.ibm.com>
CC: pgsql-admin@postgresql.org, pgsql-general@postgresql.org
Subject: Re: Use, Set Catalog and JDBC questions
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>
In-Reply-To: 
 <OF6F4F651B.D28C08CE-ON85257B1D.006A7107-85257B1D.006A9B1B@us.ibm.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
X-Mailing-List: pgsql-general
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

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