From mboxrd@z Thu Jan 1 00:00:00 1970 From: Seb Subject: Re: How to #+BEGIN_SRC sql :engine postgresql with PostgreSQL 10.0? Date: Thu, 01 Mar 2018 20:45:40 -0600 Message-ID: <87k1uv9ovf.fsf@otaria.sebmel.org> References: <20180301153339.GA4735@protected.rcdrun.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:38235) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1erahm-0003O5-Pp for emacs-orgmode@gnu.org; Thu, 01 Mar 2018 21:45:55 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1erahj-0003lu-Mc for emacs-orgmode@gnu.org; Thu, 01 Mar 2018 21:45:54 -0500 Received: from [195.159.176.226] (port=39964 helo=blaine.gmane.org) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1erahj-0003l1-Ds for emacs-orgmode@gnu.org; Thu, 01 Mar 2018 21:45:51 -0500 Received: from list by blaine.gmane.org with local (Exim 4.84_2) (envelope-from ) id 1erafd-00072I-Bs for emacs-orgmode@gnu.org; Fri, 02 Mar 2018 03:43:41 +0100 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org On Thu, 1 Mar 2018 16:33:39 +0100, Jean Louis 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