X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B902AD1D54D for ; Tue, 27 Jan 2004 10:53:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 93799-03 for ; Tue, 27 Jan 2004 06:53:28 -0400 (AST) Received: from web9402.mail.yahoo.com (web9402.mail.yahoo.com [216.136.129.108]) by svr1.postgresql.org (Postfix) with SMTP id 23D63D1D8DA for ; Tue, 27 Jan 2004 06:53:24 -0400 (AST) Message-ID: <20040127105326.97350.qmail@web9402.mail.yahoo.com> Received: from [202.157.201.66] by web9402.mail.yahoo.com via HTTP; Tue, 27 Jan 2004 02:53:26 PST Date: Tue, 27 Jan 2004 02:53:26 -0800 (PST) From: JinNet Picker Subject: 'dblink' Help To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/275 X-Sequence-Number: 12138 Hi, I have Two databases names 'MyDb1' and 'MyDb2' in My System. I have installed Postgres 7.4 with dblink What i need is, when ever a NEW record is inserted in 'MyDb1' , i want fire a Trigger or Rule to insert the Same Record to MyDb2 database. I am Using MAC OS 10.2 Anybody Got Idea how to do this? Thanks ---------------------------------------------- Some Sample Query Using "dblink" is: select * from dblink('hostaddr=192.168.1.1 dbname=MyDb1 user=pgsql','select username,password,usertype from users') as t1(username varchar,password varchar,usertype varchar); ---------------------------------------------- __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/