23
I would like to obtain the byte size of a blob.
I am using Postgresql and would like to obtain the size using an SQL query. Something like this:
SELECT sizeof(field) FROM table;
Is this possible in Postgresql?
Update: I have read the postgresql manual and could not find an appropriate function to calculate the file size. Also, the blob is stored as a large object.