Re: [Pypgsql-users] Binary data with postgress

[Billy G. A. <Bil...@mu...>]

"Mignon, Laurent" wrote:
> 
> How can I do to store binary data like program file, picture, document, etc
> in postgress?
> 
> Thanks for your help.
> 
>  
> 
> lmg

You have a couple of choices:

1.  Use a PostgreSQL large object.

2.  Use a bytea field.

With later versions of PostgreSQL, it a matter of personal preference as to
which one you use.  Earlier version had an approximately 8K limit to the
tuple size, so large objects were were needed for data with a size > 8K.
___________________________________________________________________________
____       | Billy G. Allie    | Domain....: Bil...@mu...
|  /|      | 7436 Hartwell     | MSN.......: B_G...@em...
|-/-|----- | Dearborn, MI 48126|
|/  |LLIE  | (313) 582-1540    |