From mboxrd@z Thu Jan  1 00:00:00 1970
From: Jean Louis <bugs@gnu.support>
Subject: How to #+BEGIN_SRC sql :engine postgresql with PostgreSQL 10.0?
Date: Thu, 1 Mar 2018 16:33:39 +0100
Message-ID: <20180301153339.GA4735@protected.rcdrun.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:54086)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <bugs@gnu.support>) id 1erQN2-0005pN-Ss
	for emacs-orgmode@gnu.org; Thu, 01 Mar 2018 10:43:49 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <bugs@gnu.support>) id 1erQMy-0002po-0q
	for emacs-orgmode@gnu.org; Thu, 01 Mar 2018 10:43:48 -0500
Received: from stw1.rcdrun.com ([217.170.207.13]:57475 helo=static.rcdrun.com)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <bugs@gnu.support>) id 1erQMx-0002cW-PG
	for emacs-orgmode@gnu.org; Thu, 01 Mar 2018 10:43:43 -0500
Content-Disposition: inline
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode/>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: "Emacs-orgmode"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: emacs-orgmode@gnu.org

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