Postgresql – How can I define a variable in a SQL query saved in a jinja2 template and have it substituted with a value when the query is run by ansible?
In my ansible palybook there is a task which runs a sql query saved in a jinja2 template on my database. - hosts: "{{ hosts_list }}" gather_facts: no vars_files: - vars/main.yml - vars/my_hosts.yml - vars/target_date.yml tasks: - name: generate report…