| From: | JinNet Picker <netpicker9(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Postgres "dblink" Help |
| Date: | 2004-01-27 10:50:30 |
| Message-ID: | 20040127105030.97126.qmail@web9402.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cavit Keskin | 2004-01-27 11:36:29 | PgSQL Down |
| Previous Message | Tomasz Myrta | 2004-01-27 09:56:49 | Re: time series data |