pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTrick to 'run' a view on two databases and combine the result ?
2+ messages / 2 participants
[nested] [flat]
* Trick to 'run' a view on two databases and combine the result ?
@ 2005-01-14 09:52 Din Adrian <adrian.din@easynet.ro>
0 siblings, 1 reply; 2+ messages in thread
From: Din Adrian @ 2005-01-14 09:52 UTC (permalink / raw)
To: pgsql-sql
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Trick to 'run' a view on two databases and combine the result ?
@ 2005-01-14 10:43 Michael Fuhr <mike@fuhr.org>
parent: Din Adrian <adrian.din@easynet.ro>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Fuhr @ 2005-01-14 10:43 UTC (permalink / raw)
To: Din Adrian <adrian.din@easynet.ro>; +Cc: 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/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-01-14 10:43 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-14 09:52 Trick to 'run' a view on two databases and combine the result ? Din Adrian <adrian.din@easynet.ro>
2005-01-14 10:43 ` Michael Fuhr <mike@fuhr.org>
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