pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to select from many database ??
3+ messages / 3 participants
[nested] [flat]
* How to select from many database ??
@ 2005-04-19 03:13 Art - Feping <Feping@artindo.co.id>
0 siblings, 2 replies; 3+ messages in thread
From: Art - Feping @ 2005-04-19 03:13 UTC (permalink / raw)
To: pgsql-sql
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....
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to select from many database ??
@ 2005-04-23 05:19 Michael Fuhr <mike@fuhr.org>
parent: Art - Feping <Feping@artindo.co.id>
1 sibling, 0 replies; 3+ messages in thread
From: Michael Fuhr @ 2005-04-23 05:19 UTC (permalink / raw)
To: Art - Feping <Feping@artindo.co.id>; +Cc: pgsql-sql
On Tue, Apr 19, 2005 at 10:13:52AM +0700, Art - Feping wrote:
>
> 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 ??
PostgreSQL doesn't directly support queries to multiple databases,
but see contrib/dblink for a way to do it. See also the third-party
dbi-link module.
http://pgfoundry.org/projects/dbi-link
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to select from many database ??
@ 2005-04-23 18:18 Christopher Browne <cbbrowne@acm.org>
parent: Art - Feping <Feping@artindo.co.id>
1 sibling, 0 replies; 3+ messages in thread
From: Christopher Browne @ 2005-04-23 18:18 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-04-23 18:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-19 03:13 How to select from many database ?? Art - Feping <Feping@artindo.co.id>
2005-04-23 05:19 ` Michael Fuhr <mike@fuhr.org>
2005-04-23 18:18 ` Christopher Browne <cbbrowne@acm.org>
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