How do large objects datatypes know the difference between jpeg, mdi, mp3, etc?

Question

I'm talking sql here

Answer 1

They don't. Large object fields just store the raw binary data from the file, it's up to the application to know what file type is actually stored in the field.