2

The column contains images as blob I want to get the size of the image with the maximum size. How can I get this?? I do Select max(photo) from table;

Improve this question
5
  • Ok, you want. What is the type of the photo column? There are at least two way to store binary data in the PostgreSQL: bytea and LOB Commented Dec 29, 2020 at 10:52
  • it is a lob/oid Commented Dec 29, 2020 at 10:56
  • Iin this case max(photo) is nothing about the photo's size. Just only about ID. Quick search: stackoverflow.com/questions/10169309/… Commented Dec 29, 2020 at 11:14
  • PS: Try to store photos in the bytea column. Yes I know some people who prefered to store 10 mb in bmp format in its VC. Actully #uck them all Commented Dec 29, 2020 at 11:37
  • yes it does thanks a lot Commented Jan 1, 2021 at 16:36
Related questions
55
How do I find the largest value in a column in postgres sql?
0
mySQL - How can i find the maximum size of content in a field
0
Postgresql - How to get largest value in column under constant
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.