How to display stored image as bytea or as large objects?

From: Csanyi Pal <csanyipal(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: How to display stored image as bytea or as large objects?
Date: 2021-07-14 19:56:58
Message-ID: e2730d87-0c22-f3f8-82aa-0a78316e2c00@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 mode.

I have stored an image in one of my table with this command:

<code>
insert into leckek
(az, a_tanitas_nyelve, mely_negyedevben, mely_osztalyban,
mely_tagozaton, mely_orakon, a_tanitas_temaja,
a_lecke_neve, a_lecke_gyakorlati_reszenek_neve,
a_lecke_gyakorlati_reszenek_dokumentuma,
a_lecke_elmeleti_reszenek_neve, a_lecke_elmeleti_reszenek_dokumentuma,
a_lecke_elmeleti_reszenek_tesztje)
values (default, 'Hu', 1, 5, 'b', '1-2', 'Élet és mukakörnyezet',
'A technika és technológia fogalma, szerepe és jelentősége',
'másolás',
default,
'A lényeg',

lo_import('/home/pali/Irataim/Iskola/IskolaEv_2020_2021/MuszakiOraim/Digitalis_Tananyagok_Orakra/Hu/5/5_osztaly_Tananyag_01_02_orara.png'),
default)
</code>

so I have now in this table the first row:
1 "Hu" 1 5 "b" "1-2 " "Élet és mukakörnyezet" "A technika és
technológia fogalma, szerepe és jelentősége" "másolás" "A lényeg" "16800"

Here the 16800 is the OID of the binary data, the image.

I would like to know how can one display this stored image somehow by
using some IDE for manage databases?

In applications like pgAdmin4, Libreoffice Base, pgModeler, DBeaver one
can't display this stored image.

In SQLiteBrowser (this is an IDE for SQLite databases) one can display
with easy the stored image.

So is there an easy way to display a stored image in postgresql?

--
Best,
from Paul

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ho John Lee 2021-07-14 20:17:32 Re: How to display stored image as bytea or as large objects?
Previous Message Adam Norwood 2021-07-14 16:12:22 Problem upgrading from Postgresql 9.5