Where are product images located in postgresql?

Question

Within Odoo12, I cannot find where the product images are located. As I am trying to import some data
from Odoo 10 to Odoo12. Could not find it in the product_template or product_product tables..

Gaurav Patil · Answer

product images are not directly accessible through SQL queries because they are stored in the filestore rather than being directly stored in the database.

Salmi Sifeddine · Answer

do you have any idea where can i find them ?

Haresh Kansara · Answer

Hello Sean,
The image of products are non-stored field it's not store in database as i know, You can see database table field structure (Activate Developer Mode). From Settings > Technical > Database Structure > Models > product.product. Here you can see there is a field image which is non-stored field.
So You can access but when you check in database then it's not found.
Hope it will helpful for you.

Thanks and regards
Haresh Kansara

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Cannot import date field Ratkaistu import 12.0	1 tammik. 20	13055
how to include the codes in import button using odoo 8.0 import postgresql python2.7	0 heinäk. 16	3833
Import Parts in different Size & Colors import online variants 12.0	2 helmik. 19	3702
Importing postgres data to odoo? import postgresql boolean odooV8	3 heinäk. 16	6585
Issue with import and comma in Excel File (odoo 19) import	0 syysk. 25	234

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!