|
|
 | | From: | Din Adrian | | Subject: | Trick to 'run' a view on two databases and combine the result ? | | Date: | Fri, 14 Jan 2005 11:52:46 +0200 |
|
|
 | Hello,
I have a 'big problem' :
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 ...
Any ideea how to obtain this result ?
Thank You,
Adrian Din
--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
|
|
| | From: | Michael Fuhr | | Subject: | Re: Trick to 'run' a view on two databases and combine the result ? | | Date: | Fri, 14 Jan 2005 03:43:01 -0700 |
|
|
| 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/
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
|
|
|
