Hi folks, I have a multiline source block (a complex sql query). I'd like it to be inserted into another (shell) source block, so that I can run psql on a remote server (via ssh) and execute this query (I cannot access the database from my machine).
I came up with this: --8<---------------cut here---------------start------------->8--- #+name: sql_join #+begin_src sql SELECT ... -- complicated, multiline query; #+end_src #+name: sql_oneline #+begin_src elisp :noweb yes (replace-regexp-in-string "\n" " " " <<sql_join>>" t t) #+end_src #+begin_src sh :noweb yes :results output verbatim ssh user@host "psql connector -c '<<sql_oneline()>>'" #+end_src --8<---------------cut here---------------end--------------->8--- but it's fairly complicated. Any better ideas? TIA, -- Marcin Borkowski http://mbork.pl
