Common Lisp Package: PGSQL

This is the low-level interface to PostgreSQL.

README:

FUNCTION

Public

Undocumented

LO-CLOSE (CONN FD)

LO-CREATE (CONN MODE)

LO-LSEEK (CONN FD OFFSET WHENCE)

LO-OPEN (CONN OID MODE)

LO-READ (CONN FD DATA SIZE)

LO-WRITE (CONN FD DATA SIZE)

PQCLEAR (RES)

PQCMDSTATUS (RES)

PQCMDTUPLES (RES)

PQERRORMESSAGE (CONN)

PQEXEC (CONN QUERY)

PQFINISH (CONN)

PQFNAME (RES FIELD-NUM)

PQFNUMBER (RES FIELD-NAME)

PQFSIZE (RES FIELD-NUM)

PQFTYPE (RES FIELD-NUM)

PQGETISNULL (RES TUP-NUM FIELD-NUM)

PQGETLENGTH (RES TUP-NUM FIELD-NUM)

PQGETVALUE (RES TUP-NUM FIELD-NUM)

PQISBUSY (CONN)

PQNFIELDS (RES)

PQNTUPLES (RES)

PQOIDSTATUS (RES)

PQRESULTERRORFIELD (RES FIELD-CODE)

PQRESULTERRORMESSAGE (RES)

PQRESULTSTATUS (RES)

PQSETDBLOGIN (PGHOST PGPORT PGOPTIONS PGTTY DBNAME LOGIN PWD)

PQSTATUS (CONN)

VARIABLE

Private

*POSTGRESQL-LIBRARY-LOADED*

T if foreign library was able to be loaded successfully

*POSTGRESQL-SUPPORTING-LIBRARIES*

Used only by CMU. List of library flags needed to be passed to ld to load the PostgresSQL client library succesfully. If this differs at your site, set to the right path before compiling or loading the system.

CONSTANT

Public

Undocumented

+PG-DIAG-SQLSTATE+

PGSQL-CONN-STATUS-TYPE#CONNECTION-BAD

PGSQL-CONN-STATUS-TYPE#CONNECTION-OK

PGSQL-EXEC-STATUS-TYPE#BAD-RESPONSE

PGSQL-EXEC-STATUS-TYPE#COMMAND-OK

PGSQL-EXEC-STATUS-TYPE#COPY-IN

PGSQL-EXEC-STATUS-TYPE#COPY-OUT

PGSQL-EXEC-STATUS-TYPE#EMPTY-QUERY

PGSQL-EXEC-STATUS-TYPE#FATAL-ERROR

PGSQL-EXEC-STATUS-TYPE#NONFATAL-ERROR

PGSQL-EXEC-STATUS-TYPE#TUPLES-OK

PGSQL-FTYPE#BYTEA

PGSQL-FTYPE#FLOAT4

PGSQL-FTYPE#FLOAT8

PGSQL-FTYPE#INT2

PGSQL-FTYPE#INT4

PGSQL-FTYPE#INT8

Private

Undocumented

+INV_ARCHIVE+

+INV_READ+

+INV_WRITE+

+PG-DIAG-CONTEXT+

+PG-DIAG-INTERNAL-POSITION+

+PG-DIAG-INTERNAL-QUERY+

+PG-DIAG-MESSAGE-DETAIL+

+PG-DIAG-MESSAGE-HINT+

+PG-DIAG-MESSAGE-PRIMARY+

+PG-DIAG-SEVERITY+

+PG-DIAG-SOURCE-FILE+

+PG-DIAG-SOURCE-FUNCTION+

+PG-DIAG-SOURCE-LINE+

+PG-DIAG-STATEMENT-POSITION+