【postgresql】ERROR: INSERT has more expressions than target columns

本文主要是介绍【postgresql】ERROR: INSERT has more expressions than target columns，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

执行下面sql 

insert into apply_account_cancellation3 select * from   pply_account_cancellation;

返回下面错误信息

insert into apply_account_cancellation3 select * from   apply_account_cancellation
> ERROR:  INSERT has more expressions than target columns
LINE 1: insert into apply_account_cancellation3 select * from   j...

错误：INSERT的表达式多于目标列                                             ^

表 apply_account_cancellation3  比 apply_account_cancellation 缺少字段。

补一下。或者换一下sql。

---

---

---

这篇关于【postgresql】ERROR: INSERT has more expressions than target columns的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---