X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F19DE3A18AB for ; Fri, 14 Jan 2005 10:43:30 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50733-03 for ; Fri, 14 Jan 2005 10:43:10 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id CD4683A18CD for ; Fri, 14 Jan 2005 10:43:11 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id j0EAh150054271 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Fri, 14 Jan 2005 03:43:04 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id j0EAh1Yh000894; Fri, 14 Jan 2005 03:43:01 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id j0EAh18W000893; Fri, 14 Jan 2005 03:43:01 -0700 (MST) (envelope-from mfuhr) Date: Fri, 14 Jan 2005 03:43:01 -0700 From: Michael Fuhr To: Din Adrian Cc: pgsql-sql@postgresql.org Subject: Re: Trick to 'run' a view on two databases and combine the result ? Message-ID: <20050114104301.GA850@winnie.fuhr.org> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/99 X-Sequence-Number: 19887 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/