pg_filedump 10.0 released
pg_filedump is a utility to format PostgreSQL heap/index/control files
into a human-readable form. You can format/dump the files several
ways, as listed in the Invocation section, as well as dumping straight
binary.
https://wiki.postgresql.org/wiki/Pg_filedump
New in version 10.0 is the ability to decode tuples by giving a list
of type names:
-D Decode tuples using given comma separated list of types. List of supported types: * bigint *
bigserial * bool * char * charN -- char(n) * date * float * float4 *
float8 * int * json * macaddr * name * oid * real * serial * smallint
* smallserial * text * time * timestamp * timetz * uuid * varchar *
varcharN-- varchar(n) * xid * xml * ~ -- ignores all attributes left in a tuple
For instance, pg_attribute can be decoded like this:
pg_filedump -D oid,name,oid,int,smallint,~ path/to/segment/1249
This feature was implemented by Aleksander Alekseev, reviewed by
Dmitry Ivanov, tested by Dmitry Ivanov and Grigoriy Smolkin.