Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f48JDOA16974;
	Tue, 8 May 2001 15:13:24 -0400 (EDT)
	(envelope-from pgman@candle.pha.pa.us)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.10.1/8.10.1) id f48JDKW23838;
	Tue, 8 May 2001 15:13:20 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200105081913.f48JDKW23838@candle.pha.pa.us>
Subject: Please add LISP mention on interfaces page
To: PostgreSQL Webmaster <webmaster@postgresql.org>
Date: Tue, 8 May 2001 15:13:20 -0400 (EDT)
CC: PostgreSQL-documentation <pgsql-docs@postgresql.org>
X-Mailer: ELM [version 2.4ME+ PL90 (25)]
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary=ELM989349200-29922-4_
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200105/42
X-Sequence-Number: 725

--ELM989349200-29922-4_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Vince, please add a mention of the Emacs LISP interface at:

	http://www.chez.com/emarsden/downloads/pg.el

I have attached the SGML which contains more information.  I am removing
this file from the SGML docs because we don't ship or support this
package.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

--ELM989349200-29922-4_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain
Content-Disposition: inline; filename="/pgtop/doc/src/sgml/lisp.sgml"

<!--
$Header: /home/projects/pgsql/cvsroot/pgsql/doc/src/sgml/lisp.sgml,v 2.4 2000/12/22 21:51:58 petere Exp $
-->

 <chapter id="lisp">
  <title id="lisp-title">Lisp Programming Interface</title>

  <abstract>
   <para>
    <filename>pg.el</filename> is a socket-level interface to
    <productname>Postgres</productname> for emacs.
   </para>
  </abstract>

  <note>
   <title>Author</title>
   <para>
    Written by Eric Marsden <email>emarsden@mail.dotcom.fr</email>
    on 1999-07-21
   </para>
  </note>

  <para>
   <filename>pg.el</filename> is a socket-level interface to
   <productname>Postgres</productname> 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.
  </para>

  <para>
   The code (version 0.2) is available under GNU GPL from
   <ulink url="http://www.chez.com/emarsden/downloads/pg.el">Eric Marsden</ulink>
  </para>

  <para>
Changes since last release:

   <itemizedlist mark="bullet" spacing="compact">
    <listitem>
     <para>
      now works with XEmacs (tested with Emacs 19.34 & 20.2, and XEmacs
      20.4)
     </para>
    </listitem>

    <listitem>
     <para>
      added functions to provide database metainformation (list of
      databases, of tables, of columns)
     </para>
    </listitem>

    <listitem>
     <para>
      arguments to `pg:result' are now :keywords
     </para>
    </listitem>

    <listitem>
     <para>
      MULE-resistant
     </para>
    </listitem>

    <listitem>
     <para>
      more self-testing code
     </para>
    </listitem>
   </itemizedlist>
  </para>

  <para>
   Please note that this is a programmer's API, and doesn't provide any
   form of user interface. Example:

   <programlisting>
 (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)))
   </programlisting>
  </para>
 </chapter>

<!-- Keep this comment at the end of the file
Local variables:
mode:sgml
sgml-omittag:nil
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
sgml-parent-document:nil
sgml-default-dtd-file:"./reference.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:("/usr/lib/sgml/catalog")
sgml-local-ecat-files:nil
End:
-->

--ELM989349200-29922-4_--