> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
