Correct Data Type for Images

[gwinn7]

Does any one know which PostgreSQL data type to use for loading pictures (ie. JPG images)?

We have a Microsoft Access database loaded up with about 8000 images. The data type in Access to store this is in "OLE OBJECT". What is the equivalant, if any, in PostgreSQL? The obvious goal at this point is to load those pictures in to PostgreSQL and serve them through Apache.

I went through the PostgreSQL official Administrator's Guide and the User's Guide, but their explanations weren't that conclusive.

FYI: Running Red Hat v7.1

Thanks,
Gary

 

[gwinn7]

OK, it appears that the correct datatype is "oid". The notes in the documentation explain it...

http://www.postgresql.org/idocs/index.php?largeobjects.html#LO-HISTORY

I am going to give this a try and post another message as what the result was.

Gary
gwinn7

 

[SteveBrett]

i think you're looking for ther BLOB type ...

Steve

 

[rycamor]

LOB, BLOB, or Binary Large Object, are the standard terms for this datatype. But PostgreSQL uses the keyword "OID" when creating the column, which stands for Object Identifier. -------------------------------------------

"Calculus is just the meaningless manipulation of higher symbols"
                          -unknown F student

 

[Guest_imported]

You can use bytea data type which is better if your image size is not very large.