I am surprised by the level of quoting seemingly required by org-mode to pass a variable to psql in :cmdline

 

The following works:

 

#+PROPERTY: header-args:sql :engine postgresql :dbhost  my.host :database mydb :dbuser me

#+PROPERTY: header-args:sql+ :tangle no :results table :exports both

#+BEGIN_SRC sql :cmdline "-v this=\\'that\\'"

select :this as this

#+END_SRC

 

#+RESULTS:

| this |

|------|

| that |

 

 

However, I found no other quote/escape combination to work.  At first I expected to work:

 

:cmdline "-v this=\'asdf\'"

 

… but it is an error.

 

Is this expected and consistent with other emacs behavior? 

 

Is there another, perhaps simpler, way to pass variables to postgresql  code block in org ob-sql?

 

Thanks,

 

Malcolm