Message-ID: <3F093CE3.BE88DC98@rodos.fzk.de>
Date: Mon, 07 Jul 2003 11:27:00 +0200
From: Christoph Haller <ch@rodos.fzk.de>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org,
	Simeon.Mariasoosai@StartelCorp.com
Subject: Re: Need help on bytea usage
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit

Simon,
My reply is pretty late, maybe you've already find out on your own.
Here is what I can show you

...
struct measurestation {
 int Id ;
 char Name[NAMELEN] ;
 char ProviderName[NAMELEN] ;
 char ProviderTime[15] ;
 float Longitude ;
 float Latitude ;
 int Height ;
 int nValue ;
 float Value ;
 int MeasureHght ;
 struct measurestation* next ;
} ;
typedef struct measurestation MeasureValues ;
...
    char CmdLine[1024];
    PGconn     *conn;
    PGresult   *res;

    MeasureValues mval ;
    char ByteaString[1024];
    size_t binarylen;

    /* insert a C struct as bytea type */
    memset ( &mval , 0 , sizeof(MeasureValues) ) ;
    strcpy ( mval.Name , "stat-name" ) ;
    strcpy ( mval.ProviderName , "prov-name" ) ;

/*
keep in mind libpq is not thread-safe,
so what I use as buffer 'ByteaString' should be 4 times the
sizeof(MeasureValues)
to be on the safe side (all non-printables bytes become four byte octets
\nnn)
*/
    strcpy ( ByteaString , (const char *)
                           PQescapeBytea((unsigned char *) &mval ,
                                         sizeof(MeasureValues),
&binarylen));
    sprintf(CmdLine, "INSERT INTO bytea_tab ( bytea_col ) VALUES
('%s');",
                       ByteaString);
    res = PQexec(conn, CmdLine);
    if (!res || PQresultStatus(res) != PGRES_COMMAND_OK)
    {
        fprintf(stderr, "INSERT command failed\n");
        PQclear(res);
        exit_nicely(conn);
    }

This works for me.
Regards, Christoph