Re: unable to insert column using postgresql and C

Hello,

I didn't test it, but try:

#include <stdio.h>
#include <stdlib.h>
#include <libpq-fe.h>
#include <string.h>

int main()
{
    PGconn *conn;
    PGresult *res;
    int rec_count;
    int row;
    int col;

    conn = PQconnectdb("dbname=test host=localhost user=abc password=xyz");

    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("==========================");

    for(row=0; row<rec_count; row++) {
        for(col=0; col<3; col++) {
            printf("%s\t", PQgetvalue(res, row, col));
        }
        puts("");
    }

    puts("==========================");

    PQclear(res);

    PQfinish(conn);

    return 0;
}



--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello