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 F315A53823 for ; Tue, 19 Apr 2005 00:10:49 -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 09830-01 for ; Tue, 19 Apr 2005 03:10:44 +0000 (GMT) Received: from kelud.indosat.net.id (mx10a.indosat.net.id [202.155.50.2]) by svr1.postgresql.org (Postfix) with SMTP id ED43953801 for ; Tue, 19 Apr 2005 00:10:40 -0300 (ADT) Received: from HMU.hmu.co.id (202.155.69.22) by kelud.indosat.net.id (7.2.033.1) id 422BCF1D0137093B for pgsql-sql@postgresql.org; Tue, 19 Apr 2005 10:09:06 +0700 Received: by hmu with Internet Mail Service (5.5.2653.19) id <2WV0C9S2>; Tue, 19 Apr 2005 10:13:52 +0700 Message-ID: <329EE23F2E3C9843B969AE66CDCB69C902C632@hmu> From: Art - Feping To: "'pgsql-sql@postgresql.org'" Subject: How to select from many database ?? Date: Tue, 19 Apr 2005 10:13:52 +0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.492 tagged_above=0 required=5 tests=DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200504/348 X-Sequence-Number: 21241 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....