pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
bytea
2+ messages / 2 participants
[nested] [flat]

* bytea
@ 2004-12-23 07:11 Nageshwar Rao <NageshwarR@PLANETASIA.COM>
  2004-12-23 08:15 ` Re: [GENERAL] bytea Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Nageshwar Rao @ 2004-12-23 07:11 UTC (permalink / raw)
  To: pgsql-admin; pgsql-general@postgresql.org

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [GENERAL] bytea
  2004-12-23 07:11 bytea Nageshwar Rao <NageshwarR@PLANETASIA.COM>
@ 2004-12-23 08:15 ` Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Fuhr @ 2004-12-23 08:15 UTC (permalink / raw)
  To: Nageshwar Rao <NageshwarR@PLANETASIA.COM>; +Cc: pgsql-admin; pgsql-general@postgresql.org

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/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-12-23 08:15 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-23 07:11 bytea Nageshwar Rao <NageshwarR@PLANETASIA.COM>
2004-12-23 08:15 ` Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox