executemany() vs copy_records_to_table() for basic insert?

[ofer-pd]

In the most general case (inserting a bunch of rows - like order items for an order), what is the difference between using executemany() vs copy_records_to_table()?

[ofer-pd]

I figured out at least one difference — copy_records_to_table() only works with a matrix of literals. If you need to use DB functions like now() or gen_random_uuid() for any columns, you have to stick with executemany().