Discussion:
cross databases?
(too old to reply)
Jodi Kanter
2004-07-08 15:18:41 UTC
Permalink
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
***@virginia.edu <mailto:***@virginia.edu>/



/ /

/ /
Devrim GUNDUZ
2004-07-08 15:34:09 UTC
Permalink
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,
Post by Jodi Kanter
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-----


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
Oliver Elphick
2004-07-08 16:00:49 UTC
Permalink
Post by Devrim GUNDUZ
Post by Jodi Kanter
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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)
Mike Rylander
2004-07-08 15:55:31 UTC
Permalink
<posted & mailed>
Post by Jodi Kanter
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.
Post by Jodi Kanter
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
Post by Jodi Kanter
Thanks
Jodi Kanter
Loading...