pgdumplib

Python3 library for reading and writing pg_dump files using the custom format.

Installation

pip install pgdumplib

Example Usage

The following example shows how to create a dump and then read it in, and iterate through the data of one of the tables.

pg_dump -d pgbench -Fc -f pgbench.dump

import pgdumplib

dump = pgdumplib.load('pgbench.dump')

print('Database: {}'.format(dump.toc.dbname))
print('Archive Timestamp: {}'.format(dump.toc.timestamp))
print('Server Version: {}'.format(dump.toc.server_version))
print('Dump Version: {}'.format(dump.toc.dump_version))

for line in dump.table_data('public', 'pgbench_accounts'):
    print(line)