Thread: execute query from inside C function
I've googled the docs but I can't seem to make a link as to how to execute database queries from inside a C function. I'mused to having a PGconn and using the API around that, but how do I do that from inside a C function (and a bit lateron, a language handler?) Thanks James
Hello
you should to use a SPI API http://www.postgresql.org/docs/9.3/static/spi.html
http://www.postgresql.org/docs/9.3/static/spi-spi-exec.html
Pavel Stehule
2014-02-25 13:22 GMT+01:00 James Harper <james.harper@bendigoit.com.au>:
I've googled the docs but I can't seem to make a link as to how to execute database queries from inside a C function. I'm used to having a PGconn and using the API around that, but how do I do that from inside a C function (and a bit later on, a language handler?)
Thanks
James
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> Hello > > you should to use a SPI API > > http://www.postgresql.org/docs/9.3/static/spi.html > > http://www.postgresql.org/docs/9.3/static/spi-spi-exec.html > Yep just found it. I obviously didn't google hard enough. Thanks James
2014-02-25 13:36 GMT+01:00 James Harper <james.harper@bendigoit.com.au>:
> HelloYep just found it. I obviously didn't google hard enough.
>
> you should to use a SPI API
>
> http://www.postgresql.org/docs/9.3/static/spi.html
>
> http://www.postgresql.org/docs/9.3/static/spi-spi-exec.html
>
It is not on front
Regards
Pavel
Pavel
Thanks
James