On Mon, Jun 1, 2020 at 4:16 AM Kyle Meyer wrote:
Daniel Kraus writes:
>
> > I use ob-sql with the :dbconnection param so I don't have my username
> and password in my org file.
> > But often I don't want to use the default database from the dbconnection
> alist but
> > rather specify it explicitl
5 Mon Sep 17 00:00:00 2001
From: Stefano Rodighiero
Date: Mon, 15 Apr 2019 22:14:07 +0200
Subject: [PATCH] ORG-NEWS: Mention parameter :dbconnection for
org-babel-execute:sql
---
etc/ORG-NEWS | 4
1 file changed, 4 insertions(+)
diff --git a/etc/ORG-NEWS b/etc/ORG-NEWS
index a2e9057..79
ached
to a particular connection):
'''
(dolist (vv connect-set)
(let ((var (car vv))
(val (cadr vv)))
(set-default var (eval val
'''
regards,
s.
--
www.stefanorodighiero.net
From e810b3b4b9259b708dd37ac04339e2f7
rver")
(sql-user "stefano")
(sql-password "supersecret")))
Then it's possible to use:
#+begin_src sql :engine postgresql :dbconnection mydb
select foo, bar, baz from mytable
#+end_src
s.
--
www.stefanorodighiero.net
From 176cf648f9f38de1b9c35bf1fae06c231
