Re: Post to another db using pl/pgsql

From: tv(at)fuzzy(dot)cz
To: robert(at)webtent(dot)com
Cc: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Post to another db using pl/pgsql
Date: 2008-11-12 17:04:38
Message-ID: 65083.89.102.139.23.1226509478.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Naomi Walker 2008-11-12 17:06:01 Upgrade in Place
Previous Message tv 2008-11-12 17:02:17 Re: Post to another db using pl/pgsql