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

From Peter Geoghegan
Subject Re: user-friendliness improvement of pageinspect
Date
Msg-id CAH2-Wz=K66GnevxKb8gybhoBTx5oa=yvWap-CjYcK5Nj=KT=7Q@mail.gmail.com
Whole thread Raw
In response to user-friendliness improvement of pageinspect  (杨杰 <yonj1e@163.com>)
Responses 回复: user-friendliness improvement of pageinspect  ("Yang Jie" <yonj1e@163.com>)
List pgsql-hackers
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: Corey Huinker
Date:
Subject: Re: Desirability of client-side expressions in psql?
Next
From: Simon Muller
Date:
Subject: Re: Allow COPY's 'text' format to output a header