pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

Copying and pasting rows containing commas breaks the columns

Open masukatto0281 opened this issue 2 months ago • 0 comments

Describe the bug When pasting rows containing commas using the copy and paste function in the Query results grid, the columns become misaligned and are not pasted into the correct columns.

To Reproduce Steps to reproduce the behavior:

  1. Create table.
CREATE TEMPORARY TABLE IF NOT EXISTS tbl_a 
(col_int INTEGER, col_tstzrange tstzrange, col_varchar CHARACTER VARYING, col_tstz TIMESTAMP WITH TIME ZONE, PRIMARY KEY (col_int));
  1. Insert data.
INSERT INTO tbl_a VALUES (1, NULL, 'a', now());
INSERT INTO tbl_a VALUES (2, tstzrange (now(), now() + '1hour', '(]'), 'b', now());
INSERT INTO tbl_a VALUES (3, NULL, 'c,d', now());
  1. Copy and paste each row of the Results grid.
  2. Only rows containing commas (2 and 3) are not pasted into the correct columns.

Expected behavior Even if commas are included, they will be pasted into the same columns as when copied.

Error message None.

Screenshots Image

Desktop (please complete the following information):

  • OS: Windows 11 (24H2)
  • pgAdmin version: 9.9
  • Mode: Desktop
  • Package type: Windows exe installer

Additional context

masukatto0281 avatar Oct 27 '25 05:10 masukatto0281