Bytea data in SQL output pane

Поиск
Список
Период
Сортировка
От Colin Beckingham
Тема Bytea data in SQL output pane
Дата
Msg-id d35000f0-e2a2-eb0b-1a67-0d62669ee20f@kingston.net
обсуждение исходный текст
Список pgsql-admin
Currently any bytea fields are rendered as "[binary data]" in SQL output 
pane. From the archive I found a message that evidently there was very 
high processor load in trying to show the data. I guess the solution at 
the time was not to render the data at all. Bytea is used a lot in 
crypto, an example is blockchain hashes. It is handy to be able to see 
that hashes end up in the right record and right column. A workaround is 
to use pgphpadmin which reveals the correct codes, and as long as we use 
the now (Postgresql 10) non-default 'escape' encoding and not the 
default 'hex' the data is visible in the REPL as well. Just wondering 
where this issue sits in the TODO list if any?



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

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: Upgrading 9.6.9 to 10.4
Следующее
От: Rui DeSousa
Дата:
Сообщение: Re: Investigate postgres 9.6.3 repmgr lag 4.0.4