What's the recommended way to insert data into a postgresql table?

You might be able to use the PostgresExecute task but if you’re trying to do a bulk insert and it doesn’t work for you, you can just wrap your own Python function into a task. Any of these will work if you have Pandas DataFrame already and are doing a bulk insert.