postgresql_query ansible module not handling backslashes in commands

Question

when running yml file, commands containing backslash return syntax error

Is there a way of running commands using backslash?

e.g.

- name: 
  hosts: 
  tasks:
    - postgresql_query:
       ...
       path_to_script: db.sql


db.sql
...
\c db

It seems that your problem description is missing significant parts of important information. — U880D
– U880D, Commented Oct 21, 2021 at 6:36

U880D · Accepted Answer · 2021-10-21 12:06:32Z

1

According the documentation of postgresql_query there is a parameter db

- name: Run pgsql queries from script
  postgresql_query:
    db: <Name of database to connect to and run queries against>
    path_to_script: <path to a SQL script on the target machine>

with which you connect to a database and then run queries from a SQL script.

According your problem description it seems that you try to connect to a database from within a SQL script.

edited Oct 21, 2021 at 12:06

answered Oct 21, 2021 at 6:44

U880D

12.8k7 gold badges40 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgresql_query ansible module not handling backslashes in commands

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related