Extracting data from BYTEA column to binary file using libpq
От | Julia Jacobson |
---|---|
Тема | Extracting data from BYTEA column to binary file using libpq |
Дата | |
Msg-id | 4C8FF0AE.5040506@arcor.de обсуждение исходный текст |
Ответы |
Re: Extracting data from BYTEA column to binary file
using libpq
Re: Extracting data from BYTEA column to binary file using libpq |
Список | pgsql-general |
Hello everybody out there using PostgreSQL, What is the problem with the following C++ code for the extraction of data from a BYTEA column to a binary file? #include <stdlib.h> #include <stdio.h> #include <iostream> #include <fstream> #include "libpq-fe.h" using namespace std; main () { PGconn *conn; conn = PQconnectdb("hostaddr='databaseserver.com' port='5432' dbname='test_db' user='test_user' password='secret'"); int size; const char* contents; PGresult* res; res = PQexecParams(conn, "SELECT filecontent FROM pictures WHERE picture_id='3'", 0, NULL,NULL,NULL,NULL, 1); if (res && PQresultStatus(res)==PGRES_TUPLES_OK) { size = PQgetlength(res, 0, 0); contents = PQgetvalue(res, 0, 0); } ofstream myFile ("picture.jpg", ios::out | ios::binary); myFile.write (contents); myFile.close(); } Thanks in advance, Julia
В списке pgsql-general по дате отправления: