#include<iostream>
#include<pqxx/pqxx>
#include<string>

using namespace std;
using namespace pqxx;

int main()
{
	string sql;

   	try{
		connection C("dbname=testdb user=postgres password=pqsswd \
		hostaddr=127.0.0.1 port=5432");
		if (C.is_open()) {
		 cout << "Opened database successfully: " << C.dbname() << endl;
		} else {
		 cout << "Can't open database" << endl;
		 return 1;
		}

		/* Create SQL statement */
		sql  = "SELECT * FROM USERTEST";
		/* Create a transactional object. */
		work W(C);

		/* Execute SQL query */
		pqxx::result r = W.exec( sql );
		W.commit();

		const int num_rows = r.size();
		for (int rownum=0; rownum < num_rows; ++rownum)
		{
  			const pqxx::tuple row = r[rownum];
  			const int num_cols = row.size();
  			for (int colnum=0; colnum < num_cols; ++colnum)
  			{
    			const pqxx::field field = row[colnum];
    			std::cout << field.c_str() << '\t';
  			}
  			std::cout << std::endl;
		}

        for (pqxx::result::const_iterator row = r.begin();row != r.end();++row)
        {
            for (pqxx::tuple::const_iterator field = row->begin();field != row->end();++field)
                 std::cout << field->c_str() << '\t';
           std::cout << std::endl;
        }

        cout << "table"<<endl;
        for (int rownum = 0 ; rownum < num_rows ; rownum++){
            cout << r[rownum]["UID"].c_str() << "  " << r[rownum]["TRUE_NAME"].c_str() << "  " << r[rownum]["GENDER"].c_str()
                 << "  "<< r[rownum]["NICK_NAME"].c_str() <<endl;
        }

        cout << "Table created successfully" << endl;
		C.disconnect ();
	}catch (const std::exception &e){
		cerr << e.what() << std::endl;
		return 1;
	}
}