GitHub - urbint/emacs-postgresql-interactive
source link: https://github.com/urbint/emacs-postgresql-interactive
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK