import psycopg2
from config import host, user, password, db_name, port

connection = None
try:
    # подключаемся к базе
    connection = psycopg2.connect(
        host=host,
        user=user,
        password=password,
        database=db_name,
        port=port

    )
    connection.autocommit = True

    # cursor нужен чтобы взаимодействовать с БД
    # сейчас создаем нашу БД
    with connection.cursor() as cursor:
        cursor.execute(
            """CREATE TABLE IF NOT EXISTS data1 (
                price int NOT NULL,
                styles text NOT NULL,
                runes text);"""
        )

except Exception as _ex:
    print("[INFO] Error while working with PostgreSQL", _ex)
finally:
    if connection:
        connection.close()
        print("[INFO] PostgreSQL connection closed")

配置

host = "127.0.0.1"
user = "postgres"
password = "14101999"
db_name = "data"
port = "5432"

执行时，输出[INFO]使用PostgreSQL时出错
我不明白在所有的问题是什么，为什么数据库没有被创建，我似乎已经表明一切正确的配置...