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

On 21 Jul 1999, Eric Marsden wrote:

> 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.

[snip]

> 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)))

Hello Eric:

I am asking a dumb question here, so please be patient. Does this
mean that given pg.el you have to write elisp functions in order to
make use of it?

Is the "defun demo()" above an example of such a function? If I
understand correct, to use pg.el, I would write an elisp function in
emacs and then evaluate it. Have I got this right?

Hugh Lawson
Greensboro, North Carolina
hglawson(at)nr(dot)infi(dot)net