Обсуждение: Post to another db using pl/pgsql
I've worked with pgsql for a while, but never needed to post from a database trigger to another db. Is this possible? And if so, can someone offer a pointer to the docs on how to refer to other db's in my script, etc? -- Robert
> I've worked with pgsql for a while, but never needed to post from a > database trigger to another db. Is this possible? And if so, can someone > offer a pointer to the docs on how to refer to other db's in my script, > etc? What do you mean by 'other db'? Does that mean other PostgreSQL database, or a completely different db (say MySQL for example)? There is a dblink contrib package - I've never worked with it, but I guess you can use it to post to a different PostgreSQL db. AFAIK posting to a MySQL from pl/pgsql is not possible, but you can use pl/perl with proper packages for example. regards Tomas
> I've worked with pgsql for a while, but never needed to post from a > database trigger to another db. Is this possible? And if so, can someone > offer a pointer to the docs on how to refer to other db's in my script, > etc? What do you mean by 'other db'? Does that mean other PostgreSQL database, or a completely different db (say MySQL for example)? There is a dblink contrib package - I've never worked with it, but I guess you can use it to post to a different PostgreSQL db. AFAIK posting to a MySQL from pl/pgsql is not possible, but you can use pl/perl with proper packages for example. regards Tomas
On Wed, 2008-11-12 at 18:02 +0100, tv@fuzzy.cz wrote: > > I've worked with pgsql for a while, but never needed to post from a > > database trigger to another db. Is this possible? And if so, can someone > > offer a pointer to the docs on how to refer to other db's in my script, > > etc? > > What do you mean by 'other db'? Does that mean other PostgreSQL database, > or a completely different db (say MySQL for example)? Sorry, yes, I'm wanting to post to another pgsql db on the same server. -- Robert
On Nov 12, 2008, at 8:55 AM, Robert Fitzpatrick wrote: > I've worked with pgsql for a while, but never needed to post from a > database trigger to another db. Is this possible? And if so, can > someone > offer a pointer to the docs on how to refer to other db's in my > script, > etc? Look for dblink (if it's another postgresql database) or dbilink (if it isn't). dblink is documented in one of the appendices of the postgresql manual. Cheers, Steve