From: | Christoph Berg <myon(at)debian(dot)org> |
---|---|
To: | PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org> |
Subject: | pg_filedump 10.0 released |
Date: | 2017-10-22 18:38:31 |
Message-ID: | 20171022183831.uxt3jkbilbn35o3m@msg.df7cb.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Shah, Jignesh | 2017-10-26 15:44:02 | Announcing General Availability of Amazon Aurora with PostgreSQL compatibility |
Previous Message | David Fetter | 2017-10-22 18:09:46 | == PostgreSQL Weekly News - October 22 2017 == |