libpqxx查询postgresql数据库表的通用方法

//g++testpqxx.cpp-otestpqxx`pkg-config--libs--cflagslibpqxxlibpq`
//g++testpqxx.cpp-otestpqxx-I/opt/PostgreSQL/9.4/include/-L/opt/PostgreSQL/9.4/lib-lpqxx-lpq

#include<iostream>
#include<pqxx/pqxx>
usingnamespacepqxx;
usingnamespacestd;

intmain()
{
try
{
connectionconn("dbname=yout-dbuser=your-usrpassword=your-passwd
					hostaddr=127.0.0.1port=5432");
conn.set_client_encoding("UTF8");
	workw(conn);
resultr=w.exec("SELECT*FROMyour-table");

for(result::const_iteratorrow=r.begin();row!=r.end();++row)
{
for(tuple::const_iteratorcol=row->begin();col!=row->end();++col)
cout<<col->c_str()<<'t';
cout<<endl;
}

}
catch(exception&e)
{
cerr<<e.what()<<endl;
return1;
}
return0;
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!