pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: joo <joo@sebasasia.com>
To: pgsql-sql@postgresql.org
Subject: Re: join question - requesting for a simple C program where it can INSERT data into database as reference
Date: Fri, 14 Jun 2002 10:03:58 +0800
Message-ID: <001801c21347$bfd22020$320a0a0a@joo> (raw)
References: <20020613081443.A4208-100000@megazone23.bigpanda.com>

My problem is, i am writing a simple retrieval program using C, to retrieve
a set of records from database. Then i'll make certain calculation based on
the data that i have retrieved and write it on a new database. I have follow
the sample program  to do the retrieval and it works. But i don't seems to
have any samples to do an INSERT to the database? please anyone who have
such simple or working programs where it can INSERT to any database , please
reply to me as a reference.


here is the sample program that i used to do my retrieval:


#include <stdio.h>
#include "libpq-fe.h"

void
exit_nicely(PGconn *conn)
{
    PQfinish(conn);
    exit(1);
}

main()
{
    char       *pghost,
               *pgport,
               *pgoptions,
               *pgtty;
    char       *dbName;
    int         nFields;
    int         i,
                j;



    PGconn     *conn;
    PGresult   *res;

    pghost = NULL;
    pgport = NULL;
    pgoptions = NULL;

    pgtty = NULL;
    dbName = "template1";


    conn = PQsetdb(pghost, pgport, pgoptions, pgtty, dbName);


    if (PQstatus(conn) == CONNECTION_BAD)
    {
        fprintf(stderr, "Connection to database '%s' failed.\n", dbName);
        fprintf(stderr, "%s", PQerrorMessage(conn));
        exit_nicely(conn);
    }


    res = PQexec(conn, "BEGIN");
    if (!res || PQresultStatus(res) != PGRES_COMMAND_OK)

    {
        fprintf(stderr, "BEGIN command failed\n");
        PQclear(res);
        exit_nicely(conn);
    }


    PQclear(res);


    res = PQexec(conn, "DECLARE mycursor CURSOR FOR select * from event");
    if (!res || PQresultStatus(res) != PGRES_COMMAND_OK)
    {
        fprintf(stderr, "DECLARE CURSOR command failed\n");
        PQclear(res);
        exit_nicely(conn);
    }
    PQclear(res);
    res = PQexec(conn, "FETCH ALL in mycursor");
    if (!res || PQresultStatus(res) != PGRES_TUPLES_OK)
    {
        fprintf(stderr, "FETCH ALL command didn't return tuples
properly\n");
        PQclear(res);
        exit_nicely(conn);
    }


    nFields = PQnfields(res);
    for (i = 0; i < nFields; i++)
        printf("%-15s", PQfname(res, i));
    printf("\n\n");


    for (i = 0; i < PQntuples(res); i++)
    {
        for (j = 0; j < nFields; j++)
            printf("%-15s", PQgetvalue(res, i, j));
        printf("\n");
    }
    PQclear(res);


    res = PQexec(conn, "CLOSE mycursor");
    PQclear(res);

    res = PQexec(conn, "COMMIT");
    PQclear(res);


    PQfinish(conn);

    return 0;

}
Thanks,
joo

view thread (2+ messages)

Message-ID: <001801c21347$bfd22020$320a0a0a@joo>
Permalink:  ../001801c21347$bfd22020$320a0a0a@joo/
Also on:    postgresql.org/message-id/001801c21347$bfd22020$320a0a0a@joo

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: joo@sebasasia.com
  Subject: Re: join question - requesting for a simple C program where it can INSERT data into database as reference
  In-Reply-To: <001801c21347$bfd22020$320a0a0a@joo>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox