I'm writting a function/extention in C for a trigger. Inside a
trigger, in C, I want to get the name of the current database.
However, not via SPI_exec(), SPI_prepare() and the like, but more
directly, in a more faster way.
I'm aware of "current_database()" but it'll require calling it via SPI_exec()
I've found this code which is implementation of 'conninfo' command:
but it's still unclear how to do the same thing from a C function inside for a trigger.
How to do it?
P.S.
While SPI_exec(), SPI_prepare() won't work for me, other SPI functions such SPI_get* will be ok.
Versions: 11 or 12
For the versions 11 or 12