PostgreSQL: libpq - C 库

http://www.php100.com/manual/PostgreSQL8/libpq.html

char conninfo[2000] = ""; //DB connection config

strcpy(conninfo, "dbname=");

strcat(conninfo, DB_NAME);

strcat(conninfo, " ");

strcat(conninfo, "user=");

strcat(conninfo, DB_USER);

strcat(conninfo, " ");

strcat(conninfo, "host=");

strcat(conninfo, DB_HOST);

strcat(conninfo, " ");

strcat(conninfo, "port=");

strcat(conninfo, DB_PORT);

PGconn* conn =PQconnectdb(conninfo);

if (PQstatus(conn) == CONNECTION_BAD){PQfinish(conn);}

http://www.php100.com/manual/PostgreSQL8/libpq-async.html

sprintf(temp_local, "select count(*) from %s;", TABLE_NAME[i]);

res = PQexec(conn, temp_local);

res = PQexec(conn, "BEGIN;");

PQclear(res); --- 释放每个结果对象