hi people, is postgreSQL able to store data in jpeg or gif format?? if so, wat type of data type that i can use to store the pictures? thanks in advance.
This is was a topic I had to do some research on. The conclusion was that storing pictures in PostgreSQL doesn't make a lot of sense, though it is supported.
If you feel you have to store the photos in Postgres.. Check out the documentation section of the PostgreSQL web site, check out the function "pg_largeobject". There it will tell you how all that stuff is done.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.