This question has been flagged
1 Reply
5139 Views

Hi All,

I have created module where employee can upload their image. Module works perfectly. No issue with saving /displaying employee record including image.

But I would like to know where exactly image file is stored ?

Thanks. Here is my class and img field holds file name. Please let me know in which table image is stored and how it is related to test_base table ?

from osv import osv

from osv import fields

class test_base(osv.osv):
     _name='test.base'
    _columns={
        'name':fields.char('Name'),
        'email':fields.char('Email'),
        'mydate':fields.date('My Date'),
        'code':fields.integer('Unique ID'),
        'sal':fields.integer('Salary'),
        'rate':fields.selection([(10,'10'), (20,'20'),(30,'30')],'Percentage of Deduction'),
        'ded':fields.float('Deduction'),
        'bdisplay':fields.float('Net Salary'),
        'image': fields.binary("Image", help="Select image here"),
        'skillid':fields.one2many('test.skill','exp'),

    }
Avatar
Discard
Best Answer

Hello shrikant

Image is stored in binary format. Go to pgadmin or access your database on terminal.

select image from test_base; The image column will show you binary format string for each image

Avatar
Discard

thanks for the info. Does it mean that we can't view image stored in database?

No u cannot view image because its just binary format data.

Thanks Again.