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 2D759563AF for ; Thu, 5 May 2005 06:09:42 -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 20001-04 for ; Thu, 5 May 2005 09:09:36 +0000 (GMT) Received: from smp.orenda.com.my (unknown [202.71.97.159]) by svr1.postgresql.org (Postfix) with ESMTP id F0FCC5639F for ; Thu, 5 May 2005 06:09:34 -0300 (ADT) Received: from smp.orenda.com.my ([202.71.97.159]) by smp.orenda.com.my (8.12.11/8.12.11) with SMTP id j4599Ml4023684; Thu, 5 May 2005 17:09:23 +0800 (MYT) (envelope-from izwan@orenda.com.my) Message-Id: <200505050909.j4599Ml4023684@smp.orenda.com.my> Date: Thu, 05 May 2005 17:09:22 +0800 From: "mohammad izwan ibrahim" To: "Richard Huxton" , "mohammad izwan ibrahim" Cc: Subject: Re: accessing multiple database Content-type: text/plain; charset=iso-8859-1 X-Mailer: ORENDA Mail Versi 2.0.2 (http://mail.orenda.com.my/) X-AntiVirus: checked by Vexira Milter 1.0.7; VAE 6.30.0.2; VDF 6.30.0.32 X-Scanned-By: MIMEDefang 2.35 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/45 X-Sequence-Number: 21358 Hi Richard Huxton, Tq for your advice, Hope you can help me on this 1.can I create view from dblink query 2.can I fetch the data simultaneous from multiple database using dblink function, how the syntax would be? tq -- Original message -- From: "Richard Huxton" To: "mohammad izwan ibrahim" Date: Thursday 5 May 2005 15:06:24 Subject: Re: [SQL] accessing multiple database > mohammad izwan ibrahim wrote: > > hi all, > > > > im finding some ideas, method, advice, n etc on accessing multiple > > database.The system that i'm currently develop is real time update > > and the data reside on few different db at different db site. Tq in > > advance. > > Obviously you can access more than one database from your client > software. From within PostgreSQL itself, look into the dblink package in > the contrib/ directory of the source distribution. > > -- > Richard Huxton > Archonet Ltd >