Postgres Pro
Downloads
Home   >   mailing lists

Thread: bytea

bytea

From
Nageshwar Rao
Date:

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

Re: bytea

From
Michael Fuhr
Date:
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/