psql large object and pixmap

[mkarakaplan]

I need and example for getting jpg file which stored as large object in postgresql and setting as pixmap.

Normally i write to a file and set pixmap. Is it possible on the fly?

[Methedrine]

You can pass a byte array to QPixmap, as such you must not load an image from file in order to use it.

[mkarakaplan]

QPixmap image;
QSqlQuery query;
PGresult* res = PQexec(conn, "begin");
Oid objID = query.value(0).toInt();
int descriptor = lo_open(conn, objID, INV_READ);

Now my problem is conn parameter. What must i use?
I connected to database like this.

QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
db.setHostName(HOST);
db.setDatabaseName(DBNAME);
db.setUserName(USER);
db.setPassword(PASSWORD);