回复: user-friendliness improvement of pageinspect - Mailing list pgsql-hackers

From Yang Jie
Subject 回复: user-friendliness improvement of pageinspect
Date
Msg-id cdc759a.23ce.1648702f53c.Coremail.yonj1e@163.com
Whole thread Raw
In response to Re: user-friendliness improvement of pageinspect  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
font{ line-height: 1.6; } ul,ol{ padding-left: 20px; list-style-position: inside; }
Thank you for your answer.

my question is not split the data into individual attributes.
I want to see the data in the table, but I don't want to be a bytea type.



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; }

2018年7月11日 02:48Peter Geoghegan<pg@bowt.ie> 写道:
On Tue, Jul 10, 2018 at 12:41 AM, 杨杰 <yonj1e@163.com> wrote:
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.

tuple_data_split() can do this (split the data into individual
attributes). If you want a friendlier, more visual way of getting this
information, then you may find pg_hexedit helpful:

https://github.com/petergeoghegan/pg_hexedit

--
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Excessive PostmasterIsAlive calls slow down WAL redo
Next
From: David Rowley
Date:
Subject: Re: Speeding up INSERTs and UPDATEs to partitioned tables