From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-sql@postgresql.org
Subject: Re: How to select from many database ??
Date: Sat, 23 Apr 2005 14:18:30 -0400
Message-ID: <m31x91tkzt.fsf@knuth.cbbrowne.com> (raw)
References: <329EE23F2E3C9843B969AE66CDCB69C902C632@hmu>
Oops! Feping@artindo.co.id (Art - Feping) was seen spray-painting on a wall:
> i want to select from many databases, for example , i want to select table
> master in database A, and table master in database B.
> can i do it like this : " select * from A.Master, B.Master " just like
> in SQL Server ??
> or can somebody help me how to select many database in postgresSQL ?? Thank
> u....
There is a module called "dblink" in the contrib area that can do
this. You obviously don't get to maintain all the "goodies" of
integrity constraints and MVCC 'synchronization' of data.
If you find you have applications where you are accessing multiple
databases like this, you should consider whether or not they could
perhaps be joined into one database by putting the data into several
namespaces or schemas.
That _may_ not be possible, but it's worth investigating, as it is
likely to be _way_ more efficient...
--
let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
http://linuxfinances.info/info/lsf.html
PASCAL is not a language. It was an experiment combining the
flexibilty of C with that of a drug-crazed penguin. It is also the
'language' of choice of many CS professors who aren't up to handling
REAL programming. Hence, it is not a language.
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-sql@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: How to select from many database ??
In-Reply-To: <m31x91tkzt.fsf@knuth.cbbrowne.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