Bytea as "Binary Data"

From: Colin Beckingham <colbec(at)kingston(dot)net>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Bytea as "Binary Data"
Date: 2018-07-02 07:43:16
Message-ID: 89d1ae6b-0f4c-2723-38c7-61a65f17f9e6@kingston.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Currently pgadmin4 displays bytea fields as "[Binary Data]".

In searching the archives for the reason for this, I found some
discussion on lengthy processing slowing down display. So a decision was
made to not attempt to display the data at all, and since the data can
be lengthy this makes some sense.

While such binary data is not "readable", in the era of SHA hashes it is
useful to be able to visually check that the right hash is in the right
column using the first few text characters. We can of course do this in
the Postgresql REPL or even in the old phpPgAdmin which usefully
displays part of the 'escape' translation of the hash.

Is there some concrete reason for not displaying such data, or is the
community open to revealing a short stub which would be more helpful
than no representation at all? Thanks.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2018-07-02 09:00:31 Re: Bytea as "Binary Data"
Previous Message Henrik Uggla 2018-07-02 07:24:51 SV: Prevent password change