PostgreSQL Interactive

Live, interactive development support for PostgreSQL

Features

• DB-aware autocomplete via Company
• Multi-connection autocomplete in org-mode source blocks via Company

Planned features

• Autocomplete in string literals in source code
• Interactive schema and documentation lookup
• Context-aware autocomplete
• Syntax and schema checking via Flycheck

Installation

Quelpa

(quelpa '(emacs-postgresql-interactive
          :fetcher github
          :repo "urbint/emacs-postgresql-interactive"))

DOOM Emacs

;; in packages.el
(package! emacs-postgresql-interactive
  :recipe (:fetcher github
           :repo "urbint/emacs-postgresql-interactive"
           :files ("*")))

;; in config.el
(def-package! emacs-postgresql-interactive)

Spacemacs

;; in .spacemacs (SPC+fed)
   dotspacemacs-additional-packages
    '((emacs-postgresql-interactive :location (recipe :fetcher github :repo "urbint/emacs-postgresql-interactive")))

Setup

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