Re: Post to another db using pl/pgsql - Mailing list pgsql-general

From tv@fuzzy.cz
Subject Re: Post to another db using pl/pgsql
Date
Msg-id 65047.89.102.139.23.1226509337.squirrel@sq.gransy.com
Whole thread Raw
In response to Post to another db using pl/pgsql  (Robert Fitzpatrick <lists@webtent.net>)
Responses Re: Post to another db using pl/pgsql
List 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


pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: sequence not restarting in a for loop (actually semi-random numbers)
Next
From: tv@fuzzy.cz
Date:
Subject: Re: Post to another db using pl/pgsql