redash
redash copied to clipboard
Postgres BYTEA columns visualized as hex in table, breaks UI
Issue Summary
Postgres data source BYTEA columns break the UI and must be manually hidden
Steps to Reproduce
- 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.
- Insert some rows there the BYTEA column is a suitably long binary blob (something encoded, a small image, whatever)
- Make a new query - select * from my_table - a reasonable way to start looking at what the data is. Evaluate the query.
- 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