I've worked through that already, without any success.
This is what I have until now to insert data

    char *query = "insert into table1 (bytes) values ($1)";
    QByteArray chip = <assignment of bytes>;
    const char *data = chip->data();
    const char* params[]={data};
    const int params_length[]={chip->length()};
    const int params_format[]={1};
result = PQexecParams(mDatabase, query, 1, in_oid, params, params_length, params_format, 0);

The first problem I have is that I'm not sure if const int params_length[]={chip->length()}; is the correct way to provide the length. Second of all, is this actually the correct way of doing it, isn't there a beter way?

Christoph




On 2010/09/30 05:30 PM, Vincenzo Romano wrote:
2010/9/30 GOO Creations<goocreati...@gmail.com>:
  Hi there,

I'm sitting for days now, and I can't get this to work:

I want to insert binary data (bytea) into my postgres DB via the c++ libpq.

What I have is a char* (actually a QByteArray) and I want to insert it into
the DB and the retrieve it from there again.

I can't find any good examples or tutorials online, so can anyone help me
(or direct met to a tutorial) on how to insert binary data and retrieve it
again?

Thank you very much
Christoph
Try chapter  31.3.4 from the v9 documentation.
http://www.postgresql.org/docs/9.0/static/libpq-exec.html#LIBPQ-EXEC-ESCAPE-STRING



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to