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.
signature.asc
Description: PGP signature