ansible and postgresql - is there a way to run a .sql file against postgresql database using ansible?
<p>This is literally day one for me in evaluating ansible.  I have been asked by the team to show how ansible can be used to solve a specific problem like update 300 databases on 300 different servers... remove 2 rows of data and add 3 new ones. </p>

<p>I found some posts on stackoverflow showing how you can <strong>import</strong> a file using mysql and ansible... but I'm wondering if the same thing can be done with postgres.  i'm looking at the documentation for the ansible postgresql module and it doesn't have import state like mysql. </p>

<p><a href="http://docs.ansible.com/ansible/postgresql_db_module.html" rel="nofollow">http://docs.ansible.com/ansible/postgresql_db_module.html</a></p>

<p>vs. </p>

<p><a href="http://docs.ansible.com/ansible/mysql_db_module.html" rel="nofollow">http://docs.ansible.com/ansible/mysql_db_module.html</a></p>

<p>Any suggestions? </p>

<p>Thanks.</p>