pg_filedump 10.0 released

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.