Re: Binary data with postgress
"Billy G. Allie" <[email protected]>
| Newsgroups | gmane.comp.python.db.pypgsql.user |
|---|---|
| Message-ID | <[email protected]> |
"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....: [email protected] | /| | 7436 Hartwell | MSN.......: [email protected] |-/-|----- | Dearborn, MI 48126| |/ |LLIE | (313) 582-1540 | ------------------------------------------------------- This SF.net email is sponsored by: Get the new Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en