如何在postgresql表中插入python日志？

import psycopg2
import logging

# 创建数据库连接
conn = psycopg2.connect(
    host="your_host",
    port="your_port",
    database="your_database",
    user="your_username",
    password="your_password"
)

# 创建游标
cur = conn.cursor()

# 配置日志
logging.basicConfig(level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s')

# 创建日志记录器
logger = logging.getLogger(__name__)

# 插入日志到PostgreSQL表
def insert_log(message):
    try:
        # 记录日志
        logger.info(message)
        
        # 插入日志到表中
        cur.execute("INSERT INTO logs (message) VALUES (%s)", (message,))
        conn.commit()
        
        logger.info("日志插入成功")
    except (Exception, psycopg2.DatabaseError) as error:
        logger.error("日志插入失败: %s" % error)

# 测试插入日志
insert_log("这是一条测试日志")

# 关闭游标和连接
cur.close()
conn.close()