From: Eric Marsden <emarsden@mail.dotcom.fr>
To: pgsql-interfaces@postgreSQL.org
Subject: [ANN] pg.el v0.2 -- Emacs Lisp interface to PostgreSQL
Date: 21 Jul 1999 12:35:56 +0200
Message-ID: <wzivhbez3w3.fsf@mail.dotcom.fr> (raw)
pg.el is a socket-level interface to PostgreSQL for emacs (text
editor extraordinaire). The module is capable of type coercions from a
range of SQL types to the equivalent Emacs Lisp type. It currently
supports neither crypt or Kerberos authentication, nor large objects.
The code (version 0.2) is available under GNU GPL from
<URL:http://www.chez.com/emarsden/downloads/pg.el;
Changes since last release:
* now works with XEmacs (tested with Emacs 19.34 & 20.2, and XEmacs
20.4)
* added functions to provide database metainformation (list of
databases, of tables, of columns)
* arguments to `pg:result' are now :keywords
* MULE-resistant
* more self-testing code
Please note that this is a programmer's API, and doesn't provide any
form of user interface. Example:
(defun demo ()
(interactive)
(let* ((conn (pg:connect "template1" "postgres" "postgres"))
(res (pg:exec conn "SELECT * from scshdemo WHERE a = 42")))
(message "status is %s" (pg:result res :status))
(message "metadata is %s" (pg:result res :attributes))
(message "data is %s" (pg:result res :tuples))
(pg:disconnect conn)))
--
Eric Marsden
It's elephants all the way down
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: emarsden@mail.dotcom.fr
Subject: Re: [ANN] pg.el v0.2 -- Emacs Lisp interface to PostgreSQL
In-Reply-To: <wzivhbez3w3.fsf@mail.dotcom.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox