Import image from odoo to PostgreSQL

Question

Hi all,

I add a photo on my module created on Odoo with a binary field. How can I visualize it on PostgreSQL like a columns of my table?
Example:
Name  Surname  Image
x                y               *image*

Thanks.

Haresh Kansara · Answer

Hi,

I am not sure but may be it works in PGADMIN.
SELECT  encode ( blobdata :: bytea ,   'escape' )   FROM   table   as  o  where  o . blobdata  !=   ''  where
blobdata is the bytea column (blob) "table" is the table that contains the column blobdata

This question has been flagged

Enjoying the discussion? Don't just read, join in!