如何获取当前查询的postgresql错误码

ERROR:  duplicate key value violates unique constraint "users_pkey"
DETAIL:  Key (id)=(1) already exists.

import psycopg2

try:
    conn = psycopg2.connect(database="yourdb", user="youruser", password="yourpass", host="yourhost", port="yourport")
    cur = conn.cursor()
    cur.execute("INSERT INTO users (id, name) VALUES (1, 'John Doe')")
    conn.commit()
except psycopg2.Error as e:
    print(f"Error: {e}")
    print(f"Error Code: {e.pgcode}")
finally:
    if conn is not None:
        conn.close()

import psycopg2

try:
    conn = psycopg2.connect(database="yourdb", user="youruser", password="yourpass", host="yourhost", port="yourport")
    cur = conn.cursor()
    cur.execute("INSERT INTO users (id, name) VALUES (1, 'John Doe')")
    conn.commit()
except psycopg2.Error as e:
    print(f"Error: {e}")
    print(f"Error Code: {e.pgcode}")
finally:
    if conn is not None:
        conn.close()