with open(filepath) as fd:
        first_line = fd.readline()
        cols = []
        for col in first_line.strip().split(','):
            col2 = f'''"{col.strip('"')}" text'''
            cols.append(col2)
        cols2 = ','.join(cols)
        print(f"create table {table_name} ({cols2});")
    print(f"\copy {table_name} from '{filepath}' csv header;")

run the output in a psql instance connected to your db

(important note: \copy is a psql client command and it is critical to use \copy instead of COPY in many cases where the server process may not have the permission to read your CSV file. with \copy you can read any file the user that launched psql client has permission to read. to make things more confusing it is indeed possible to stream stdin through psql but you use the regular COPY for that instead of \copy)