psycopg2:语句返回码

import psycopg2

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

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

# 执行SQL语句
cur.execute("SELECT * FROM your_table")

# 获取语句返回码
status = cur.status

# 根据返回码进行相应处理
if status == psycopg2.extensions.STATUS_OK:
    print("SQL command executed successfully.")
elif status == psycopg2.extensions.STATUS_BAD_RESPONSE:
    print("Invalid response from the database.")
elif status == psycopg2.extensions.STATUS_NONFATAL_ERROR:
    print("Non-fatal error occurred during SQL command execution.")
elif status == psycopg2.extensions.STATUS_FATAL_ERROR:
    print("Fatal error occurred during SQL command execution.")

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