# query psql

**URL:** <https://forum.ansible.com/t/query-psql/30350>\
**Category:** Ansible Project\
**Created:** [May 16, 2019, 2:47pm UTC](https://forum.ansible.com/t/query-psql/30350 "2019-05-16T14:47:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Oxs](https://avatars.discourse-cdn.com/v4/letter/o/ebca7d/32.png) [@Oxs](https://forum.ansible.com/u/Oxs)\
**Post date:** [May 16, 2019, 2:47pm UTC](https://forum.ansible.com/t/query-psql/30350/1 "2019-05-16T14:47:29Z")

</div>

Hi Guys

I want to use a SQL query in PostgreSQL Database with ansible and a varibale which is call db\_name.  
I have the result with my varibale.  
My problem is I don’t know how interpret ’ ’ command in ansible with my variable

My simple query works fine:

-bash-4.2$ psql -c “SELECT pg\_terminate\_backend(pid) FROM pg\_stat\_activity WHERE datname = ‘vro03’;”  
pg\_terminate\_backend

---

<div class="post-metadata">

**Author:** ![Oxs](https://avatars.discourse-cdn.com/v4/letter/o/ebca7d/32.png) [@Oxs](https://forum.ansible.com/u/Oxs)\
**Post date:** [May 17, 2019, 8:54am UTC](https://forum.ansible.com/t/query-psql/30350/2 "2019-05-17T08:54:11Z")

</div>

Any feedback about my error?

---

<div class="post-metadata">

**Author:** ![racke](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/racke/32/4767_2.png) [@racke](https://forum.ansible.com/u/racke)\
**Post date:** [May 17, 2019, 9:02am UTC](https://forum.ansible.com/t/query-psql/30350/3 "2019-05-17T09:02:51Z")

</div>

> Any feedback about my error?

The quotes are missing around vro03 when you execute it with Ansible.

BTW: Ansible 2.8. comes with a postgresql\_query module.

Regards  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Racke