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 EF7B952985 for ; Sat, 23 Apr 2005 15:32:58 -0300 (ADT) 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 57734-06 for ; Sat, 23 Apr 2005 18:32:49 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7F298542CC for ; Sat, 23 Apr 2005 15:32:48 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 7E12F30E8A; Sat, 23 Apr 2005 20:31:30 +0200 (MET DST) From: Christopher Browne X-Newsgroups: pgsql.sql Subject: Re: How to select from many database ?? Date: Sat, 23 Apr 2005 14:18:30 -0400 Organization: cbbrowne Computing Inc Lines: 26 Message-ID: References: <329EE23F2E3C9843B969AE66CDCB69C902C632@hmu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:VSLTaxlb1VHFV+VUvWPKflbrez0= To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.386 tagged_above=0 required=5 tests=AWL, INFO_TLD X-Spam-Level: X-Archive-Number: 200504/362 X-Sequence-Number: 21255 Oops! Feping@artindo.co.id (Art - Feping) was seen spray-painting on a wall: > i want to select from many databases, for example , i want to select table > master in database A, and table master in database B. > can i do it like this : " select * from A.Master, B.Master " just like > in SQL Server ?? > or can somebody help me how to select many database in postgresSQL ?? Thank > u.... There is a module called "dblink" in the contrib area that can do this. You obviously don't get to maintain all the "goodies" of integrity constraints and MVCC 'synchronization' of data. If you find you have applications where you are accessing multiple databases like this, you should consider whether or not they could perhaps be joined into one database by putting the data into several namespaces or schemas. That _may_ not be possible, but it's worth investigating, as it is likely to be _way_ more efficient... -- let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;; http://linuxfinances.info/info/lsf.html PASCAL is not a language. It was an experiment combining the flexibilty of C with that of a drug-crazed penguin. It is also the 'language' of choice of many CS professors who aren't up to handling REAL programming. Hence, it is not a language.