Re: Best Data type for Binary Data?

[Aaron Koning <aaronkoning@xxxxxxxxx>]

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@xxxxxxxxx> 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