pgadmin-org / pgadmin-org/pgadmin4

Show overflow indicator in results grid for multi line text

Open
#8,499 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Feature
Dominant language
Python
Stars
3.8k
Forks
891
Avg merge
4d 7h
Merged PRs (30d)
8

Description

Describe the solution you'd like

If the text in a cell is longer than the column width, the text is truncated and a ... is displayed to indicate the horizontal overflow. If the overflow occurs vertically instead, due to a line break, the overflow is invisible.

Describe alternatives you've considered

Double-click the cell to open its contents in a popup. To do this, you first need to know that there is an overflow.

To further optimise the handling of long text, it would be great to have the ability to increase the height of the lines in the results grid, or a larger dockable panel (like the Scratch Pad) that stays visible next to the results grid and showing the contents of the currently selected cell!

Additional context

See example here:
Image

Image

Even psql -X will show an indicator (and the full contents) in this case:
Image

This feature request was inspired by feedback from @sfkeller, who reported this as a problem when teaching SQL to his students.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The issue does not name files or tests. Reproduce the multiline-cell case in the results grid using the screenshots and compare it with psql -X; then locate the grid implementation and its existing truncation behavior. Done means vertically overflowing text has a visible indicator without changing the requested grid behavior beyond that indicator.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases, frontend
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.