Invoke PostgreSQL Stored Procedure using C

Question

I am referring to http://www.postgresql.org/docs/8.1/static/libpq.html

I try to find an example of C/C++ to call PostgreSQL stored procedure. However, I cannot find one. Can anyone point me the right direction?

Remember that the PostGreSQL server is often a remote one... — Basile Starynkevitch
– Basile Starynkevitch, Commented Nov 10, 2017 at 9:12

Magnus Hagander · Accepted Answer · 2010-01-04 11:36:59Z

4

As as previously been answered, the easiest way is to use SELECT myStoredProcedure(1,2,3). You can also use the fast-path call interface to call a function directly. See http://www.postgresql.org/docs/current/static/libpq-fastpath.html for reference. But note that if you are working on modern versions of PostgreSQL, you're likely better off using the regular interface and a prepared statement.

answered Jan 4, 2010 at 11:36

Magnus Hagander

25.5k6 gold badges60 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sth · Accepted Answer · 2010-01-04 10:26:29Z

1

You just need to execute a SQL statement like this one:

SELECT myStoredProcedure(1,2,3);

This can for example be done using PQexec(), just like with any other SQL statement. An example program that sends SQL statements to a database can be found in section 28.17. of the documentation

answered Jan 4, 2010 at 10:26

sth

231k56 gold badges288 silver badges370 bronze badges

Collectives™ on Stack Overflow

Invoke PostgreSQL Stored Procedure using C

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related