Обсуждение: execute query from inside C function

Поиск
Список
Период
Сортировка

execute query from inside C function

От
James Harper
Дата:
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


Re: execute query from inside C function

От
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

Re: execute query from inside C function

От
James Harper
Дата:
> 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

Re: execute query from inside C function

От
Pavel Stehule
Дата:



2014-02-25 13:36 GMT+01:00 James Harper <james.harper@bendigoit.com.au>:
Yep just found it. I obviously didn't google hard enough.

It is not on front

Regards

Pavel
 

Thanks

James