* How to #+BEGIN_SRC sql :engine postgresql with PostgreSQL 10.0?
@ 2018-03-01 15:33 Jean Louis
2018-03-02 2:45 ` Seb
0 siblings, 1 reply; 2+ messages in thread
From: Jean Louis @ 2018-03-01 15:33 UTC (permalink / raw)
To: emacs-orgmode
Hello,
I am using the PostgreSQL 10.0 and that means that
pg.el cannot be used anymore as it is not updated
for that database.
So, something like this below is not working
#+BEGIN_SRC sql :engine postgresql :exports results :cmdline :database business :dbuser cox
SELECT -- salesflowstages_priority AS "Priority",
salesflowstages_publicstage AS "Development Stages" --,
-- salesflowstages_description AS "Description"
FROM salesflowstages
WHERE salesflowstages_salesflows = 1 -- Start Your Own Gold Mine
ORDER BY salesflowstages_priority ASC
#+END_SRC
However, I can use the emacs-libpq module which is
working fine, but not within the Org mode.
It would be good to update Org mode so that
postgresql may work also with the version 10.0
Or point me somewhere how I can update it myself.
Thank you,
Jean
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: How to #+BEGIN_SRC sql :engine postgresql with PostgreSQL 10.0?
2018-03-01 15:33 How to #+BEGIN_SRC sql :engine postgresql with PostgreSQL 10.0? Jean Louis
@ 2018-03-02 2:45 ` Seb
0 siblings, 0 replies; 2+ messages in thread
From: Seb @ 2018-03-02 2:45 UTC (permalink / raw)
To: emacs-orgmode
On Thu, 1 Mar 2018 16:33:39 +0100,
Jean Louis <bugs@gnu.support> wrote:
> Hello, I am using the PostgreSQL 10.0 and that means that pg.el cannot
> be used anymore as it is not updated for that database.
No problems on GNU Emacs 25.2.2 (x86_64-pc-linux-gnu, GTK+ Version
3.22.28) of 2018-02-19, modified by Debian and PostgreSQL 10.2:
---<--------------------cut here---------------start------------------->---
#+PROPERTY: header-args:sql :engine postgresql
#+PROPERTY: header-args:sql+ :cmdline -p5432 :database postgres
#+BEGIN_SRC sql :exports results :results table
SELECT version();
#+END_SRC
#+RESULTS:
| version |
|--------------------------------------------------------------------------------------------------------|
| PostgreSQL 10.2 (Debian 10.2-1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 7.3.0-1) 7.3.0, 64-bit |
---<--------------------cut here---------------end--------------------->---
--
Seb
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2018-03-02 2:45 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2018-03-01 15:33 How to #+BEGIN_SRC sql :engine postgresql with PostgreSQL 10.0? Jean Louis
2018-03-02 2:45 ` Seb
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).