How to #+BEGIN_SRC sql :engine postgresql with PostgreSQL 10.0?

How to #+BEGIN_SRC sql :engine postgresql with PostgreSQL 10.0?

[Jean Louis]

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

Re: How to #+BEGIN_SRC sql :engine postgresql with PostgreSQL 10.0?

[Seb]

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