回复: user-friendliness improvement of pageinspect

Поиск
Список
Период
Сортировка
От Yang Jie
Тема 回复: user-friendliness improvement of pageinspect
Дата
Msg-id cdc759a.23ce.1648702f53c.Coremail.yonj1e@163.com
обсуждение исходный текст
Ответ на Re: user-friendliness improvement of pageinspect  (Peter Geoghegan <pg@bowt.ie>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Excessive PostmasterIsAlive calls slow down WAL redo
Следующее
От: David Rowley
Дата:
Сообщение: Re: Speeding up INSERTs and UPDATEs to partitioned tables