SPI and Libpq

Started by Anand Sureliaover 27 years ago2 messagesgeneral
Jump to latest
#1Anand Surelia
anand@bytekinc.com

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

#2David Hartwig
daveh@insightdist.com
In reply to: Anand Surelia (#1)
Re: [GENERAL] SPI and Libpq

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:

Show quoted text

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