[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Orgmode] [PATCH] Postgresql support for ob-sql.el
From: |
Harri Kiiskinen |
Subject: |
[Orgmode] [PATCH] Postgresql support for ob-sql.el |
Date: |
Wed, 15 Sep 2010 17:02:02 +0300 (EEST) |
The attaches patch adds support to postgresql to ob-sql.el
It achieves this in the same way the mysql support is done, by using
the psql client with suitable command line arguments.
Best,
Harri Kiiskinen
address@hidden
diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el
index 4e1daa5..2636752 100644
--- a/lisp/ob-sql.el
+++ b/lisp/ob-sql.el
@@ -66,6 +66,8 @@ This function is called by `org-babel-execute-src-block'."
(command (case (intern engine)
('mysql (format "mysql %s -e \"source %s\" > %s"
(or cmdline "") in-file out-file))
+ ('postgresql (format "psql -A -P footer=off -F \"\t\" -f
%s -o %s %s"
+ in-file out-file (or cmdline "")))
(t (error "no support for the %s sql engine" engine)))))
(with-temp-file in-file
(insert (org-babel-expand-body:sql body params)))
pgpXEzRNCQ3Im.pgp
Description: PGP signature
- [Orgmode] [PATCH] Postgresql support for ob-sql.el,
Harri Kiiskinen <=