Query Data Output view shows incorrect value

[jmartikainen]

In some cases the Query data output view shows incorrect value for row. This happens when table has default value definition for column and row got NULL value explicitly inserted for row.

To Reproduce

Run following SQL script and see Data Output view results (or screenshot)

CREATE TABLE t (val text DEFAULT ''::text);
INSERT INTO t DEFAULT VALUES;   -- uses default
INSERT INTO t (val) VALUES (''); -- explicit empty string
INSERT INTO t (val) VALUES (NULL); -- explicit NULL

SELECT val, LENGTH(val) FROM t;

Expected behavior

val should be [null] instead of [default] on row 3

Error message

No error messages

Screenshots

Desktop (please complete the following information):

• OS: Ubuntu 24
• pgAdmin version: 9.7
• Mode: Docker image
• Browser: Chrome 139.0.7258.138
• Package type: Container

Additional context

Nope