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<goocreations@xxxxxxxxx>:
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
