Connection to Postgres Database using libpqxx
class databaseConnection
{
public:
    pqxx::connection* conn;
    void SetConnection(){
        conn=new pqxx::connection("username=temp host=db.corral.tacc.utexas.edu password=timelione dbname=temp");

    }

    void Disconnect(){
        conn->disconnect();
    }

    pqxx::result querry(std::string strSQL){
        //SetConnection();
        pqxx::work trans(*conn,"trans");

        pqxx::result res=trans.exec(strSQL);

        trans.commit();
        return res;
    }
};

int main()
{
    databaseConnection* pdatabase;
    pdatabase->SetConnection();
    return 0;
}

databaseConnection database;
database.SetConnection();

databaseConnection* pdatabase = new databaseConnection();
pdatabase->SetConnection();