Hi Ho John Lee,
I found one can in DBeaver upload an image into bytea data type column.
So my issue is gone; by using DBeaver I can upload images and also
display those images stored in a postgresql database.
Thanks!
2021. 07. 15. 6:47 keltezéssel, Ho John Lee írta:
I use python with psycopg
I use python with psycopg2, for a table 'myimage_table' with columns
'label' and 'b' of type varchar and bytea something like this:
query = 'insert into myimage_table (label, b) values (%s, %s)'
imagelabel = 'some_label'
imagebuf =
b = psycopg2.Binary(imagebuf)
cur.execute(query, (imagelabel, b
If you have the binary data for the image in the bytea field, DBeaver will
display the image when you select that field in table view of the data.
The field will display something like "ÿØÿà JFIF [n]" in the row
(first part of data as unicode, and data length in bytes), you won't see
the ima
2021. 07. 14. 22:17 keltezéssel, Ho John Lee írta:
If you have the binary data for the image in the bytea field, DBeaver
will display the image when you select that field in table view of the data.
The field will display something like "ÿØÿà JFIF [n]" in the row
(first part of data as uni
Hi,
I am a novice in postgresql language.
By reading the documentation about storing binary data in postgresql
database, I realize that that one can store images as binary data by
using bytea or BLOB data types.
I am running postgresql on Ubuntu 20.04.2 LTS and using pgAdmin4 in
Desktop mod