956
社区成员
发帖
与我相关
我的任务
分享
PGresult *res = NULL;
char szCopyCommand[4096];
sprintf_s(szCopyCommand, "COPY %s(%s) FROM STDIN DELIMITER ',';", strTableName.c_str(), strColumns.c_str());
res = PQexec(m_pPGConn, szCopyCommand);
ExecStatusType eStatus = PQresultStatus(res);
PQclear(res);
if (eStatus != PGRES_COPY_IN)
{
return false;
}
if (1 != PQputCopyData(m_pPGConn, strData.c_str(), strlen(strData.c_str())))
{
return false;
}
PGresult *pResult = PQgetResult(m_pPGConn);
PQclear(pResult);
if (PQputCopyEnd(m_pPGConn, NULL) != 1)
{
return false;
}
pResult = PQgetResult(m_pPGConn);
PQclear(pResult);
return true;