Python 3 library for reading and writing pg_dump files using the custom format.
pip install pgdumplibThe 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.dumpimport 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)
