Re: [O] [babel] Verbatim output from SQL command

[Nick Dokos]

Viktor Rosenfeld <address@hidden> wrote:

> Hi,
> 
> Sebastien Vauban wrote:
> 
> > #+BABEL:   :engine msosql :cmdline -S <SERVER> -U <USER> -P <PASS> -d 
> > <DATABASE> -n -w 700
> 
> Where is the :engine directive documented?
> 

The only place I know of is lisp/ob-sql.el - there is support for the following 
engines currently:


,----
|                     ...
|                     ('msosql (format "osql %s -s \"\t\" -i %s -o %s"
|                                      (or cmdline "")
|                                      (org-babel-process-file-name in-file)
|                                      (org-babel-process-file-name out-file)))
|                     ('mysql (format "mysql %s < %s > %s"
|                                     (or cmdline "")
|                                   (org-babel-process-file-name in-file)
|                                   (org-babel-process-file-name out-file)))
|                   ('postgresql (format
|                                 "psql -A -P footer=off -F \"\t\"  -f %s -o %s 
%s"
|                                   (org-babel-process-file-name in-file)
|                                   (org-babel-process-file-name out-file)
|                                   (or cmdline "")))
|                     (t (error "no support for the %s sql engine" engine)))))
|                   ...
`----

Nick