Problem: How to Store JPG in PostgreSQL

[gwinn7]

I know this question is innapropriate for this forum, but I posted the same thread in the PostgreSQL forum with no response for the past day or so. I hope someone out there has valuable insight into this.

Here is my issue...

Does any one know which PostgreSQL datatype to use for loading pictures (ie. JPG images)? Or how this may be done.

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 on our Red Hat Linux 7.1 box.

I went through the PostgreSQL official Administrator's Guide and the User's Guide, but their explanations weren't that conclusive. I even hunted through the web for a specific answer and all I found were users that had the same question I did with no resolution.

Can you help?

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