From: Michael Fuhr <mike@fuhr.org>
To: Din Adrian <adrian.din@easynet.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: Trick to 'run' a view on two databases and combine the result ?
Date: Fri, 14 Jan 2005 03:43:01 -0700
Message-ID: <20050114104301.GA850@winnie.fuhr.org> (raw)
In-Reply-To: <opskk618apawcxfg@adi>
References: <opskk618apawcxfg@adi>
On Fri, Jan 14, 2005 at 11:52:46AM +0200, Din Adrian wrote:
> I have to show some data from two identical databases so I need to run a
> querry (view, ..etc) on both databases and show the united result ...
If you're writing an application then you could make two database
connections, run the query in each, and merge the results in the
application. If you want to do it in PostgreSQL then you could use
contrib/dblink. If that's not helpful then please provide more
information about what you need to do.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, adrian.din@easynet.ro
Subject: Re: Trick to 'run' a view on two databases and combine the result ?
In-Reply-To: <20050114104301.GA850@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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