Re: Trick to 'run' a view on two databases and combine the result ?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Din Adrian <adrian(dot)din(at)easynet(dot)ro>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Trick to 'run' a view on two databases and combine the result ?
Date: 2005-01-14 10:43:01
Message-ID: 20050114104301.GA850@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message KÖPFERL Robert 2005-01-14 18:44:06 Re: Column with recycled sequence value (solved (somehow))
Previous Message Din Adrian 2005-01-14 09:52:46 Trick to 'run' a view on two databases and combine the result ?