Thread: About DBlink

Hi All,<br /><br />Im trying to find out documentation for postgres module names "dblink", can anyone point me out to
it.What i want to do is join multiple databases instead of multiple tables.<br /><br />Thanks,<br />Sumeet. <br /> 

On Thu, Aug 17, 2006 at 04:37:03PM -0400, Sumeet wrote:
> Im trying to find out documentation for postgres module names "dblink", can
> anyone point me out to it. What i want to do is join multiple databases
> instead of multiple tables.

If you've installed dblink then somewhere on your system should be
a file named README.dblink.  How to find that file depends on the
platform: on many Unix-like systems you can use "locate" or "find",
or if you installed dblink via a package then you could use the
package management tool to display a list of files that it installed.

I'd mention that doing joins between databases isn't a good idea
but it looks like you've already had that discussion in the recent
"Multiple DB join" thread.

http://archives.postgresql.org/pgsql-sql/2006-08/msg00097.php

-- 
Michael Fuhr

Thanks Micheal I dont have dblink installed, I need to find a good documentation which will help me do this and also the place where i can download this module.

Thanks,
Sumeet.




--
Thanks,
Sumeet Ambre
Masters of Information Science Candidate,
Indiana University.

> Thanks Micheal I dont have dblink installed, I need to find a good
> documentation which will help me do this and also the place where i
> can download this module.

dblink is a contrib module, that means it is part of the postgresql
source code distribution.

you can read README.dblink online at

http://developer.postgresql.org/cvsweb.cgi/~checkout~/pgsql/contrib/dblink/README.dblink?rev=1.12.4.1;content-type=text%2Fplain

Bye,
Chris.

-- 

Chris Mair
http://www.1006.org

On Thu, Aug 17, 2006 at 11:25:30PM +0200, Chris Mair wrote:
> > Thanks Micheal I dont have dblink installed, I need to find a good
> > documentation which will help me do this and also the place where i
> > can download this module.
> 
> dblink is a contrib module, that means it is part of the postgresql
> source code distribution.

If you install PostgreSQL via packages then the contrib modules
might be in a package other than the base installation.  If so then
the package will typically have the word "contrib" in its name.

-- 
Michael Fuhr