X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 04C13D1B447 for ; Tue, 27 Jan 2004 10:51:02 +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 90971-08 for ; Tue, 27 Jan 2004 06:50:32 -0400 (AST) Received: from web9402.mail.yahoo.com (web9402.mail.yahoo.com [216.136.129.108]) by svr1.postgresql.org (Postfix) with SMTP id BDB8FD1DAD0 for ; Tue, 27 Jan 2004 06:50:29 -0400 (AST) Message-ID: <20040127105030.97126.qmail@web9402.mail.yahoo.com> Received: from [202.157.201.66] by web9402.mail.yahoo.com via HTTP; Tue, 27 Jan 2004 02:50:30 PST Date: Tue, 27 Jan 2004 02:50:30 -0800 (PST) From: JinNet Picker Subject: Postgres "dblink" Help To: pgsql-sql@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: 200402/5 X-Sequence-Number: 16696 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/