Dear god,
In PGSQL storage, insert into the table A (column_a column_b, column_c) select column_a, column_b, column_c from table B prompt undefined column, but the columns are no problem

CodePudding user response:

Insert into table_A (column_a column_b, column_c) select column_a, column_b, column_c from table_B/* table_A, table_B is the name of the table */