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

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

Index

#

  • #define, with ECPG
  • #ifdef, with ECPG
  • #undef, with ECPG
  • $

  • $libdir
  • .

  • .pg_service.conf
  • .pgpass
  • _

  • _PG_fini
  • _PG_init
  • a

  • administrable_role_authorizations
  • aggregate function, user-defined
  • aliases, in PL/pgSQL
  • applicable role
  • applicable_roles
  • argument types, in PL/pgSQL
  • arguments, composite type
  • array, of user-defined type
  • assignment, in PL/pgSQL
  • asynchronous commands, libpq
  • asynchronous notification
  • attributes, in information schema
  • b

  • base type
  • base types, in C functions
  • binary large objects
  • BLOB
  • BSD/OS, shared library
  • c

  • C, C
  • C preprocessor, with ECPG
  • C++
  • C, user-defined functions
  • callbacks, with ECPG
  • calling conventions
  • canceling, SQL command
  • check_constraint_routine_usage, in information schema
  • check_constraints, in information schema
  • client library, C
  • column_domain_usage, in information schema
  • column_privileges, in information schema
  • column_udt_usage, in information schema
  • columns, in information schema
  • command execution, libpq
  • command status, with rules
  • COMMUTATOR
  • compatibility mode, Informix
  • compiling, libpq applications
  • composite type
  • composite type, arguments
  • computed field
  • conditionals, in PL/pgSQL
  • connection service file
  • connection, with ECPG
  • connection, with libpq
  • constants, with ECPG
  • constraint_column_usage, in information schema
  • constraint_table_usage, in information schema
  • CONTINUE, in PL/pgSQL
  • control functions, libpq
  • control structures, in PL/pgSQL
  • COPY, with libpq
  • copying types, in PL/pgSQL
  • cross-data-type operator classes
  • CTID
  • cursor, in PL/pgSQL
  • d

  • data type, base
  • data type, composite
  • data type, internal organization
  • data type, user-defined
  • data types, in information schema
  • data types, in PL/pgSQL
  • data values, in PL/Perl
  • data values, in PL/Tcl
  • data_type_privileges, in information schema
  • date type, with ECPG
  • decimal type, with ECPG
  • declarations, in PL/pgSQL
  • declare sections, with ECPG
  • decode_bytea, in PL/Perl
  • descriptor areas
  • Digital UNIX
  • domain_constraints, in information schema
  • domain_udt_usage, in information schema
  • domains
  • domains, in information schema
  • dynamic commands, in PL/pgSQL
  • dynamic loading, dynamic loading
  • dynamic SQL
  • dynamic_library_path
  • e

  • ECPG
  • element_types, in information schema
  • elog, in PL/Perl
  • elog, in PL/Python
  • elog, in PL/Tcl
  • embedded SQL, in C
  • enabled role
  • enabled_roles, in information schema
  • encode_array_constructor, in PL/Perl
  • encode_array_literal, in PL/Perl
  • encode_bytea, in PL/Perl
  • encryption, passwords
  • environment variable
  • errno, with ECPG
  • error codes, libpq
  • error handling, with ECPG
  • error message
  • errors, in PL/PgSQL, errors, in PL/PgSQL
  • escaping strings, in libpq
  • escaping, in PL/pgSQL
  • exceptions, in PL/PgSQL
  • execution, in PL/pgSQL
  • EXIT, in PL/pgSQL
  • expressions, in PL/pgSQL
  • extending SQL
  • f

  • fast path
  • FETCH INTO, with ECPG
  • field, computed
  • FreeBSD, shared library
  • function parameters, aliases
  • function, default values for arguments
  • function, internal
  • function, named parameter
  • function, output parameter
  • function, polymorphic
  • function, RETURNS TABLE
  • function, user-defined
  • function, user-defined, in C
  • function, user-defined, in SQL
  • function, variadic
  • function, with SETOF
  • functions, in PL/Perl
  • functions, in PL/Python
  • functions, in PL/Tcl
  • g

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

  • HASHES
  • host name
  • host variables, with ECPG
  • HP-UX, shared library
  • i

  • IMMUTABLE
  • include files, with ECPG
  • Index
  • index methods
  • index, for user-defined data type
  • indicators
  • information schema
  • information_schema_catalog_name
  • Informix, compatibility mode
  • input function
  • input function, of a data type
  • installing procedural languages
  • instr
  • internal functions
  • internals, ECPG
  • interval type, with ECPG
  • IRIX, shared library
  • j

  • JOIN
  • k

  • key_column_usage, in information schema
  • l

  • languages, procedural
  • large object
  • large objects, client interface
  • large objects, server functions
  • LDAP connection parameter lookup
  • libpq
  • libpq-fe.h, libpq-fe.h
  • libpq-int.h
  • library finalization function
  • library function, with ECPG
  • 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_import_with_oid
  • lo_lseek
  • lo_open
  • lo_read
  • lo_tell
  • lo_truncate
  • lo_unlink, lo_unlink
  • lo_write
  • looks_like_number, in PL/Perl
  • loop, in PL/pgSQL
  • LTCMP
  • LWlocks
  • m

  • MacOS X, shared library
  • magic block
  • memory context, in SPI
  • MERGES
  • modules, in PL/Tcl
  • multithreaded programs, with libpq
  • n

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

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

  • palloc
  • parameters, in information schema
  • password encryption, libpq
  • password file
  • Perl
  • pfree
  • pg_config, with libpq
  • pg_config, with user-defined C functions
  • pg_service.conf
  • PGAPPNAME
  • PGcancel
  • PGCLIENTENCODING
  • PGconn
  • PGCONNECT_TIMEOUT
  • PGDATABASE
  • PGDATESTYLE
  • PGEventProc
  • PGGEQO
  • PGGSSLIB
  • PGHOST
  • PGHOSTADDR
  • PGKRBSRVNAME
  • PGLOCALEDIR
  • PGOPTIONS
  • PGPASSFILE
  • PGPASSWORD
  • PGPORT
  • PGREALM
  • PGREQUIRESSL
  • PGresult
  • PGSERVICE
  • PGSERVICEFILE
  • PGSSLCERT
  • PGSSLCRL
  • PGSSLKEY
  • PGSSLMODE
  • PGSSLROOTCERT
  • PGSYSCONFDIR
  • pgtypes
  • 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
  • plperl.on_init configuration parameter
  • plperl.on_plperl_init configuration parameter
  • plperl.on_plperlu_init configuration parameter
  • plperl.use_strict configuration parameter
  • plpgsql.variable_conflict configuration parameter
  • polymorphic arguments
  • polymorphic function, polymorphic function
  • polymorphic type
  • port
  • PQbackendPID
  • PQbinaryTuples
  • PQbinaryTuples, with COPY
  • PQcancel
  • PQclear
  • PQclientEncoding
  • PQcmdStatus
  • PQcmdTuples
  • PQconndefaults
  • PQconnectdb
  • PQconnectdbParams
  • PQconnectionNeedsPassword
  • PQconnectionUsedPassword
  • PQconnectPoll
  • PQconnectStart
  • PQconnectStartParams
  • PQconninfoFree
  • PQconninfoParse
  • PQconsumeInput
  • PQcopyResult
  • PQdb
  • PQdescribePortal
  • PQdescribePrepared
  • PQencryptPassword
  • PQendcopy
  • PQerrorMessage
  • PQescapeBytea
  • PQescapeByteaConn
  • PQescapeIdentifier
  • PQescapeLiteral
  • PQescapeString
  • PQescapeStringConn
  • PQexec
  • PQexecParams
  • PQexecPrepared
  • PQfformat
  • PQfformat, with COPY
  • PQfinish
  • PQfireResultCreateEvents
  • PQflush
  • PQfmod
  • PQfn
  • PQfname
  • PQfnumber
  • PQfreeCancel
  • PQfreemem
  • PQfsize
  • PQftable
  • PQftablecol
  • PQftype
  • PQgetCancel
  • PQgetCopyData
  • PQgetisnull
  • PQgetlength
  • PQgetline
  • PQgetlineAsync
  • PQgetResult
  • PQgetssl
  • PQgetvalue
  • PQhost
  • PQinitOpenSSL
  • PQinitSSL
  • PQinstanceData
  • 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
  • PQregisterEventProc
  • PQrequestCancel
  • PQreset
  • PQresetPoll
  • PQresetStart
  • PQresStatus
  • PQresultAlloc
  • PQresultErrorField
  • PQresultErrorMessage
  • PQresultInstanceData
  • PQresultSetInstanceData
  • PQresultStatus
  • PQsendDescribePortal
  • PQsendDescribePrepared
  • PQsendPrepare
  • PQsendQuery
  • PQsendQueryParams
  • PQsendQueryPrepared
  • PQserverVersion
  • PQsetClientEncoding
  • PQsetdb
  • PQsetdbLogin
  • PQsetErrorVerbosity
  • PQsetInstanceData
  • PQsetnonblocking
  • PQsetNoticeProcessor
  • PQsetNoticeReceiver
  • PQsetResultAttrs
  • PQsetvalue
  • 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
  • preprocessor, with ECPG
  • privilege, with rules
  • privilege, with views
  • procedural language
  • procedural language functions
  • procedure names, in PL/Tcl
  • pseudo-types
  • Python
  • q

  • queries, in PL/Perl
  • queries, in PL/pgSQL
  • queries, in PL/Python
  • queries, in PL/Tcl
  • query tree
  • quote_ident, in PL/Perl
  • quote_ident, use in PL/PgSQL
  • quote_literal, in PL/Perl
  • quote_literal, use in PL/PgSQL
  • quote_nullable, in PL/Perl
  • quote_nullable, use in PL/PgSQL
  • quotes, in PL/pgSQL
  • r

  • RAISE
  • range table
  • receiving COPY data
  • record types, in PL/pgSQL
  • referential_constraints, in information schema
  • reporting errors, in PL/PgSQL
  • RESTRICT
  • result status, in PL/pgSQL
  • result types, in PL/pgSQL
  • retrieving results, libpq
  • RETURN NEXT, in PL/PgSQL
  • RETURN QUERY, in PL/PgSQL
  • RETURNING INTO, in PL/pgSQL
  • returning, from function in PL/pgSQL
  • role, applicable
  • role, enabled
  • role_column_grants, in information schema
  • role_routine_grants, in information schema
  • role_table_grants, in information schema
  • role_usage_grants, in information schema
  • routine_privileges, in information schema
  • routines, in information schema
  • row types, in PL/pgSQL
  • rows, returning
  • rule
  • rule, and views
  • rule, compared with triggers
  • rule, for DELETE
  • rule, for INSERT
  • rule, for SELECT
  • rule, for UPDATE
  • s

  • schemata, in information schema
  • SELECT INTO, in PL/pgSQL
  • SELECT INTO, with ECPG
  • sending COPY data
  • sequences, in information schema
  • server programming interface (SPI)
  • sets
  • sets, returning
  • shared library, shared library
  • shared memory
  • shared_preload_libraries
  • Solaris, shared library
  • SORT1, SORT2
  • SPI
  • SPI_connect
  • SPI_copytuple
  • SPI_cursor_close
  • spi_cursor_close, in PL/Perl
  • SPI_cursor_fetch
  • SPI_cursor_find
  • SPI_cursor_move
  • SPI_cursor_open
  • SPI_cursor_open_with_args
  • SPI_cursor_open_with_paramlist
  • SPI_exec
  • spi_exec_prepared, in PL/Perl
  • spi_exec_query, in PL/Perl
  • SPI_execp
  • SPI_execute
  • SPI_execute_plan
  • SPI_execute_plan_with_paramlist
  • SPI_execute_with_args
  • spi_fetchrow, in PL/Perl
  • SPI_finish
  • SPI_fname
  • SPI_fnumber
  • SPI_freeplan
  • spi_freeplan, in PL/Perl
  • 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_prepare, in PL/Perl
  • SPI_prepare_cursor
  • SPI_prepare_params
  • SPI_push
  • spi_query, in PL/Perl
  • spi_query_prepared, in PL/Perl
  • SPI_repalloc
  • SPI_returntuple
  • SPI_saveplan
  • SPI_scroll_cursor_fetch
  • SPI_scroll_cursor_move
  • SQL Procedural Language, PL/pgSQL
  • sql_features, in information schema
  • sql_implementation_info, in information schema
  • sql_languages, in information schema
  • sql_packages, in information schema
  • sql_parts, in information schema
  • sql_sizing, in information schema
  • sql_sizing_profiles, in information schema
  • sqlca
  • SQLCODE
  • SQLSTATE
  • SSL
  • SSL, in libpq
  • SSL, with libpq
  • STABLE
  • statements, in PL/pgSQL
  • status, in PL/pgSQL
  • status, libpq
  • status, of connection
  • status, with rules
  • strategies, index methods
  • support routines, index methods
  • t

  • table sources
  • table_constraints, in information schema
  • table_privileges, in information schema
  • tables, in information schema
  • target list
  • Tcl
  • threads, with libpq
  • timestamp type, with ECPG
  • TOAST, and user-defined types
  • TOAST, versus large objects
  • tracing, libpq
  • trigger
  • trigger, arguments for trigger functions
  • trigger, compared with rules
  • trigger, in C
  • trigger, in PL/Perl
  • trigger, in PL/pgSQL
  • trigger, in PL/Python
  • trigger, in PL/Tcl
  • triggers, in information schema
  • Tru64 UNIX, shared library
  • trusted, PL/Perl
  • type system
  • type, polymorphic
  • u

  • Unix domain socket
  • UnixWare, shared library
  • update rules, explanation
  • usage_privileges, in information schema
  • user-defined aggregates
  • user-defined functions
  • user-defined operators
  • user-defined types
  • v

  • variadic function
  • verbosity, libpq
  • version 0, calling convention
  • version 1, calling convention
  • view rules in Non-SELECT Statements
  • view, implementation through rules
  • view, updating, view, updating
  • view_column_usage, in information schema
  • view_routine_usage, in information schema
  • view_table_usage, in information schema
  • views, in information schema
  • visibility, in server programming interface
  • visibility, in triggers
  • VOLATILE
  • volatility, functions
  • w

  • WHILE, in PL/pgSQL

  • ISBN 9781906966065The PostgreSQL 9.0 Reference Manual - Volume 2 - Programming GuideSee the print edition