emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Neil Cherry <ncherry@linuxha.com>
To: emacs-orgmode@gnu.org
Subject: ob-sql posgresql windows problems
Date: Wed, 14 Oct 2020 22:51:04 -0400	[thread overview]
Message-ID: <8ca746ff-f406-939f-59a0-2cd1f0dbecc3@linuxha.com> (raw)

I'm on a Windows 10 System, I'm using ob-sql.el and when I C-c C-c on the src block I

'PGPASSWORD' os mpt recognized as an internal or external command.

Example block:

#+name: My queries (Not working - 'PGPASSWORD' is not recognized as an internal or external)
#+header: :engine postgresql
#+header: :dbhost pgdb.example.com
#+header: :dbuser user
#+header: :dbpassword password
#+header: :database db
#+begin_src sql
select count(*) from db.pserver

I've tried to use an elisp block to set the SHELL to the correct bash path but it
still calls cmd.

Any suggestions to help with debugging.

Linux Home Automation         Neil Cherry       ncherry@linuxha.com
http://www.linuxha.com/                         Main site
http://linuxha.blogspot.com/                    My HA Blog
Author of:    	Linux Smart Homes For Dummies

             reply	other threads:[~2020-10-15  2:51 UTC|newest]

Thread overview: 3+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2020-10-15  2:51 Neil Cherry [this message]
2020-10-24 11:41 ` ob-sql posgresql windows problems Bastien
2020-10-26 12:00   ` Neil Cherry

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=8ca746ff-f406-939f-59a0-2cd1f0dbecc3@linuxha.com \
    --to=ncherry@linuxha.com \
    --cc=emacs-orgmode@gnu.org \


* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox


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).