#include <iostream.h>
#include <libpq++.h>

int main()
{
	PgDatabase db("dbname=foo user=foo password=bar");
	if ( db.ConnectionBad() ) {
		cerr << "Cannot connect: " << db.ErrorMessage() << endl;
		exit(1);
	}
	
	string cmd("CREATE TABLE hello (message VARCHAR(50))");
	if (!db.ExecTuplesOk(cmd.c_str())) {
		cerr << "CREATE TABLE failed." << endl;
		exit(1);
	}
	cmd = "INSERT INTO hello VALUES('Hello World!')";
	if (!db.ExecTuplesOk(cmd.c_str())) {
		cerr << "INSERT failed." << endl;
		exit(1);
	}

	cmd = "SELECT * FROM hello";
	if (!db.ExecTuplesOk(cmd.c_str())) {
		cerr << "T failed." << endl;
		exit(1);
	}

	// assert(db.Tuples() == 1);
	
	for (int i=0; i < db.Tuples(); i++)
		cout << db.GetValue(i,0) << endl;

	return 0;
}