On Thursday 20 March 2003 17:03, Reid Thompson wrote:
> I'd be appreciative if someone could give or point me to a working example
> of storing/retrieving images via bytea.
I don not understand the question, "bytea" is the data type that can hold any
binary data, so the "picture" is just a way to interpret that data.
If you are asking for sample how to read and write "bytea", there are
attached files from postgres sql driver for QT library. It is not the
original QT driver, because it does not know how to handle "bytea", and
"blobs", and have some serious errors in code, so I made my own plugin. From
the source you can see how "bytea" and "blobs" are read and written.
Based on this sql plugin I wrote set of database objects, and one of those
objects is "PgPicture".
PgPicture simply takes "QByteArray" from driver, does some work on it and
shows the picture on the screen.
For postgres version 7.3 it is working fine, but in previous releases
PQEscabeBytea had errors, and some pictures that I was using to test the
library could not be saved.