使用Sequelize操作PostgreSQL插入数据时遭遇报错

错误码42P01是PostgreSQL的「未定义表」错误，从报错信息里的parserOpenTable可以看出，执行INSERT语句时找不到指定的users表。以下是具体排查和解决步骤：

• 确认目标数据库中是否存在users表
  直接用psql或其他PostgreSQL客户端连接数据库，执行SELECT * FROM users;，如果返回「关系"users"不存在」，说明表确实未创建，需要先建表。
• 检查Sequelize模型的表名配置
  Sequelize默认会把模型名复数化作为表名（比如User模型对应users表），如果手动指定了tableName属性，要确保和数据库中的表名完全一致，大小写也要注意（PostgreSQL默认对未加引号的表名转小写）。
• 验证Sequelize连接的数据库是否正确
  检查Sequelize初始化代码中的数据库名称，确认和你创建users表的数据库是同一个，避免连接到错误的库导致找不到表。
• 确认是否执行了模型同步
  如果依赖Sequelize自动创建表，必须调用sync()方法（比如await User.sync()或await sequelize.sync()）。注意生产环境不要用force: true，防止误删已有数据。

报错信息： #

{
"name": "SequelizeDatabaseError",
"parent": {
"length": 104,
"name": "error",
"severity": "ERROR",
"code": "42P01",
"position": "13",
"file": "parse_relation.c",
"line": "1449",
"routine": "parserOpenTable",
"sql": "INSERT INTO \"users\" (\"user_id\",\"user_name\",\"user_email\",\"user_password\",\"user_image\",\"total_orders\") VALUES ($1,$2,$3,$4,$5,$6) RETURNING \"user_id\",\"user_name\",\"user_email\",\"user_password\",\"user_image\",\"total_orders\",\"created_at\",\"last_logged_in\";",
"parameters": [
"135c369f-23f6-4f20-8d25-e7cfad05187b",
"Anurag Parmar",
"anurag@gmail.com",
"$2b$05$l4TE19JJKbZsbswRjnPQ0.W9xnKAClaUTKrTbko8Bjs3EDyx00XWi",
"123456",
0
]
},
"original": {
"length": 104,
"name": "error",
"severity": "ERROR",
"code": "42P01",
"position": "13",
"file": "parse_relation.c",
"line": "1449",
"routine": "parserOpenTable",
"sql": "INSERT INTO \"users\" (\"user_id\",\"user_name\",\"user_email\",\"user_password\",\"user_image\",\"total_orders\") VALUES ($1,$2,$3,$4,$5,$6) RETURNING \"user_id\",\"user_name\",\"user_email\",\"user_password\",\"user_image\",\"total_orders\",\"created_at\",\"last_logged_in\";",
"parameters": [
"135c369f-23f6-4f20-8d25-e7cfad05187b",
"Anurag Parmar",
"anurag@gmail.com",
"$2b$05$l4TE19JJKbZsbswRjnPQ0.W9xnKAClaUTKrTbko8Bjs3EDyx00XWi",
"123456",
0
]
},
"sql": "INSERT INTO \"users\" (\"user_id\",\"user_name\",\"user_email\",\"user_password\",\"user_image\",\"total_orders\") VALUES ($1,$2,$3,$4,$5,$6) RETURNING \"user_id\",\"user_name\",\"user_email\",\"user_password\",\"user_image\",\"total_orders\",\"created_at\",\"last_logged_in\";",
"parameters": [
"135c369f-23f6-4f20-8d25-e7cfad05187b",
"Anurag Parmar",
"anurag@gmail.com",
"$2b$05$l4TE19JJKbZsbswRjnPQ0.W9xnKAClaUTKrTbko8Bjs3EDyx00XWi",
"123456",
0
]
}

内容的提问来源于stack exchange，提问作者Anurag Parmar