separate a pg_dump file into individual tables

pg_table.py

# first `mkdir tables`
dump_file = 'DUMPFILE.sql'

with open(dump_file, 'r') as sql:
    table = None
    for line in sql.readlines():
        if line.startswith('COPY public.'):
            t = line.split()[1]
            print(f"opening {t}")
            table = open(f"tables/{t}", 'w')

        if table:
            table.write(line)
            if line.strip() == '\.':
                print('closing table')
                table.close()
                table = None