libpq, insert with parameters

Question

I am wondering if I can make parameterized queries directly from C/C++ with libpq instead of using strings and if do how should this code look's like?

string tblins = "";
tblins = "INSERT INTO " + commtable + " "
         "(vdoc, bdoc, mytime, txml) VALUES ("
         "'" + cxml.vdoc + "', "
             + cxml.bdoc + ", " //integer
         "'" + cxml.mytime + "', "
         "'" + cxml.txml + "')";

result = PQexec(conn, tblins.c_str());

Thanks.

Greg Hewgill · Accepted Answer · 2013-06-04 01:24:33Z

4

Yes, you can use the PQexecParams function as explained in the documentation.

If parameters are used, they are referred to in the command string as $1, $2, etc. nParams is the number of parameters supplied; it is the length of the arrays paramTypes[], paramValues[], paramLengths[], and paramFormats[].

answered Jun 4, 2013 at 1:24

Greg Hewgill

1.0m192 gold badges1.2k silver badges1.3k bronze badges

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

1 Comment

user3791372 Over a year ago

it's also recommended you typecast parameters, so $1::integer, $2::varchar etc, so you can pass NULL for the paramTypes arg

Collectives™ on Stack Overflow

libpq, insert with parameters

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related