Cook

Inserting a composite type (a whole row at once)

insert into stats.daily_registration_historical (registration_date, count_registrations)
select * from app_private.daily_registration;

Insert all default values

insert into users default values

Insert multiple rows

insert into countries (code) values ('CA'), ('US'), ('FR')

Bulk insert

Imagine you need to split a table in two, and move half of the rows from the first to the second:

insert into second_table (col1, col2) select a, b from first_table;