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 D426E5280D for ; Mon, 20 Jun 2005 00:11:48 -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 96966-02 for ; Mon, 20 Jun 2005 03:11:39 +0000 (GMT) Received: from smp.orenda.com.my (unknown [202.71.97.159]) by svr1.postgresql.org (Postfix) with ESMTP id 742B552814 for ; Mon, 20 Jun 2005 00:11:33 -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 j5K3BN7r030310 for ; Mon, 20 Jun 2005 11:11:25 +0800 (MYT) (envelope-from izwan@orenda.com.my) Message-Id: <200506200311.j5K3BN7r030310@smp.orenda.com.my> Date: Mon, 20 Jun 2005 11:11:23 +0800 From: "mohammad izwan ibrahim" To: Subject: accessing database without a persistent connection 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: 200506/242 X-Sequence-Number: 21843 Hi there, I need help on accessing few database without having a persistent connection. So far accessing via dblink still require persistent database connecttion. Is it possible to be done by postgress..and how to acheive that tq