Received: from joeconway.com (unknown [63.210.180.150]) by postgresql.org (Postfix) with ESMTP id B8099474E4B for ; Sat, 23 Mar 2002 18:26:48 -0500 (EST) Received: from [192.168.5.2] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 3.5.6) with ESMTP-TLS id 300388; Sat, 23 Mar 2002 15:22:03 -0800 Message-ID: <3C9D0F4A.5050101@joeconway.com> Date: Sat, 23 Mar 2002 15:27:06 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.9) Gecko/20020311 X-Accept-Language: en-us, en MIME-Version: 1.0 To: =?ISO-8859-2?Q?Ikl=F3di_Lajos?= Cc: "pgsql-sql@postgresql.org" Subject: Re: Binary data in bytea field References: <3C9CC6CE.B269A510@mithrandir.hu> <3C9CCE10.3090703@joeconway.com> <3C9D0D3F.68EF7CD@mithrandir.hu> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Archive-Number: 200203/297 X-Sequence-Number: 7176 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