SPI - Server Programming Interface is for coding C functions in the
backend. Thus triggers can reference functions created using SPI..
Libpq is a front-end (or client side) API.
Anand Surelia wrote:
> Hi,
> Can anyone tell me what is the difference between the SPI and the Libpq
> interfaces and when to use what?
> I am writing some functions that will be used by triggers. What
> interface should I use to implement those functions?
> Thanks,
> Anand