Postgres Pro
Downloads
Home   >   mailing lists

Re: Best Data type for Binary Data? - Mailing list pgsql-general

From Aaron Koning
Subject Re: Best Data type for Binary Data?
Date
Msg-id 1319fbba0601051408x1c85b206x9510c71ea1ccf8d3@mail.gmail.com
Whole thread Raw
In response to Best Data type for Binary Data?  (Ketema Harris <ketema@gmail.com>)
List pgsql-general
Tree view
BYTEA is the easiest from my point of view. I like being able to treat my binary data more like any other field (e.g. date, text, etc). Heres some light reading on the BLOB/BYTEA debate:
  http://search.postgresql.org/www.search?cs=utf-8&fm=on&st=20&dt=back&q=blob+bytea

Aaron

On 1/5/06, Ketema Harris <ketema@gmail.com> wrote:
Hi, I would like to store binary data from a tcpdump (libpcap) file in a table. What is the best type to use? i have read posts saying lo, oid, and bytea. Which one would be best for this scenario?

Thanks, ketema

pgsql-general by date:

Previous
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: 'Official' definition of ACID compliance?
Next
From: Jaime Casanova
Date:
Subject: Re: 'Official' definition of ACID compliance?