Re: Bytea as "Binary Data"

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Colin Beckingham <colbec(at)kingston(dot)net>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Bytea as "Binary Data"
Date: 2018-07-02 09:00:31
Message-ID: CA+OCxoytSiaXLLkQv65EdHoGv6kGwOK11MeNNYe1Q_WnnZ5VJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Mon, Jul 2, 2018 at 8:43 AM, Colin Beckingham <colbec(at)kingston(dot)net>
wrote:

> 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.
>

I'm not opposed to showing something more useful than "[Binary Data]". The
question is, what exactly? In many cases it'll likely be unreadable garbage.

FYI, eventually I'd like to be able to try to detect the data type, so if
we find it's actually an image for example, we can display it (and
potentially have an editor cell that allows you to replace it).

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Colin Beckingham 2018-07-02 10:07:47 Re: Bytea as "Binary Data"
Previous Message Colin Beckingham 2018-07-02 07:43:16 Bytea as "Binary Data"