Thread: getting dbname through SPI

Hi All,

Is it possible to get the dbname via SPI?  The situation is as that from
many trigger functions our package installs on tables with a db, an
external daemon is contacted with some information about particular
transactions that have taken place.  In the situation where multiple
(similarly configured) databases are simultaneously live it is imperative
that the database in which the trigger was fired is known (by name) so the
aforementioned daemon can deal with the incoming information properly.

Thanks in advance,

Greg

Hi Again,

After one of the guys working on this system poked around for a bit he
figured out that this piece of info was available in a global variable
called 'DatabaseName'.  Unfortunately this couldn't be found in any docs.

Cheers,

Greg

> Is it possible to get the dbname via SPI?  The situation is as that from
> many trigger functions our package installs on tables with a db, an
> external daemon is contacted with some information about particular
> transactions that have taken place.  In the situation where multiple
> (similarly configured) databases are simultaneously live it is imperative
> that the database in which the trigger was fired is known (by name) so the
> aforementioned daemon can deal with the incoming information properly.