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.
On 8/17/06, Michael Fuhr <mike@fuhr.org> wrote: 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
--
Thanks,
Sumeet Ambre
Masters of Information Science Candidate,
Indiana University.