redash icon indicating copy to clipboard operation
redash copied to clipboard

Postgres BYTEA columns visualized as hex in table, breaks UI

Open sklibanov312 opened this issue 1 year ago • 0 comments

Issue Summary

Postgres data source BYTEA columns break the UI and must be manually hidden

Steps to Reproduce

  1. Add a postgres data source with a table my_table with a BYTEA column and a dozen other other reasonable-size text or numeric columns.
  2. Insert some rows there the BYTEA column is a suitably long binary blob (something encoded, a small image, whatever)
  3. Make a new query - select * from my_table - a reasonable way to start looking at what the data is. Evaluate the query.
  4. Observe that the Table has a hexlified version of the blob as one line. User has to scroll so very far sideways to get past it to see the other columns.

The workarounds of manually selecting specific columns or saving the query and manually hiding the BYTEA column are inconvenient, compared to the 'easy' behavior of something like pgAdmin that 'just' puts '[binary data]' in the results panel.

Help?

Technical details:

  • Redash Version: 10.1.0 (2589bef1)
  • Browser/OS: Chrome/Windows
  • How did you install Redash: https://github.com/getredash/setup

sklibanov312 avatar May 24 '24 22:05 sklibanov312