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

Поиск
Список
Период
Сортировка
От Csanyi Pal
Тема How to display stored image as bytea or as large objects?
Дата
Msg-id e2730d87-0c22-f3f8-82aa-0a78316e2c00@gmail.com
обсуждение исходный текст
Ответы Re: How to display stored image as bytea or as large objects?  (Ho John Lee <hjl@mindspring.com>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Adam Norwood
Дата:
Сообщение: Problem upgrading from Postgresql 9.5
Следующее
От: Ho John Lee
Дата:
Сообщение: Re: How to display stored image as bytea or as large objects?