pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
cross databases?
5+ messages / 5 participants
[nested] [flat]

* cross databases?
@ 2004-07-08 15:18 Jodi Kanter <jkanter@virginia.edu>
  2004-07-08 15:34 ` Re: cross databases? Devrim GUNDUZ <devrim@gunduz.org>
  2004-07-08 15:46 ` Re: cross databases? Hilary Forbes <hforbes@dmr.co.uk>
  2004-07-08 15:55 ` Re: cross databases? Mike Rylander <miker@purplefrog.com>
  0 siblings, 3 replies; 5+ messages in thread

From: Jodi Kanter @ 2004-07-08 15:18 UTC (permalink / raw)
  To: pgsql-admin

I am working with someone who uses MySQL and says that he has two 
separate databases in which he can query across. I am curious if that is 
something that can be done in postgres?
Any comments on whether or not that is a good thing?
Thanks
Jodi Kanter
-- 

/_______________________________
//Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu <mailto:jkanter@virginia.edu>/

 

/ /

/ /

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: cross databases?
  2004-07-08 15:18 cross databases? Jodi Kanter <jkanter@virginia.edu>
@ 2004-07-08 15:34 ` Devrim GUNDUZ <devrim@gunduz.org>
  2004-07-08 16:00   ` Re: cross databases? Oliver Elphick <olly@lfix.co.uk>
  2 siblings, 1 reply; 5+ messages in thread

From: Devrim GUNDUZ @ 2004-07-08 15:34 UTC (permalink / raw)
  To: Jodi Kanter <jkanter@virginia.edu>; +Cc: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Thu, 8 Jul 2004, Jodi Kanter wrote:

> I am working with someone who uses MySQL and says that he has two 
> separate databases in which he can query across. I am curious if that is 
> something that can be done in postgres?

Yes, it's possible with PostgreSQL.

See contrib/dblink.

Regards,

- -- 
Devrim GUNDUZ	       
devrim~gunduz.org				devrim.gunduz~linux.org.tr 
			http://www.tdmsoft.com
			http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFA7Wlztl86P3SPfQ4RAnKTAJ41Xlrx8zQueEZhMlmnbof0hNbfJwCghlEf
LPjc9KUai+jU3pgXC+a1AMI=
=JxHt
-----END PGP SIGNATURE-----




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: cross databases?
  2004-07-08 15:18 cross databases? Jodi Kanter <jkanter@virginia.edu>
  2004-07-08 15:34 ` Re: cross databases? Devrim GUNDUZ <devrim@gunduz.org>
@ 2004-07-08 16:00   ` Oliver Elphick <olly@lfix.co.uk>
  0 siblings, 0 replies; 5+ messages in thread

From: Oliver Elphick @ 2004-07-08 16:00 UTC (permalink / raw)
  To: Devrim GUNDUZ <devrim@gunduz.org>; +Cc: Jodi Kanter <jkanter@virginia.edu>; pgsql-admin

On Thu, 2004-07-08 at 16:34, Devrim GUNDUZ wrote:
> On Thu, 8 Jul 2004, Jodi Kanter wrote:
> 
> > I am working with someone who uses MySQL and says that he has two 
> > separate databases in which he can query across. I am curious if that is 
> > something that can be done in postgres?
> 
> Yes, it's possible with PostgreSQL.
> 
> See contrib/dblink.

But a more convenient alternative is to use schemas, which MySQL does
not (I think) support.

Oliver Elphick




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: cross databases?
  2004-07-08 15:18 cross databases? Jodi Kanter <jkanter@virginia.edu>
@ 2004-07-08 15:46 ` Hilary Forbes <hforbes@dmr.co.uk>
  2 siblings, 0 replies; 5+ messages in thread

From: Hilary Forbes @ 2004-07-08 15:46 UTC (permalink / raw)
  To: Jodi Kanter <jkanter@virginia.edu>; pgsql-admin

<html>
I have often wanted to do this.&nbsp; Years ago, when I was working with
Sybase databases it was perfectly possible.&nbsp; You simply qualified
the table name with a database identifier as I recall eg <br><br>
SELECT m.myfield from second_db.mytable m;<br><br>
The advantages are that you may have two otherwise unconnected systems
which need separately backing up etc but where one uses the other for
lookup purposes (eg a reservations system uses a lookup to an accounts
system to get the customer name and number).&nbsp; <br><br>
I have never understood why postgreSQL hasn't seen this as a priority in
development in more recent months.&nbsp; Maybe someone will enlighten us
both!<br><br>
Hilary<br><br>
At 11:18 08/07/2004 -0400, Jodi Kanter wrote:<br><br>
<blockquote type=cite class=cite cite>I am working with someone who uses
MySQL and says that he has two separate databases in which he can query
across. I am curious if that is something that can be done in postgres?
<br>
Any comments on whether or not that is a good thing?<br>
Thanks<br>
Jodi Kanter<br>
-- <br><br>
<i>_______________________________<br>
Jodi L Kanter<br>
BioInformatics Database Administrator<br>
University of Virginia<br>
(434) 924-2846<br>
<a href="mailto:jkanter@virginia.edu">jkanter@virginia.edu</a></i><br><br>
&nbsp;<br><br>
<i>&nbsp;<br>
</i><br>
<i>&nbsp;</blockquote>
<x-sigsep><p></x-sigsep>
Hilary Forbes<br>
The DMR Information and Technology Group&nbsp;
(<a href="http://www.dmr.co.uk/"; eudora="autourl">www.dmr.co.uk</a>)<br>
Direct tel 01689 889950 Fax 01689 860330 <br>
DMR is a UK registered trade mark of DMR Limited<br>
**********************************************************</i></html>




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: cross databases?
  2004-07-08 15:18 cross databases? Jodi Kanter <jkanter@virginia.edu>
@ 2004-07-08 15:55 ` Mike Rylander <miker@purplefrog.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Mike Rylander @ 2004-07-08 15:55 UTC (permalink / raw)
  To: Jodi Kanter <jkanter@virginia.edu>

<posted & mailed>

Jodi Kanter wrote:

> I am working with someone who uses MySQL and says that he has two
> separate databases in which he can query across. I am curious if that is
> something that can be done in postgres?

Postgresql implements SQL standard SCHEMAs which, depending on your exact
needs, may serve the same purpose.  The other option is the
'contrib/dblink' module.

> Any comments on whether or not that is a good thing?

In my opinion, SCHEMAs are a beter way than multiple databases to deal with
multiple logical datasets that you want to query across.


--miker

> Thanks
> Jodi Kanter




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2004-07-08 16:00 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-08 15:18 cross databases? Jodi Kanter <jkanter@virginia.edu>
2004-07-08 15:34 ` Devrim GUNDUZ <devrim@gunduz.org>
2004-07-08 16:00   ` Oliver Elphick <olly@lfix.co.uk>
2004-07-08 15:46 ` Hilary Forbes <hforbes@dmr.co.uk>
2004-07-08 15:55 ` Mike Rylander <miker@purplefrog.com>

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