all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
* 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 external index

	https://git.savannah.gnu.org/cgit/emacs.git
	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.