user-friendliness improvement of pageinspect - Mailing list pgsql-hackers

From 杨杰
Subject user-friendliness improvement of pageinspect
Date
Msg-id 52bc017.4d33.1648322feb3.Coremail.yonj1e@163.com
Whole thread Raw
Responses Re: user-friendliness improvement of pageinspect
List pgsql-hackers
font{ line-height: 1.6; } ul,ol{ padding-left: 20px; list-style-position: inside; }
Hi,

Why does the heap_page_item () of the pageinspect extension not consider providing better user-friendliness?

My test table has the following data, and when I look at the t_data I see data of type bytea instead of a more intuitive type, even the same type as the original table.

# select * from test1;
 a |  b   
---+------
 1 | text
(1 row)

# SELECT lp as tuple, t_xmin, t_xmax, t_attrs[1] as a, t_attrs[2] as b FROM heap_page_item_attrs(get_raw_page('test1', 0), 'test1');
 tuple | t_xmin | t_xmax |     a      |      b       
-------+--------+--------+------------+--------------
     1 |    587 |      0 | \x01000000 | \x0b74657874
(1 row)

Similar to this effect:

# SELECT lp as tuple, t_xmin, t_xmax, t_attrs[1] as a, t_attrs[2] as b FROM heap_page_item_attrs(get_raw_page('test1', 0), 'test1');
 tuple | t_xmin | t_xmax |     a      |      b       
-------+--------+--------+------------+--------------
     1 |    587 |      0 | 1 | text
(1 row)

Look forward to the solution.
a#ntes-pcmail-signature-default:hover { text-decoration: underline; color: #199cff; cursor: pointer; } a#ntes-pcmail-signature-default:active { text-decoration: underline; color: #246fce; cursor: pointer; }
font{ line-height: 1.6; }
font{ line-height: 1.6; }
font{ line-height: 1.6; }

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Non-reserved replication slots and slot advancing
Next
From: Michael Paquier
Date:
Subject: Re: Non-reserved replication slots and slot advancing