ahmedivy

do $$ declare
    r record;
begin
    for r in (select tablename from pg_tables where schemaname = 'my-schema-name') loop
        execute 'drop table if exists ' || quote_ident(r.tablename) || ' cascade';
    end loop;
end $$;

ahmedivy

import os
import re
import fitz

DESTINATION = r"<your_destination_folder_to_save_notes>"

path = os.path.join(os.path.expanduser('~'), 'Downloads')

files = [f for f in os.listdir(path) if re.search(r'chapter.+\.pdf', f)]