Received: from laas.laas.fr (root@laas.laas.fr [140.93.0.15])
	by hub.org (8.9.2/8.9.1) with ESMTP id EAA07917
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 24 Mar 1999 04:48:51 -0500 (EST)
	(envelope-from emarsden@laas.fr)
Received: from dukas.laas.fr (dukas [140.93.21.58])
	by laas.laas.fr (8.9.1a/8.9.1) with ESMTP id KAA07598
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 24 Mar 1999 10:48:45 +0100 (MET)
Received: (from emarsden@localhost)
	by dukas.laas.fr (8.9.1a/8.9.1) id KAA03949;
	Wed, 24 Mar 1999 10:48:43 +0100 (MET)
Sender: emarsden@dukas.laas.fr
To: pgsql-interfaces@postgreSQL.org
Subject: [ANN] pg.el -- Emacs Lisp interface for PostgreSQL
Organization: LAAS-CNRS  http://www.laas.fr/
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Eric-Conspiracy: there is no conspiracy
X-Attribution: ecm
X-URL: http://www.chez.com/emarsden/
From: Eric Marsden <emarsden@mail.dotcom.fr>
Date: 24 Mar 1999 10:48:42 +0100
Message-ID: <wziu2vbi5fp.fsf@mail.dotcom.fr>
Lines: 27
X-Mailer: Gnus v5.3/Emacs 19.34

pg.el is a socket-level interface to PostgreSQL for GNU 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,
nor the v6.4 protocol.

The code (version 0.1) is available under GPL from

   <URL:http://www.chez.com/emarsden/downloads/pg.el>


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
emarsden @ mail.dotcom.fr
It's elephants all the way down