Dmitry Narizhnykh: How to Inspect a pg_dump Without Restoring It

T2Covered by 1 source · first reported by Planet PostgreSQL at 25 Sept, 12:56 UTC

You can't read a pg_dump file the way you read a table. To see what is inside, you normally restore it into a PostgreSQL server first. pg_restore and grep can list the tables without a restore, and even print a table's rows as raw text. They can't filter, sort or join them. The free PostgreSQL Dump…

cloud

Sources

• T2Dmitry Narizhnykh: How to Inspect a pg_dump Without Restoring ItPlanet PostgreSQL25 Sept, 12:56