Thread: SPI and Libpq

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

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