Postgres Pro
Downloads
Home   >   mailing lists

Thread: binary files

binary files

From
"Dorward Villaruz"
Date:
how can i store a java object or binary files in a postgres table?

Re: binary files

From
"Cornelia Boenigk"
Date:
Hi

You can store binary files either as type oid or as type bytea.

See the Book of Bruce Momjian which is available online. There is a
chapter about Large Objects and how to store or retrieve. Or take a
look at the Documentation. I the Programmer's Guide there is
- Chapter 2: Large Objects
- Chapter 8.6 Storing Binary Data

In the User's Guide you may look at chapter 3.4 Binary Strings.

Regards
Conni