Skip site navigation (1) Skip section navigation (2)

[ANN] pg.el v0.2 -- Emacs Lisp interface to PostgreSQL

From: Eric Marsden <emarsden(at)mail(dot)dotcom(dot)fr>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: [ANN] pg.el v0.2 -- Emacs Lisp interface to PostgreSQL
Date: 1999-07-21 10:35:56
Message-ID: wzivhbez3w3.fsf@mail.dotcom.fr (view raw or flat)
Thread:
Lists: pgsql-interfaces
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

Responses

pgsql-interfaces by date

Next:From: PostgreSQLDate: 1999-07-21 10:57:41
Subject: Re: [INTERFACES] ResultSet....
Previous:From: Peter MountDate: 1999-07-21 06:51:21
Subject: RE: Re[2]: [INTERFACES] JDBC driver/applet question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group