Обсуждение: Help with C-Function on Postgre
Hi to all,
I'm new on this list and also on using postgre.
I wanted to write some C-Function but, also if I read all the documentation about it on the Manuals directory on the postgre web page, i still have some problems.
I already made some simple works just to try how was working and all went fine.
Now I need to make some basic operations inside the database, for example create new tables, temp tables, delete them insert some new information inside existent tables, and something like this.
The problem is that i didn't find nothing about it. I found only some information about this things on the doxygen section of the postgre website but is really difficult for me (http://doxygen.postgresql.org/) [I went in the directory include/server and I took a look around there but without understand a lot].
I hope you can help me!
Thank you in advance,
Angelo.
Scegli fra più di 30 stazioni! Ascolta la radio su Messenger
I'm new on this list and also on using postgre.
I wanted to write some C-Function but, also if I read all the documentation about it on the Manuals directory on the postgre web page, i still have some problems.
I already made some simple works just to try how was working and all went fine.
Now I need to make some basic operations inside the database, for example create new tables, temp tables, delete them insert some new information inside existent tables, and something like this.
The problem is that i didn't find nothing about it. I found only some information about this things on the doxygen section of the postgre website but is really difficult for me (http://doxygen.postgresql.org/) [I went in the directory include/server and I took a look around there but without understand a lot].
I hope you can help me!
Thank you in advance,
Angelo.
Scegli fra più di 30 stazioni! Ascolta la radio su Messenger
On Thu, Apr 02, 2009 at 12:52:40PM +0200, Angelo Nicolosi wrote: > I wanted to write some C-Function Where is this code going to live? if it's going to be "inside" PG as a function you can call from SQL you want something called SPI: http://www.postgresql.org/docs/current/static/spi.html If it's going to be "outside" PG and connect to the database to do its work you want to use the client libraries: http://www.postgresql.org/docs/current/static/libpq.html Hope that helps! -- Sam http://samason.me.uk/