Обсуждение: How to save a blob (binary, bytea) to a local file?

Поиск
Список
Период
Сортировка

How to save a blob (binary, bytea) to a local file?

От
Durumdara
Дата:
Hello!

In EMS PGSQL manager the Form Editor View contains an extra button for each bytea field.
I can load a file into a binary field, or I can save the content to a file - into my filesystem.

Now I can't find the same functionality.

When I have only PGAdmin (like in local servers of customers), I can't extract the data to see it.
For example a PDF file which is stored in a column.

Is it my fault or this function doesn't exist yet?

Thank you for your help!

dd

Re: How to save a blob (binary, bytea) to a local file?

От
Aditya Toshniwal
Дата:
Hi Durumdara,

On Thu, Dec 3, 2020 at 7:32 PM Durumdara <durumdara@gmail.com> wrote:
Hello!

In EMS PGSQL manager the Form Editor View contains an extra button for each bytea field.
I can load a file into a binary field, or I can save the content to a file - into my filesystem.

Now I can't find the same functionality.

When I have only PGAdmin (like in local servers of customers), I can't extract the data to see it.
For example a PDF file which is stored in a column.

Is it my fault or this function doesn't exist yet?
The feature does not exist. You can raise it here - https://redmine.postgresql.org/projects/pgadmin4/issues/new 

Thank you for your help!

dd



--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"