Bytea data in SQL output pane
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
- Subject: Bytea data in SQL output pane
- From: Colin Beckingham <colbec@xxxxxxxxxxxx>
- Date: Wed, 27 Jun 2018 10:40:44 -0400
- User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.8.0
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?
[Index of Archives]
[KVM ARM]
[KVM ia64]
[KVM ppc]
[Virtualization Tools]
[Spice Development]
[Libvirt]
[Libvirt Users]
[Linux USB Devel]
[Linux Audio Users]
[Yosemite Questions]
[Linux Kernel]
[Linux SCSI]
[XFree86]