if(PQstatus(conn) == CONNECTION_BAD) { puts("We were unable to connect to the database"); exit(0); }
res = PQexec(conn,"INSERT INTO people VALUES (5, 'XXX', 'YYY', '7633839276');"); if(PQresultStatus(res) != PGRES_COMMAND_OK) { fprintf(stderr, "Insertion Failed: %s", PQerrorMessage(conn)); PQclear(res); } else printf("Successfully inserted value in Table..... \n");
res = PQexec(conn, "update people set phonenumber=\'5055559999\' where id=3"); res = PQexec(conn, "ALTER TABLE people ADD comment VARCHAR(100);"); res = PQexec(conn, "UPDATE people SET comment = 'TRUE';");
res = PQexec(conn,"select lastname,firstname,phonenumber from people order by id"); rec_count = PQntuples(res);
if(PQresultStatus(res) != PGRES_TUPLES_OK) { puts("We did not get any data!"); exit(0); }
printf("We received %d records.\n", rec_count); puts("==========================");