bytea

Started by Nageshwar Raoover 21 years ago2 messagesgeneral
Jump to latest
#1Nageshwar Rao
NageshwarR@PLANETASIA.COM

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

#2Michael Fuhr
mike@fuhr.org
In reply to: Nageshwar Rao (#1)
Re: [GENERAL] bytea

On Thu, Dec 23, 2004 at 12:41:29PM +0530, Nageshwar Rao wrote:

How to the insert into bytea data type column?

See the "Binary Data Types" section of the "Data Types" chapter in
the PostgreSQL documentation -- it shows the format for BYTEA data.

Your interface to PostgreSQL might have a function to convert data
to the necessary format. How are you communicating with the database?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/