elpa-pg

pg.el -- Emacs Lisp socket-level interface to the PostgreSQL RDBMS

Description

This module lets you access the PostgreSQL object-relational DBMS from Emacs, using its socket-level frontend/backend protocol. The module is capable of automatic type coercions from a range of SQL types to the equivalent Emacs Lisp type.

Supported features:

 - SCRAM-SHA-256 authentication (the default method since PostgreSQL
   version 14) and MD5 authentication.

 - Encrypted (TLS) connections between Emacs and the PostgreSQL
   backend.

 - Support for the SQL COPY protocol to copy preformatted data to
   PostgreSQL from an Emacs buffer.

 - Asynchronous handling of LISTEN/NOTIFY notification messages from
   PostgreSQL, allowing the implementation of publish-subscribe type
   architectures (PostgreSQL as an "event broker" or "message bus"
   and Emacs as event publisher and consumer).

 - Support for PostgreSQL's extended query syntax, that allows for
   parameterized queries to protect from SQL injection issues.

This is a low level API, and won't be useful to end users. If you're looking for a browsing/editing interface to PostgreSQL, see the PGmacs module from https://github.com/emarsden/pgmacs/.

Upload more screenshots

Please help extend the collection of screenshots. Just make a screenshot and upload it here. You don't need to register or anything.

Upload a screenshot

Hint: upload an image here from your clipboard with Ctrl-V


Homepage

https://github.com/emarsden/pg-el


Install this software package

If the package is available for the distribution you are currently using on your computer then install the software by clicking on…

Install elpa-pg