- publishing free software manuals
PostgreSQL Reference Manual - Volume 2 - Programming Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 408 pages
ISBN 0954612035
RRP £19.95 ($34.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

Index

$

  • $libdir
  • .

  • .pgpass
  • _

  • _PG_fini
  • _PG_init
  • a

  • aggregate function, user-defined
  • applicable role
  • array, of user-defined type
  • b

  • base type
  • BLOB
  • BSD/OS, shared library
  • bytea, in libpq
  • c

  • C, C
  • canceling, SQL command
  • compiling, libpq applications
  • composite type
  • computed field
  • connection service file
  • CONTINUE, in PL/pgSQL
  • COPY, with libpq
  • CTID
  • cursor, in PL/pgSQL
  • d

  • data type, base
  • data type, composite
  • data type, internal organization
  • data type, user-defined
  • DBI
  • Digital UNIX
  • dynamic loading
  • dynamic_library_path
  • e

  • ECPG
  • elog, in PL/Perl
  • elog, in PL/Python
  • elog, in PL/Tcl
  • embedded SQL, in C
  • enabled role
  • environment variable
  • error codes, libpq
  • error message
  • escaping strings, in libpq
  • exceptions, in PL/PgSQL
  • EXIT, in PL/pgSQL
  • extending SQL
  • f

  • fast path
  • field, computed
  • FreeBSD, shared library
  • function, internal
  • function, output parameter
  • function, polymorphic
  • function, user-defined
  • function, user-defined, in C
  • function, user-defined, in SQL
  • g

  • global data, in PL/Python
  • global data, in PL/Tcl
  • h

  • host name
  • HP-UX, shared library
  • i

  • IMMUTABLE
  • Index
  • index, for user-defined data type
  • information schema
  • input function
  • input function, of a data type
  • instr
  • IRIX, shared library
  • l

  • large object
  • LDAP connection parameter lookup
  • libpq
  • libpq-fe.h, libpq-fe.h
  • libpq-int.h
  • library finalization function
  • library initialization function
  • Linux, shared library
  • lo_close
  • lo_creat, lo_creat
  • lo_create, lo_create
  • lo_export, lo_export
  • lo_import, lo_import
  • lo_lseek
  • lo_open
  • lo_read
  • lo_tell
  • lo_unlink, lo_unlink
  • lo_write
  • loop, in PL/pgSQL
  • m

  • MacOS X, shared library
  • magic block
  • memory context, in SPI
  • n

  • NetBSD, shared library
  • nonblocking connection, nonblocking connection
  • notice processing, in libpq
  • notice processor
  • notice receiver
  • NOTIFY, in libpq
  • null value, in libpq
  • null value, in PL/Perl
  • null value, PL/Python
  • o

  • OID, in libpq
  • OpenBSD, shared library
  • operator class
  • operator, user-defined
  • Oracle, porting from PL/SQL to PL/pgSQL
  • ordering operator
  • output function, of a data type
  • output function
  • overloading, functions
  • overloading, operators
  • p

  • palloc
  • password file
  • Perl
  • pfree
  • pg_config, with libpq
  • pg_config, with user-defined C functions
  • pg_service.conf
  • PGcancel
  • PGCLIENTENCODING
  • PGconn
  • PGCONNECT_TIMEOUT
  • PGDATABASE
  • PGDATESTYLE
  • PGGEQO
  • PGHOST
  • PGHOSTADDR
  • PGKRBSRVNAME
  • PGLOCALEDIR
  • PGOPTIONS
  • PGPASSFILE
  • PGPASSWORD
  • PGPORT
  • PGREALM
  • PGREQUIRESSL
  • PGresult
  • PGSERVICE
  • PGSSLMODE
  • PGSYSCONFDIR
  • PGTZ
  • PGUSER
  • pgxs
  • PIC
  • PID, determining PID of server process, in libpq
  • PL/Perl
  • PL/PerlU
  • PL/pgSQL
  • PL/Python
  • PL/SQL (Oracle), porting to PL/pgSQL
  • PL/Tcl
  • polymorphic function
  • polymorphic type
  • port
  • PQbackendPID
  • PQbinaryTuples
  • PQbinaryTuples, with COPY
  • PQcancel
  • PQclear
  • PQcmdStatus
  • PQcmdTuples
  • PQconndefaults
  • PQconnectdb
  • PQconnectPoll
  • PQconnectStart
  • PQconsumeInput
  • PQdb
  • PQdescribePortal
  • PQdescribePrepared
  • PQencryptPassword
  • PQendcopy
  • PQerrorMessage
  • PQescapeBytea
  • PQescapeByteaConn
  • PQescapeString
  • PQescapeStringConn
  • PQexec
  • PQexecParams
  • PQexecPrepared
  • PQfformat
  • PQfformat, with COPY
  • PQfinish
  • PQflush
  • PQfmod
  • PQfn
  • PQfname
  • PQfnumber
  • PQfreeCancel
  • PQfreemem
  • PQfsize
  • PQftable
  • PQftablecol
  • PQftype
  • PQgetCancel
  • PQgetCopyData
  • PQgetisnull
  • PQgetlength
  • PQgetline
  • PQgetlineAsync
  • PQgetResult
  • PQgetssl
  • PQgetvalue
  • PQhost
  • PQisBusy
  • PQisnonblocking
  • PQisthreadsafe
  • PQmakeEmptyPGresult
  • PQnfields
  • PQnfields, with COPY
  • PQnotifies
  • PQnparams
  • PQntuples
  • PQoidStatus
  • PQoidValue
  • PQoptions
  • PQparameterStatus
  • PQparamtype
  • PQpass
  • PQport
  • PQprepare
  • PQprint
  • PQprotocolVersion
  • PQputCopyData
  • PQputCopyEnd
  • PQputline
  • PQputnbytes
  • PQrequestCancel
  • PQreset
  • PQresetPoll
  • PQresetStart
  • PQresStatus
  • PQresultErrorField
  • PQresultErrorMessage
  • PQresultStatus
  • PQsendDescribePortal
  • PQsendDescribePrepared
  • PQsendPrepare
  • PQsendQuery
  • PQsendQueryParams
  • PQsendQueryPrepared
  • PQserverVersion
  • PQsetdb
  • PQsetdbLogin
  • PQsetErrorVerbosity
  • PQsetnonblocking
  • PQsetNoticeProcessor
  • PQsetNoticeReceiver
  • PQsocket
  • PQstatus
  • PQtrace
  • PQtransactionStatus
  • PQtty
  • PQunescapeBytea
  • PQuntrace
  • PQuser
  • preparing a query, in PL/pgSQL
  • preparing a query, in PL/Tcl
  • preparing a query, in PL/Python
  • privilege, with rules
  • privilege, with views
  • procedural language
  • Python
  • q

  • query tree
  • quote_ident, use in PL/PgSQL
  • quote_literal, use in PL/PgSQL
  • r

  • RAISE
  • range table
  • reporting errors, in PL/PgSQL
  • RETURNING INTO, in PL/pgSQL
  • role, applicable
  • role, enabled
  • rule
  • rule, and views
  • rule, compared with triggers
  • rule, for DELETE
  • rule, for INSERT
  • rule, for SELECT
  • rule, for UPDATE
  • s

  • SELECT INTO, in PL/pgSQL
  • SETOF
  • shared library
  • shared-preload-libraries
  • Solaris, shared library
  • SPI
  • SPI_connect
  • SPI_copytuple
  • SPI_cursor_close
  • SPI_cursor_fetch
  • SPI_cursor_find
  • SPI_cursor_move
  • SPI_cursor_open
  • SPI_exec
  • spi_exec_query, in PL/Perl
  • SPI_execp
  • SPI_execute
  • SPI_execute_plan
  • SPI_finish
  • SPI_fname
  • SPI_fnumber
  • SPI_freeplan
  • SPI_freetuple
  • SPI_freetuptable
  • SPI_getargcount
  • SPI_getargtypeid
  • SPI_getbinval
  • SPI_getnspname
  • SPI_getrelname
  • SPI_gettype
  • SPI_gettypeid
  • SPI_getvalue
  • SPI_is_cursor_plan
  • spi_lastoid
  • SPI_modifytuple
  • SPI_palloc
  • SPI_pfree
  • SPI_pop
  • SPI_prepare
  • SPI_push
  • SPI_repalloc
  • SPI_returntuple
  • SPI_saveplan
  • SSL
  • SSL, in libpq
  • SSL, with libpq
  • STABLE
  • t

  • target list
  • Tcl
  • threads, with libpq
  • TOAST, and user-defined types
  • TOAST, versus large objects
  • trigger
  • trigger, arguments for trigger functions
  • trigger, compared with rules
  • trigger, in C
  • trigger, in PL/pgSQL
  • trigger, in PL/Python
  • trigger, in PL/Tcl
  • Tru64 UNIX, shared library
  • trusted, PL/Perl
  • type, polymorphic
  • u

  • Unix domain socket
  • UnixWare, shared library
  • v

  • view, implementation through rules
  • view, updating
  • VOLATILE
  • volatility, functions
  • w

  • WHILE, in PL/pgSQL

  • ISBN 0954612035PostgreSQL Reference Manual - Volume 2 - Programming GuideSee the print edition