X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F0C773AA08D; Thu, 23 Dec 2004 07:09:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96380-05; Thu, 23 Dec 2004 07:08:53 +0000 (GMT) Received: from mlsw00103.PLANETASIA.com (unknown [203.200.29.10]) by svr1.postgresql.org (Postfix) with ESMTP id 2F40A3ABF27; Thu, 23 Dec 2004 07:08:50 +0000 (GMT) Received: by MLSW00103 with Internet Mail Service (5.5.2657.72) id ; Thu, 23 Dec 2004 12:41:30 +0530 Message-ID: <5F4ED4205E00D6119BFE009027DE39090793EFDA@MLSW00103> From: Nageshwar Rao To: "'pgsql-admin@postgresql.org'" , pgsql-general@postgresql.org Subject: bytea Date: Thu, 23 Dec 2004 12:41:29 +0530 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4E8BE.9FDD0970" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.617 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/226 X-Sequence-Number: 15812 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C4E8BE.9FDD0970 Content-Type: text/plain We have column job_data with datatype bytea. This is one of the columns in table used by quartz scheduler(open source). We have to insert the data into it. The data is as follows. [-84,-19,0,5,115,114,0,21,111,114,103,46,113,117,97,114,116,122,46,74,111,98 ,68,97,116,97,77,97,112] How to the insert into bytea data type column? Thx ------_=_NextPart_001_01C4E8BE.9FDD0970 Content-Type: text/html Content-Transfer-Encoding: quoted-printable bytea

We have column = job_data  with datatype bytea. This is one of the columns in = table used by quartz scheduler(open source). We have to insert = the data into it.

The data is as = follows.

[-84,-19,0,5,115,114,0,21,111,114,103,46,113,117,97,114,1= 16,122,46,74,111,98,68,97,116,97,77,97,112]

How to the insert into bytea data type column?

Thx



------_=_NextPart_001_01C4E8BE.9FDD0970--