pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: JinNet Picker <netpicker9@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: 'dblink' Help
Date: Tue, 27 Jan 2004 02:53:26 -0800 (PST)
Message-ID: <20040127105326.97350.qmail@web9402.mail.yahoo.com> (raw)

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/



view thread (2+ messages)  latest in thread

Message-ID: <20040127105326.97350.qmail@web9402.mail.yahoo.com>
Permalink:  ../20040127105326.97350.qmail@web9402.mail.yahoo.com/
Also on:    postgresql.org/message-id/20040127105326.97350.qmail@web9402.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: netpicker9@yahoo.com
  Subject: Re: 'dblink' Help
  In-Reply-To: <20040127105326.97350.qmail@web9402.mail.yahoo.com>
  References: <20040127105326.97350.qmail@web9402.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox