使用SQLAlchemy无法创建PostgreSQL数据库Schema的问题求助

我可以通过命令行执行 CREATE SCHEMA test_schema; 成功创建数据库Schema，但运行下面的SQLAlchemy代码时，却没能创建出对应的Schema，这让我很困惑。

我的Python代码如下：

from sqlalchemy import create_engine
from sqlalchemy.schema import CreateSchema


def main():
    conn_str = "postgresql+psycopg2://<myusername>:<mypassword>@localhost/belgarath_test"

    engine = create_engine(conn_str, echo=True)

    connection = engine.connect()

    connection.execute(CreateSchema("test_schema"))


if __name__ == "__main__":
    main()

奇怪的是，SQLAlchemy明明已经输出了正确的SQL语句，完整的运行日志如下：

2024-12-29 17:54:22,128 INFO sqlalchemy.engine.Engine select pg_catalog.version()
2024-12-29 17:54:22,129 INFO sqlalchemy.engine.Engine [raw sql] {}
2024-12-29 17:54:22,129 INFO sqlalchemy.engine.Engine select current_schema()
2024-12-29 17:54:22,129 INFO sqlalchemy.engine.Engine [raw sql] {}
2024-12-29 17:54:22,130 INFO sqlalchemy.engine.Engine show standard_conforming_strings
2024-12-29 17:54:22,130 INFO sqlalchemy.engine.Engine [raw sql] {}
2024-12-29 17:54:22,130 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2024-12-29 17:54:22,130 INFO sqlalchemy.engine.Engine CREATE SCHEMA test_schema # <------------------
2024-12-29 17:54:22,130 INFO sqlalchemy.engine.Engine [no key 0.00008s] {}

日志里已经明确显示执行了CREATE SCHEMA test_schema语句，但数据库里就是没有这个Schema。有没有人能帮我分析一下这是为什么？

备注：内容来源于stack exchange，提问作者Jossy