How to insert values into a table with default values from a select query in PostgreSQL?
If you add all ColumnsNames (exclude the 'id' Column) after the Tablename, there will be Insert the serial automaticly like:
INSERT INTO animals(nm,typ,tvi,tvf) select nm,typ,tvi,tvf from json_po.....
You can also add a DEFAULT Value in your Column, to set a Default Value if the column is not in the Insert Column-list.