Feature: Preview for bytea image fields in query results
Maintainers usually reply within 2 days
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 35/100
Research direction
The issue does not identify any files, tests, or entry points in pgAdmin. Research would need to locate the query result grid and its bytea rendering path first; done would include image detection and preview behavior, with the optional open and download actions defined and tested.
Written by the indexing model from the issue text.
Description
Describe the solution you'd like
Add native support in pgAdmin to preview bytea fields as images (e.g., JPEG, PNG) directly in the query result grid.
The tool should automatically detect common image formats and provide a visual preview (thumbnail or full image), similar to what is available in DBeaver.
Optionally, include actions such as:
- "Open as image"
- "Download file"
Describe alternatives you've considered
Currently, the only alternatives are:
- Manually converting
byteadata to base64 or binary and saving it as a file - Using external tools or scripts (e.g., Node.js, Python) to reconstruct the image
- Using other database clients like DBeaver, which already support this feature
These approaches are time-consuming and reduce productivity when inspecting data.
Additional context
This feature would significantly improve the usability of pgAdmin when working with binary data, especially for debugging and validating stored images.
Example use case:
SELECT image_data FROM files LIMIT 1;
In pgAdmin, the result is displayed as raw binary/hex data, making it difficult to interpret. A built-in preview would eliminate the need for manual extraction.
This is particularly useful in systems that store files or images directly in PostgreSQL using bytea.
- Dominant language
- Python
- Stars
- 3.9k
- Forks
- 922
- Avg merge
- 2d 3h
- Merged PRs (30d)
- 33
Getting set up
- Ships a Dockerfile or Docker Compose file
- No pull request template
- Read the contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from pgadmin-org/pgadmin4
-
Invalid syntax in sshtunnelPossibly taken A pull request linked to this issue is open or already merged. OpenBug
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
pgadmin-org/pgadmin4#10797 ·
Maintainers usually reply within 2 days
-
Feature
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
pgadmin-org/pgadmin4#10426 · 3 comments · 1 reaction ·
Maintainers usually reply within 2 days
-
Bug
Difficulty 4/5 3-5 days Newbie friendliness 25/100
pgadmin-org/pgadmin4#10796 · 1 comment ·
Maintainers usually reply within 2 days
-
Schema Diff does not detect foreign keys that reference a different schemaPossibly taken @dpage claimed this today. Open
Difficulty 4/5 3-5 days Newbie friendliness 57/100
pgadmin-org/pgadmin4#10786 · 1 assignee ·
Maintainers usually reply within 2 days
-
Bug
Difficulty 4/5 3-5 days Newbie friendliness 55/100
pgadmin-org/pgadmin4#10783 ·
Maintainers usually reply within 2 days
All issues in pgadmin-org/pgadmin4
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
mohanraj00/entelos#200 ·
Maintainers usually reply within 1 day
-
Difficulty 1/5 Under an hour Newbie friendliness 68/100
-
sweep
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
bketelsen/truenas-mcp#77 ·
Maintainers usually reply within 1 day
-
Console writes URL credentials to the local log, though AGENTS.md says secrets never reach diskOpen
Difficulty 1/5 Under an hour Newbie friendliness 86/100
sandbox-quantum/switch#2163 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
openedx/xblock-lti-consumer#765 ·
Maintainers usually reply within 1 day