Accessiing database from inside of postgresql C function
High!
I'm writing C postgresql module with postgresql functions and want to
access the tables from inside (SELECT mostly and maybe INSERT). Is it
possible? If yes what API can I use except classic TCP connection (not sure
if it's even legal)?
Kind Regards,
Yan
Yan Pas <yanp.bugz@gmail.com> writes:
I'm writing C postgresql module with postgresql functions and want to
access the tables from inside (SELECT mostly and maybe INSERT). Is it
possible? If yes what API can I use except classic TCP connection (not sure
if it's even legal)?
Recommended way is to use SPI:
https://www.postgresql.org/docs/current/static/spi.html
Aside from that documentation, there are lots of examples to study in the
core code and contrib.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general