| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | 杨杰 <yonj1e(at)163(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: user-friendliness improvement of pageinspect |
| Date: | 2018-07-10 18:48:14 |
| Message-ID: | CAH2-Wz=K66GnevxKb8gybhoBTx5oa=yvWap-CjYcK5Nj=KT=7Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jul 10, 2018 at 12:41 AM, 杨杰 <yonj1e(at)163(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Muller | 2018-07-10 18:51:00 | Re: Allow COPY's 'text' format to output a header |
| Previous Message | Corey Huinker | 2018-07-10 18:46:41 | Re: Desirability of client-side expressions in psql? |