Skip site navigation (1) Skip section navigation (2)

'dblink' Help

From: JinNet Picker <netpicker9(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: 'dblink' Help
Date: 2004-01-27 10:53:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

I have Two databases names 'MyDb1' and 'MyDb2' in My

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?


Some Sample Query Using "dblink" is:
select * from dblink('hostaddr=
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!


pgsql-admin by date

Next:From: Gaetano MendolaDate: 2004-01-27 19:06:42
Subject: Postgres 7.3.5
Previous:From: IainDate: 2004-01-27 04:32:51
Subject: Re: Can I change the character encoding for a DB?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group