Live, interactive development support for PostgreSQL
- DB-aware autocomplete via Company
- Multi-connection autocomplete in
org-mode
source blocks via Company
- Autocomplete in string literals in source code
- Interactive schema and documentation lookup
- Context-aware autocomplete
- Syntax and schema checking via Flycheck
(quelpa '(emacs-postgresql-interactive
:fetcher github
:repo "urbint/emacs-postgresql-interactive"))
;; in packages.el
(package! emacs-postgresql-interactive
:recipe (:fetcher github
:repo "urbint/emacs-postgresql-interactive"
:files ("*")))
;; in config.el
(def-package! emacs-postgresql-interactive)
;; in .spacemacs (SPC+fed)
dotspacemacs-additional-packages
'((emacs-postgresql-interactive :location (recipe :fetcher github :repo "urbint/emacs-postgresql-interactive")))
First you will want to require the package:
(require 'company-postgresql)
Then you will want to make sure to add the backend for company to your org-mode-hook
:
(add-to-list 'company-backends 'company-ob-postgresql)
Then make sure that you have a pgpass file with all the required fields for your target database
Should just work with ob-sql