On Wednesday, March 30, 2016, Francisco Reyes <li...@natserv.net> wrote:
> Is it possible to have a plpsql program connect to 2 databases? > > This seems to imply it, > http://stackoverflow.com/questions/18257003/pl-sql-querying-a-table-on-multiple-databases > > However looking at the postgresql plpsql reference, > http://www.postgresql.org/docs/current/static/plpgsql-cursors.html#PLPGSQL-CURSOR-OPENING, > doesn't seem like there is a way to specify database. Is the stackoverflow > for plpsql in some other database (not postgresql)? > > Any pointers greatly appreciated. > > Have users that are familiar with plpsql and have a process which needs to > be done withing transactions in 2 databases. > begin in db1 > begin in db2 > > work on 1 > work on 2 > > if work on both dbs worked > > commit db1 > commit db2 > > Do they need to use some other language (Java/Python)? How about a foreign > data wrapper? > > It's plpgsql, potentially with a slash, pl/pgsql. You would have to use foreign data wrappers or dblink if you want a function to speak to a database other than the one it's calling session is attached to. Your SO link references Oracle's language. It is called pl/SQL there. Neither one has "plpsql". David J.
