| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Iklódi Lajos <il(at)mithrandir(dot)hu> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Binary data in bytea field |
| Date: | 2002-03-23 23:27:06 |
| Message-ID: | 3C9D0F4A.5050101@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Iklódi Lajos wrote:
>>Iklódi Lajos wrote:
>>
>>>I have a table with field of tyte bytea. I'm reading this table with C,
>>>libpq.
>>>The result is a string, with octal groups, like '\200'.
>>>Is it possible to get data as it is, every byte in one byte?
>>>Thanks
>>>
>>
>>Sure -- just use a binary cursor.
>>
>>HTH,
>>
>>Joe
>
>
> Thanks, really it is in docs.
> How can I make binary updates?
>
> Lajos
>
See:
http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/libpq-exec.html
section 1.3.3 "Escaping binary strings for inclusion in SQL queries".
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jack | 2002-03-25 03:37:35 | About temporary table |
| Previous Message | Iklódi Lajos | 2002-03-23 23:18:23 | Re: Binary data in bytea field |