I'm using the PostgresOperator to define tasks in Airflow. Today, i discovered that the PostgresSQL terminal logs such as 'raise notice' or information about number of rows affected didn't show up in the DAG's task log. It is possible to show them without using PythonOperator and launching SQL query from python?
I tried to put SQL query into $$ do block and raise some messages. I expect that this message from database terminal will be included in the task's log.