Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres BYTEA columns visualized as hex in table, breaks UI #6989

Open
sklibanov312 opened this issue May 24, 2024 · 0 comments
Open

Postgres BYTEA columns visualized as hex in table, breaks UI #6989

sklibanov312 opened this issue May 24, 2024 · 0 comments

Comments

@sklibanov312
Copy link

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:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant