<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Index</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 8.0.11 Documentation" HREF="index.html"><LINK REL="PREVIOUS" TITLE="Bibliography" HREF="biblio.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" CONTENT="2007-02-02T03:57:22"></HEAD ><BODY CLASS="INDEX" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="5" ALIGN="center" VALIGN="bottom" >PostgreSQL 8.0.11 Documentation</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="biblio.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="biblio.html" >Fast Backward</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="top" > </TD ><TD WIDTH="10%" ALIGN="right" VALIGN="top" > </TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="INDEX" ><H1 ><A NAME="BOOKINDEX" ></A >Index</H1 ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN75833" >Symbols</A ></H2 ><DL ><DT >$, <A HREF="sql-expressions.html#AEN1609" >Positional Parameters</A > </DT ><DT >$libdir, <A HREF="xfunc-c.html#XFUNC-C-DYNLOAD" >Dynamic Loading</A > </DT ><DT >*, <A HREF="queries-select-lists.html#QUERIES-SELECT-LIST-ITEMS" >Select-List Items</A > </DT ><DT >.pgpass, <A HREF="libpq-pgpass.html" >The Password File</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN75847" >A</A ></H2 ><DL ><DT >ABORT, <A HREF="sql-abort.html" >ABORT</A > </DT ><DT >add_missing_from configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-VERSION" >Previous PostgreSQL Versions</A > </DT ><DT >aggregate function, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DD ><DL ><DT >built-in, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >invocation, <A HREF="sql-expressions.html#SYNTAX-AGGREGATES" >Aggregate Expressions</A > </DT ><DD ><DL ></DL ></DD ><DT >user-defined, <A HREF="xaggr.html" >User-Defined Aggregates</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >AIX </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >alias </DT ><DD ><DL ><DT >for table name in query, <A HREF="tutorial-join.html" >Joins Between Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >in the FROM clause, <A HREF="queries-table-expressions.html#QUERIES-TABLE-ALIASES" >Table and Column Aliases</A > </DT ><DD ><DL ></DL ></DD ><DT >in the select list, <A HREF="queries-select-lists.html#QUERIES-COLUMN-LABELS" >Column Labels</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >ALL, <A HREF="functions-subquery.html" >Subquery Expressions</A >, <A HREF="functions-comparisons.html" >Row and Array Comparisons</A > </DT ><DT >ALTER AGGREGATE, <A HREF="sql-alteraggregate.html" >ALTER AGGREGATE</A > </DT ><DT >ALTER CONVERSION, <A HREF="sql-alterconversion.html" >ALTER CONVERSION</A > </DT ><DT >ALTER DATABASE, <A HREF="sql-alterdatabase.html" >ALTER DATABASE</A > </DT ><DT >ALTER DOMAIN, <A HREF="sql-alterdomain.html" >ALTER DOMAIN</A > </DT ><DT >ALTER FUNCTION, <A HREF="sql-alterfunction.html" >ALTER FUNCTION</A > </DT ><DT >ALTER GROUP, <A HREF="sql-altergroup.html" >ALTER GROUP</A > </DT ><DT >ALTER INDEX, <A HREF="sql-alterindex.html" >ALTER INDEX</A > </DT ><DT >ALTER LANGUAGE, <A HREF="sql-alterlanguage.html" >ALTER LANGUAGE</A > </DT ><DT >ALTER OPERATOR, <A HREF="sql-alteroperator.html" >ALTER OPERATOR</A > </DT ><DT >ALTER OPERATOR CLASS, <A HREF="sql-alteropclass.html" >ALTER OPERATOR CLASS</A > </DT ><DT >ALTER SCHEMA, <A HREF="sql-alterschema.html" >ALTER SCHEMA</A > </DT ><DT >ALTER SEQUENCE, <A HREF="sql-altersequence.html" >ALTER SEQUENCE</A > </DT ><DT >ALTER TABLE, <A HREF="sql-altertable.html" >ALTER TABLE</A > </DT ><DT >ALTER TABLESPACE, <A HREF="sql-altertablespace.html" >ALTER TABLESPACE</A > </DT ><DT >ALTER TRIGGER, <A HREF="sql-altertrigger.html" >ALTER TRIGGER</A > </DT ><DT >ALTER TYPE, <A HREF="sql-altertype.html" >ALTER TYPE</A > </DT ><DT >ALTER USER, <A HREF="user-attributes.html" >User Attributes</A >, <A HREF="sql-alteruser.html" >ALTER USER</A > </DT ><DT >ANALYZE, <A HREF="maintenance.html#VACUUM-FOR-STATISTICS" >Updating planner statistics</A >, <A HREF="sql-analyze.html" >ANALYZE</A > </DT ><DT >AND (operator), <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DT >any, <A HREF="datatype-pseudo.html" >Pseudo-Types</A >, <A HREF="functions-aggregate.html" >Aggregate Functions</A >, <A HREF="functions-subquery.html" >Subquery Expressions</A >, <A HREF="functions-comparisons.html" >Row and Array Comparisons</A > </DT ><DT >anyarray, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >anyelement, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >archive_command configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-WAL-ARCHIVING" >Archiving</A > </DT ><DT >ARRAY, <A HREF="sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS" >Array Constructors</A >, <A HREF="arrays.html" >Arrays</A > </DT ><DD ><DL ><DT >constant, <A HREF="arrays.html#AEN5389" >Array Value Input</A > </DT ><DD ><DL ></DL ></DD ><DT >constructor, <A HREF="sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS" >Array Constructors</A > </DT ><DD ><DL ></DL ></DD ><DT >determination of result type, <A HREF="typeconv-union-case.html" >UNION, CASE, and ARRAY Constructs</A > </DT ><DD ><DL ></DL ></DD ><DT >of user-defined type, <A HREF="xtypes.html" >User-Defined Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >australian_timezones configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DT >authentication_timeout configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SECURITY" >Security and Authentication</A > </DT ><DT >auto-increment </DT ><DD ><DL ><DT >see serial</DT ></DL ></DD ><DT >autocommit </DT ><DD ><DL ><DT >bulk-loading data, <A HREF="populate.html#DISABLE-AUTOCOMMIT" >Disable Autocommit</A > </DT ><DD ><DL ></DL ></DD ><DT >psql, <A HREF="app-psql.html#APP-PSQL-VARIABLES" >Variables</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >average, <A HREF="tutorial-agg.html" >Aggregate Functions</A >, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN75985" >B</A ></H2 ><DL ><DT >B-tree </DT ><DD ><DL ><DT >see index</DT ></DL ></DD ><DT >backslash_quote configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-VERSION" >Previous PostgreSQL Versions</A > </DT ><DT >backup, <A HREF="functions-admin.html" >System Administration Functions</A >, <A HREF="backup.html" >Backup and Restore</A > </DT ><DT >base type, <A HREF="extend-type-system.html" >The PostgreSQL Type System</A > </DT ><DT >BEGIN, <A HREF="sql-begin.html" >BEGIN</A > </DT ><DT >BETWEEN, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DT >bgwriter_delay configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER" >Background Writer</A > </DT ><DT >bgwriter_maxpages configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER" >Background Writer</A > </DT ><DT >bgwriter_percent configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER" >Background Writer</A > </DT ><DT >bigint, <A HREF="sql-syntax.html#AEN1246" >Numeric Constants</A >, <A HREF="datatype.html#DATATYPE-INT" >Integer Types</A > </DT ><DT >bigserial, <A HREF="datatype.html#DATATYPE-SERIAL" >Serial Types</A > </DT ><DT >binary data, <A HREF="datatype-binary.html" >Binary Data Types</A > </DT ><DD ><DL ><DT >functions, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >binary string </DT ><DD ><DL ><DT >concatenation, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DD ><DL ></DL ></DD ><DT >length, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >bison, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >bit string </DT ><DD ><DL ><DT >constant, <A HREF="sql-syntax.html#SQL-SYNTAX-BIT-STRINGS" >Bit-String Constants</A > </DT ><DD ><DL ></DL ></DD ><DT >data type, <A HREF="datatype-bit.html" >Bit String Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >bit strings </DT ><DD ><DL ><DT >functions, <A HREF="functions-bitstring.html" >Bit String Functions and Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >bit_and, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DT >bit_or, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DT >BLOB </DT ><DD ><DL ><DT >see large object</DT ></DL ></DD ><DT >block_size configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-PRESET" >Preset Options</A > </DT ><DT >Boolean </DT ><DD ><DL ><DT >data type, <A HREF="datatype-boolean.html" >Boolean Type</A > </DT ><DD ><DL ></DL ></DD ><DT >operators </DT ><DD ><DL ><DT >see operators, logical</DT ></DL ></DD ></DL ></DD ><DT >bool_and, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DT >bool_or, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DT >booting </DT ><DD ><DL ><DT >starting the server during, <A HREF="postmaster-start.html" >Starting the Database Server</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >box (data type), <A HREF="datatype-geometric.html#AEN5026" >Boxes</A > </DT ><DT >BSD/OS </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >bytea, <A HREF="datatype-binary.html" >Binary Data Types</A > </DT ><DD ><DL ><DT >in libpq, <A HREF="libpq-exec.html#LIBPQ-EXEC-ESCAPE-BYTEA" >Escaping Binary Strings for Inclusion in SQL Commands</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN76088" >C</A ></H2 ><DL ><DT >C, <A HREF="libpq.html" >libpq - C Library</A >, <A HREF="ecpg.html" >ECPG - Embedded SQL in C</A > </DT ><DT >canceling </DT ><DD ><DL ><DT >SQL command, <A HREF="libpq-cancel.html" >Cancelling Queries in Progress</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >CASCADE </DT ><DD ><DL ><DT >with DROP, <A HREF="ddl-depend.html" >Dependency Tracking</A > </DT ><DD ><DL ></DL ></DD ><DT >foreign key action, <A HREF="ddl-constraints.html#DDL-CONSTRAINTS-FK" >Foreign Keys</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >CASE, <A HREF="functions-conditional.html" >Conditional Expressions</A > </DT ><DD ><DL ><DT >determination of result type, <A HREF="typeconv-union-case.html" >UNION, CASE, and ARRAY Constructs</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >case sensitivity </DT ><DD ><DL ><DT >of SQL commands, <A HREF="sql-syntax.html#SQL-SYNTAX-IDENTIFIERS" >Identifiers and Key Words</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >char, <A HREF="datatype-character.html" >Character Types</A > </DT ><DT >character, <A HREF="datatype-character.html" >Character Types</A > </DT ><DT >character set, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A >, <A HREF="runtime-config.html#RUNTIME-CONFIG-PRESET" >Preset Options</A >, <A HREF="multibyte.html" >Character Set Support</A > </DT ><DT >character string </DT ><DD ><DL ><DT >concatenation, <A HREF="functions-string.html" >String Functions and Operators</A > </DT ><DD ><DL ></DL ></DD ><DT >constant, <A HREF="sql-syntax.html#SQL-SYNTAX-STRINGS" >String Constants</A > </DT ><DD ><DL ></DL ></DD ><DT >data types, <A HREF="datatype-character.html" >Character Types</A > </DT ><DD ><DL ></DL ></DD ><DT >length, <A HREF="functions-string.html" >String Functions and Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >character varying, <A HREF="datatype-character.html" >Character Types</A > </DT ><DT >check constraint, <A HREF="ddl-constraints.html#AEN1936" >Check Constraints</A > </DT ><DT >checkpoint, <A HREF="wal-configuration.html" >WAL Configuration</A >, <A HREF="sql-checkpoint.html" >CHECKPOINT</A > </DT ><DT >checkpoint_segments configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-WAL-CHECKPOINTS" >Checkpoints</A > </DT ><DT >checkpoint_timeout configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-WAL-CHECKPOINTS" >Checkpoints</A > </DT ><DT >checkpoint_warning configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-WAL-CHECKPOINTS" >Checkpoints</A > </DT ><DT >check_function_bodies configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A > </DT ><DT >cid, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >cidr, <A HREF="datatype-net-types.html#DATATYPE-CIDR" >cidr</A > </DT ><DT >circle, <A HREF="datatype-geometric.html#AEN5112" >Circles</A > </DT ><DT >client authentication, <A HREF="client-authentication.html" >Client Authentication</A > </DT ><DD ><DL ><DT >timeout during, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SECURITY" >Security and Authentication</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >client_encoding configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DT >client_min_messages configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHEN" >When To Log</A > </DT ><DT >CLOSE, <A HREF="sql-close.html" >CLOSE</A > </DT ><DT >CLUSTER, <A HREF="sql-cluster.html" >CLUSTER</A > </DT ><DD ><DL ><DT >of databases </DT ><DD ><DL ><DT >see database cluster</DT ></DL ></DD ></DL ></DD ><DT >clusterdb, <A HREF="app-clusterdb.html" >clusterdb</A > </DT ><DT >cmax, <A HREF="ddl-system-columns.html" >System Columns</A > </DT ><DT >cmin, <A HREF="ddl-system-columns.html" >System Columns</A > </DT ><DT >COALESCE, <A HREF="functions-conditional.html#AEN12058" >COALESCE</A > </DT ><DT >column, <A HREF="tutorial-concepts.html" >Concepts</A >, <A HREF="ddl.html#DDL-BASICS" >Table Basics</A > </DT ><DD ><DL ><DT >adding, <A HREF="ddl-alter.html#AEN2275" >Adding a Column</A > </DT ><DD ><DL ></DL ></DD ><DT >removing, <A HREF="ddl-alter.html#AEN2287" >Removing a Column</A > </DT ><DD ><DL ></DL ></DD ><DT >renaming, <A HREF="ddl-alter.html#AEN2342" >Renaming a Column</A > </DT ><DD ><DL ></DL ></DD ><DT >system column, <A HREF="ddl-system-columns.html" >System Columns</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >column data type </DT ><DD ><DL ><DT >changing, <A HREF="ddl-alter.html#AEN2332" >Changing a Column's Data Type</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >column reference, <A HREF="sql-expressions.html#AEN1593" >Column References</A > </DT ><DT >col_description, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >COMMENT, <A HREF="sql-comment.html" >COMMENT</A > </DT ><DD ><DL ><DT >about database objects, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >in SQL, <A HREF="sql-syntax.html#SQL-SYNTAX-COMMENTS" >Comments</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >COMMIT, <A HREF="sql-commit.html" >COMMIT</A > </DT ><DT >commit_delay configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-WAL-SETTINGS" >Settings</A > </DT ><DT >commit_siblings configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-WAL-SETTINGS" >Settings</A > </DT ><DT >comparison </DT ><DD ><DL ><DT >operators, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DD ><DL ></DL ></DD ><DT >row-wise, <A HREF="functions-comparisons.html" >Row and Array Comparisons</A > </DT ><DD ><DL ></DL ></DD ><DT >subquery result row, <A HREF="functions-subquery.html" >Subquery Expressions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >compiling </DT ><DD ><DL ><DT >libpq applications, <A HREF="libpq-build.html" >Building libpq Programs</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >composite type, <A HREF="rowtypes.html" >Composite Types</A >, <A HREF="extend-type-system.html" >The PostgreSQL Type System</A > </DT ><DD ><DL ><DT >constant, <A HREF="rowtypes.html#AEN5561" >Composite Value Input</A > </DT ><DD ><DL ></DL ></DD ><DT >constructor, <A HREF="sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS" >Row Constructors</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >computed field, <A HREF="xfunc-sql.html#AEN29579" >SQL Functions on Composite Types</A > </DT ><DT >concurrency, <A HREF="mvcc.html" >Concurrency Control</A > </DT ><DT >conditional expression, <A HREF="functions-conditional.html" >Conditional Expressions</A > </DT ><DT >configuration </DT ><DD ><DL ><DT >of the server, <A HREF="runtime-config.html" >Run-time Configuration</A > </DT ><DD ><DL ></DL ></DD ><DT >of the server </DT ><DD ><DL ><DT >functions, <A HREF="functions-admin.html" >System Administration Functions</A > </DT ></DL ></DD ></DL ></DD ><DT >configure, <A HREF="install-procedure.html" >Installation Procedure</A > </DT ><DT >config_file configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-FILE-LOCATIONS" >File Locations</A > </DT ><DT >conjunction, <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DT >constant, <A HREF="sql-syntax.html#SQL-SYNTAX-CONSTANTS" >Constants</A > </DT ><DT >constraint, <A HREF="ddl-constraints.html" >Constraints</A > </DT ><DD ><DL ><DT >adding, <A HREF="ddl-alter.html#AEN2298" >Adding a Constraint</A > </DT ><DD ><DL ></DL ></DD ><DT >check, <A HREF="ddl-constraints.html#AEN1936" >Check Constraints</A > </DT ><DD ><DL ></DL ></DD ><DT >foreign key, <A HREF="ddl-constraints.html#DDL-CONSTRAINTS-FK" >Foreign Keys</A > </DT ><DD ><DL ></DL ></DD ><DT >name, <A HREF="ddl-constraints.html#AEN1936" >Check Constraints</A > </DT ><DD ><DL ></DL ></DD ><DT >NOT NULL, <A HREF="ddl-constraints.html#AEN1970" >Not-Null Constraints</A > </DT ><DD ><DL ></DL ></DD ><DT >primary key, <A HREF="ddl-constraints.html#AEN2018" >Primary Keys</A > </DT ><DD ><DL ></DL ></DD ><DT >removing, <A HREF="ddl-alter.html#AEN2307" >Removing a Constraint</A > </DT ><DD ><DL ></DL ></DD ><DT >unique, <A HREF="ddl-constraints.html#AEN1996" >Unique Constraints</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >COPY, <A HREF="tutorial-populate.html" >Populating a Table With Rows</A >, <A HREF="sql-copy.html" >COPY</A > </DT ><DD ><DL ><DT >with libpq, <A HREF="libpq-copy.html" >Functions Associated with the COPY Command</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >count, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >cpu_index_tuple_cost configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-CONSTANTS" > Planner Cost Constants </A > </DT ><DT >cpu_operator_cost configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-CONSTANTS" > Planner Cost Constants </A > </DT ><DT >cpu_tuple_cost configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-CONSTANTS" > Planner Cost Constants </A > </DT ><DT >CREATE DATABASE, <A HREF="manage-ag-createdb.html" >Creating a Database</A > </DT ><DT >CREATE AGGREGATE, <A HREF="sql-createaggregate.html" >CREATE AGGREGATE</A > </DT ><DT >CREATE CAST, <A HREF="sql-createcast.html" >CREATE CAST</A > </DT ><DT >CREATE CONSTRAINT, <A HREF="sql-createconstraint.html" >CREATE CONSTRAINT TRIGGER</A > </DT ><DT >CREATE CONVERSION, <A HREF="sql-createconversion.html" >CREATE CONVERSION</A > </DT ><DT >CREATE DATABASE, <A HREF="sql-createdatabase.html" >CREATE DATABASE</A > </DT ><DT >CREATE DOMAIN, <A HREF="sql-createdomain.html" >CREATE DOMAIN</A > </DT ><DT >CREATE FUNCTION, <A HREF="sql-createfunction.html" >CREATE FUNCTION</A > </DT ><DT >CREATE GROUP, <A HREF="sql-creategroup.html" >CREATE GROUP</A > </DT ><DT >CREATE INDEX, <A HREF="sql-createindex.html" >CREATE INDEX</A > </DT ><DT >CREATE LANGUAGE, <A HREF="sql-createlanguage.html" >CREATE LANGUAGE</A > </DT ><DT >CREATE OPERATOR, <A HREF="sql-createoperator.html" >CREATE OPERATOR</A > </DT ><DT >CREATE OPERATOR CLASS, <A HREF="sql-createopclass.html" >CREATE OPERATOR CLASS</A > </DT ><DT >CREATE RULE, <A HREF="sql-createrule.html" >CREATE RULE</A > </DT ><DT >CREATE SCHEMA, <A HREF="sql-createschema.html" >CREATE SCHEMA</A > </DT ><DT >CREATE SEQUENCE, <A HREF="sql-createsequence.html" >CREATE SEQUENCE</A > </DT ><DT >CREATE TABLE, <A HREF="tutorial-table.html" >Creating a New Table</A >, <A HREF="sql-createtable.html" >CREATE TABLE</A > </DT ><DT >CREATE TABLE AS, <A HREF="sql-createtableas.html" >CREATE TABLE AS</A > </DT ><DT >CREATE TABLESPACE, <A HREF="manage-ag-tablespaces.html" >Tablespaces</A >, <A HREF="sql-createtablespace.html" >CREATE TABLESPACE</A > </DT ><DT >CREATE TRIGGER, <A HREF="sql-createtrigger.html" >CREATE TRIGGER</A > </DT ><DT >CREATE TYPE, <A HREF="sql-createtype.html" >CREATE TYPE</A > </DT ><DT >CREATE USER, <A HREF="user-manag.html#DATABASE-USERS" >Database Users</A >, <A HREF="sql-createuser.html" >CREATE USER</A > </DT ><DT >CREATE VIEW, <A HREF="sql-createview.html" >CREATE VIEW</A > </DT ><DT >createdb, <A HREF="tutorial-createdb.html" >Creating a Database</A >, <A HREF="manage-ag-createdb.html" >Creating a Database</A >, <A HREF="app-createdb.html" >createdb</A > </DT ><DT >createlang, <A HREF="app-createlang.html" >createlang</A > </DT ><DT >createuser, <A HREF="user-manag.html#DATABASE-USERS" >Database Users</A >, <A HREF="app-createuser.html" >createuser</A > </DT ><DT >cross join, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DT >crypt, <A HREF="auth-methods.html#AUTH-PASSWORD" >Password authentication</A > </DT ><DD ><DL ><DT >thread safety, <A HREF="libpq-threading.html" >Behavior in Threaded Programs</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >cstring, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >ctid, <A HREF="ddl-system-columns.html" >System Columns</A >, <A HREF="rules-views.html#AEN31828" >View Rules in Non-SELECT Statements</A > </DT ><DT >currval, <A HREF="functions-sequence.html" >Sequence Manipulation Functions</A > </DT ><DT >cursor </DT ><DD ><DL ><DT >CLOSE, <A HREF="sql-close.html" >CLOSE</A > </DT ><DD ><DL ></DL ></DD ><DT >DECLARE, <A HREF="sql-declare.html" >DECLARE</A > </DT ><DD ><DL ></DL ></DD ><DT >FETCH, <A HREF="sql-fetch.html" >FETCH</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/pgSQL, <A HREF="plpgsql-cursors.html" >Cursors</A > </DT ><DD ><DL ></DL ></DD ><DT >MOVE, <A HREF="sql-move.html" >MOVE</A > </DT ><DD ><DL ></DL ></DD ><DT >showing the query plan, <A HREF="sql-explain.html" >EXPLAIN</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >custom_variable_classes configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CUSTOM" >Customized Options</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN76438" >D</A ></H2 ><DL ><DT >data area </DT ><DD ><DL ><DT >see database cluster</DT ></DL ></DD ><DT >data type, <A HREF="datatype.html" >Data Types</A > </DT ><DD ><DL ><DT >base, <A HREF="extend-type-system.html" >The PostgreSQL Type System</A > </DT ><DD ><DL ></DL ></DD ><DT >category, <A HREF="typeconv.html#TYPECONV-OVERVIEW" >Overview</A > </DT ><DD ><DL ></DL ></DD ><DT >composite, <A HREF="extend-type-system.html" >The PostgreSQL Type System</A > </DT ><DD ><DL ></DL ></DD ><DT >constant, <A HREF="sql-syntax.html#SQL-SYNTAX-CONSTANTS-GENERIC" >Constants of Other Types</A > </DT ><DD ><DL ></DL ></DD ><DT >conversion, <A HREF="typeconv.html" >Type Conversion</A > </DT ><DD ><DL ></DL ></DD ><DT >internal organisation, <A HREF="xfunc-c.html#XFUNC-C-BASETYPE" >Base Types in C-Language Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >numeric, <A HREF="datatype.html#DATATYPE-NUMERIC" >Numeric Types</A > </DT ><DD ><DL ></DL ></DD ><DT >type cast, <A HREF="sql-expressions.html#SQL-SYNTAX-TYPE-CASTS" >Type Casts</A > </DT ><DD ><DL ></DL ></DD ><DT >user-defined, <A HREF="xtypes.html" >User-Defined Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >database, <A HREF="managing-databases.html" >Managing Databases</A > </DT ><DD ><DL ><DT >creating, <A HREF="tutorial-createdb.html" >Creating a Database</A > </DT ><DD ><DL ></DL ></DD ><DT >privilege to create, <A HREF="user-attributes.html" >User Attributes</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >database activity </DT ><DD ><DL ><DT >monitoring, <A HREF="monitoring.html" >Monitoring Database Activity</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >database cluster, <A HREF="tutorial-concepts.html" >Concepts</A >, <A HREF="creating-cluster.html" >Creating a Database Cluster</A > </DT ><DT >data_directory configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-FILE-LOCATIONS" >File Locations</A > </DT ><DT >date, <A HREF="datatype-datetime.html" >Date/Time Types</A >, <A HREF="datatype-datetime.html#AEN4337" >Dates</A > </DT ><DD ><DL ><DT >constants, <A HREF="datatype-datetime.html#AEN4599" >Special Values</A > </DT ><DD ><DL ></DL ></DD ><DT >current, <A HREF="functions-datetime.html#FUNCTIONS-DATETIME-CURRENT" >Current Date/Time</A > </DT ><DD ><DL ></DL ></DD ><DT >output format, <A HREF="datatype-datetime.html#DATATYPE-DATETIME-OUTPUT" >Date/Time Output</A > </DT ><DD ><DL ><DT >see also formatting</DT ></DL ></DD ></DL ></DD ><DT >DateStyle configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DT >DBI, <A HREF="plperl-database.html" >Database Access from PL/Perl</A > </DT ><DT >db_user_namespace configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SECURITY" >Security and Authentication</A > </DT ><DT >deadlock, <A HREF="explicit-locking.html#LOCKING-DEADLOCKS" >Deadlocks</A > </DT ><DD ><DL ><DT >timeout during, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOCKS" >Lock Management</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >deadlock_timeout configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOCKS" >Lock Management</A > </DT ><DT >DEALLOCATE, <A HREF="sql-deallocate.html" >DEALLOCATE</A > </DT ><DT >debug_assertions configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-DEVELOPER" >Developer Options</A > </DT ><DT >debug_pretty_print configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A > </DT ><DT >debug_print_parse configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A > </DT ><DT >debug_print_plan configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A > </DT ><DT >debug_print_rewritten configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A > </DT ><DT >debug_shared_buffers configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-DEVELOPER" >Developer Options</A > </DT ><DT >decimal </DT ><DD ><DL ><DT >see numeric</DT ></DL ></DD ><DT >DECLARE, <A HREF="sql-declare.html" >DECLARE</A > </DT ><DT >default value, <A HREF="ddl-default.html" >Default Values</A > </DT ><DD ><DL ><DT >changing, <A HREF="ddl-alter.html#AEN2322" >Changing a Column's Default Value</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >default_statistics_target configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-OTHER" >Other Planner Options</A > </DT ><DT >default_tablespace configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A > </DT ><DT >default_transaction_isolation configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A > </DT ><DT >default_transaction_read_only configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A > </DT ><DT >default_with_oids configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-VERSION" >Previous PostgreSQL Versions</A > </DT ><DT >DELETE, <A HREF="tutorial-delete.html" >Deletions</A >, <A HREF="dml-delete.html" >Deleting Data</A >, <A HREF="sql-delete.html" >DELETE</A > </DT ><DT >deleting, <A HREF="dml-delete.html" >Deleting Data</A > </DT ><DT >Digital UNIX </DT ><DD ><DL ><DT >see Tru64 UNIX</DT ></DL ></DD ><DT >dirty read, <A HREF="transaction-iso.html" >Transaction Isolation</A > </DT ><DT >disjunction, <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DT >disk drive, <A HREF="wal-internals.html" >Internals</A > </DT ><DT >disk space, <A HREF="maintenance.html#VACUUM-FOR-SPACE-RECOVERY" >Recovering disk space</A > </DT ><DT >disk usage, <A HREF="diskusage.html#DISK-USAGE" >Determining Disk Usage</A > </DT ><DT >DISTINCT, <A HREF="tutorial-select.html" >Querying a Table</A >, <A HREF="queries-select-lists.html#QUERIES-DISTINCT" >DISTINCT</A > </DT ><DT >dollar quoting, <A HREF="sql-syntax.html#SQL-SYNTAX-DOLLAR-QUOTING" >Dollar-Quoted String Constants</A > </DT ><DT >double precision, <A HREF="datatype.html#DATATYPE-FLOAT" >Floating-Point Types</A > </DT ><DT >DROP AGGREGATE, <A HREF="sql-dropaggregate.html" >DROP AGGREGATE</A > </DT ><DT >DROP CAST, <A HREF="sql-dropcast.html" >DROP CAST</A > </DT ><DT >DROP CONVERSION, <A HREF="sql-dropconversion.html" >DROP CONVERSION</A > </DT ><DT >DROP DATABASE, <A HREF="manage-ag-dropdb.html" >Destroying a Database</A >, <A HREF="sql-dropdatabase.html" >DROP DATABASE</A > </DT ><DT >DROP DOMAIN, <A HREF="sql-dropdomain.html" >DROP DOMAIN</A > </DT ><DT >DROP FUNCTION, <A HREF="sql-dropfunction.html" >DROP FUNCTION</A > </DT ><DT >DROP GROUP, <A HREF="sql-dropgroup.html" >DROP GROUP</A > </DT ><DT >DROP INDEX, <A HREF="sql-dropindex.html" >DROP INDEX</A > </DT ><DT >DROP LANGUAGE, <A HREF="sql-droplanguage.html" >DROP LANGUAGE</A > </DT ><DT >DROP OPERATOR, <A HREF="sql-dropoperator.html" >DROP OPERATOR</A > </DT ><DT >DROP OPERATOR CLASS, <A HREF="sql-dropopclass.html" >DROP OPERATOR CLASS</A > </DT ><DT >DROP RULE, <A HREF="sql-droprule.html" >DROP RULE</A > </DT ><DT >DROP SCHEMA, <A HREF="sql-dropschema.html" >DROP SCHEMA</A > </DT ><DT >DROP SEQUENCE, <A HREF="sql-dropsequence.html" >DROP SEQUENCE</A > </DT ><DT >DROP TABLE, <A HREF="tutorial-table.html" >Creating a New Table</A >, <A HREF="sql-droptable.html" >DROP TABLE</A > </DT ><DT >DROP TABLESPACE, <A HREF="sql-droptablespace.html" >DROP TABLESPACE</A > </DT ><DT >DROP TRIGGER, <A HREF="sql-droptrigger.html" >DROP TRIGGER</A > </DT ><DT >DROP TYPE, <A HREF="sql-droptype.html" >DROP TYPE</A > </DT ><DT >DROP USER, <A HREF="user-manag.html#DATABASE-USERS" >Database Users</A >, <A HREF="sql-dropuser.html" >DROP USER</A > </DT ><DT >DROP VIEW, <A HREF="sql-dropview.html" >DROP VIEW</A > </DT ><DT >dropdb, <A HREF="manage-ag-dropdb.html" >Destroying a Database</A >, <A HREF="app-dropdb.html" >dropdb</A > </DT ><DT >droplang, <A HREF="app-droplang.html" >droplang</A > </DT ><DT >dropuser, <A HREF="user-manag.html#DATABASE-USERS" >Database Users</A >, <A HREF="app-dropuser.html" >dropuser</A > </DT ><DT >duplicate, <A HREF="tutorial-select.html" >Querying a Table</A > </DT ><DT >duplicates, <A HREF="queries-select-lists.html#QUERIES-DISTINCT" >DISTINCT</A > </DT ><DT >dynamic loading, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-OTHER" >Other Defaults</A >, <A HREF="xfunc-c.html#XFUNC-C-DYNLOAD" >Dynamic Loading</A > </DT ><DT >dynamic_library_path, <A HREF="xfunc-c.html#XFUNC-C-DYNLOAD" >Dynamic Loading</A > </DT ><DT >dynamic_library_path configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-OTHER" >Other Defaults</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN76683" >E</A ></H2 ><DL ><DT >ECPG, <A HREF="ecpg.html" >ECPG - Embedded SQL in C</A >, <A HREF="app-ecpg.html" >ecpg</A > </DT ><DT >effective_cache_size configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-CONSTANTS" > Planner Cost Constants </A > </DT ><DT >elog, <A HREF="error-message-reporting.html" >Reporting Errors Within the Server</A > </DT ><DD ><DL ><DT >in PL/Perl, <A HREF="plperl-database.html" >Database Access from PL/Perl</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/Python, <A HREF="plpython-database.html" >Database Access</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/Tcl, <A HREF="pltcl-dbaccess.html" >Database Access from PL/Tcl</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >embedded SQL </DT ><DD ><DL ><DT >in C, <A HREF="ecpg.html" >ECPG - Embedded SQL in C</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >enable_hashagg configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A > </DT ><DT >enable_hashjoin configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A > </DT ><DT >enable_indexscan configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A > </DT ><DT >enable_mergejoin configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A > </DT ><DT >enable_nestloop configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A > </DT ><DT >enable_seqscan configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A > </DT ><DT >enable_sort configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A > </DT ><DT >enable_tidscan configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A > </DT ><DT >encryption, <A HREF="encryption-options.html" >Encryption Options</A > </DT ><DT >END, <A HREF="sql-end.html" >END</A > </DT ><DT >environment variable, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >ereport, <A HREF="error-message-reporting.html" >Reporting Errors Within the Server</A > </DT ><DT >error codes </DT ><DD ><DL ><DT >libpq, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >list of, <A HREF="errcodes-appendix.html" >PostgreSQL Error Codes</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >error message, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >escaping strings, <A HREF="libpq-exec.html#LIBPQ-EXEC-ESCAPE-STRING" >Escaping Strings for Inclusion in SQL Commands</A > </DT ><DT >every, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DT >EXCEPT, <A HREF="queries-union.html" >Combining Queries</A > </DT ><DT >EXECUTE, <A HREF="sql-execute.html" >EXECUTE</A > </DT ><DT >EXISTS, <A HREF="functions-subquery.html" >Subquery Expressions</A > </DT ><DT >EXPLAIN, <A HREF="performance-tips.html#USING-EXPLAIN" >Using EXPLAIN</A >, <A HREF="sql-explain.html" >EXPLAIN</A > </DT ><DT >explain_pretty_print configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-OTHER" >Other Defaults</A > </DT ><DT >expression </DT ><DD ><DL ><DT >order of evaluation, <A HREF="sql-expressions.html#SYNTAX-EXPRESS-EVAL" >Expression Evaluation Rules</A > </DT ><DD ><DL ></DL ></DD ><DT >syntax, <A HREF="sql-expressions.html" >Value Expressions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >extending SQL, <A HREF="extend.html" >Extending SQL</A > </DT ><DT >extensions, <A HREF="external-extensions.html" >Extensions</A > </DT ><DT >external_pid_file configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-FILE-LOCATIONS" >File Locations</A > </DT ><DT >extra_float_digits configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN76790" >F</A ></H2 ><DL ><DT >false, <A HREF="datatype-boolean.html" >Boolean Type</A > </DT ><DT >FAQ-Liste, <A HREF="resources.html" >Further Information</A > </DT ><DT >fast path, <A HREF="libpq-fastpath.html" >The Fast-Path Interface</A > </DT ><DT >FETCH, <A HREF="sql-fetch.html" >FETCH</A > </DT ><DT >field </DT ><DD ><DL ><DT >computed, <A HREF="xfunc-sql.html#AEN29579" >SQL Functions on Composite Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >field selection, <A HREF="sql-expressions.html#AEN1642" >Field Selection</A > </DT ><DT >flex, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >float4 </DT ><DD ><DL ><DT >see real</DT ></DL ></DD ><DT >float8 </DT ><DD ><DL ><DT >see double precision</DT ></DL ></DD ><DT >floating point, <A HREF="datatype.html#DATATYPE-FLOAT" >Floating-Point Types</A > </DT ><DT >floating-point </DT ><DD ><DL ><DT >display, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >foreign key, <A HREF="tutorial-fk.html" >Foreign Keys</A >, <A HREF="ddl-constraints.html#DDL-CONSTRAINTS-FK" >Foreign Keys</A > </DT ><DT >formatting, <A HREF="functions-formatting.html" >Data Type Formatting Functions</A > </DT ><DT >format_type, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >FreeBSD </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >start script, <A HREF="postmaster-start.html" >Starting the Database Server</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >FROM </DT ><DD ><DL ><DT >missing, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-VERSION" >Previous PostgreSQL Versions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >from_collapse_limit configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-OTHER" >Other Planner Options</A > </DT ><DT >fsync, <A HREF="wal.html#WAL-BENEFITS" >Benefits of WAL</A > </DT ><DT >fsync configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-WAL-SETTINGS" >Settings</A > </DT ><DT >function, <A HREF="functions.html" >Functions and Operators</A > </DT ><DD ><DL ><DT >in the FROM clause, <A HREF="queries-table-expressions.html#QUERIES-TABLEFUNCTIONS" >Table Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >internal, <A HREF="xfunc-internal.html" >Internal Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >invocation, <A HREF="sql-expressions.html#AEN1682" >Function Calls</A > </DT ><DD ><DL ></DL ></DD ><DT >polymorphic, <A HREF="extend-type-system.html#EXTEND-TYPES-POLYMORPHIC" >Polymorphic Types</A > </DT ><DD ><DL ></DL ></DD ><DT >type resolution in an invocation, <A HREF="typeconv-func.html" >Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >user-defined, <A HREF="xfunc.html" >User-Defined Functions</A > </DT ><DD ><DL ><DT >in C, <A HREF="xfunc-sql.html" >Query Language (SQL) Functions</A > </DT ><DT >in SQL, <A HREF="xfunc-sql.html" >Query Language (SQL) Functions</A > </DT ></DL ></DD ></DL ></DD ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN76877" >G</A ></H2 ><DL ><DT >genetic query optimization, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-GEQO" >Genetic Query Optimizer</A > </DT ><DT >GEQO </DT ><DD ><DL ><DT >see genetic query optimization</DT ></DL ></DD ><DT >geqo configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-GEQO" >Genetic Query Optimizer</A > </DT ><DT >geqo_effort configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-GEQO" >Genetic Query Optimizer</A > </DT ><DT >geqo_generations configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-GEQO" >Genetic Query Optimizer</A > </DT ><DT >geqo_pool_size configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-GEQO" >Genetic Query Optimizer</A > </DT ><DT >geqo_selection_bias configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-GEQO" >Genetic Query Optimizer</A > </DT ><DT >geqo_threshold configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-GEQO" >Genetic Query Optimizer</A > </DT ><DT >get_bit, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DT >get_byte, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DT >GiST </DT ><DD ><DL ><DT >see index</DT ></DL ></DD ><DT >global data </DT ><DD ><DL ><DT >in PL/Python, <A HREF="plpython.html#PLPYTHON-FUNCS" >PL/Python Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/Tcl, <A HREF="pltcl-global.html" >Global Data in PL/Tcl</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >GRANT, <A HREF="privileges.html" >Privileges</A >, <A HREF="sql-grant.html" >GRANT</A > </DT ><DT >group, <A HREF="groups.html" >Groups</A > </DT ><DT >GROUP BY, <A HREF="tutorial-agg.html" >Aggregate Functions</A >, <A HREF="queries-table-expressions.html#QUERIES-GROUP" >The GROUP BY and HAVING Clauses</A > </DT ><DT >grouping, <A HREF="queries-table-expressions.html#QUERIES-GROUP" >The GROUP BY and HAVING Clauses</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN76932" >H</A ></H2 ><DL ><DT >hash </DT ><DD ><DL ><DT >see index</DT ></DL ></DD ><DT >has_database_privilege, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >has_function_privilege, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >has_language_privilege, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >has_schema_privilege, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >has_tablespace_privilege, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >has_table_privilege, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >HAVING, <A HREF="tutorial-agg.html" >Aggregate Functions</A >, <A HREF="queries-table-expressions.html#QUERIES-GROUP" >The GROUP BY and HAVING Clauses</A > </DT ><DT >hba_file configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-FILE-LOCATIONS" >File Locations</A > </DT ><DT >hierarchical database, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >history </DT ><DD ><DL ><DT >of PostgreSQL, <A HREF="history.html" >A Brief History of PostgreSQL</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >host name, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >HP-UX </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN76978" >I</A ></H2 ><DL ><DT >ident, <A HREF="auth-methods.html#AUTH-IDENT" >Ident-based authentication</A > </DT ><DT >identifier </DT ><DD ><DL ><DT >length, <A HREF="sql-syntax.html#SQL-SYNTAX-IDENTIFIERS" >Identifiers and Key Words</A > </DT ><DD ><DL ></DL ></DD ><DT >syntax of, <A HREF="sql-syntax.html#SQL-SYNTAX-IDENTIFIERS" >Identifiers and Key Words</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >ident_file configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-FILE-LOCATIONS" >File Locations</A > </DT ><DT >IMMUTABLE, <A HREF="xfunc-volatility.html" >Function Volatility Categories</A > </DT ><DT >IN, <A HREF="functions-subquery.html" >Subquery Expressions</A >, <A HREF="functions-comparisons.html" >Row and Array Comparisons</A > </DT ><DT >index, <A HREF="indexes.html" >Indexes</A > </DT ><DD ><DL ><DT >B-tree, <A HREF="indexes-types.html" >Index Types</A > </DT ><DD ><DL ></DL ></DD ><DT >examining usage, <A HREF="indexes-examine.html" >Examining Index Usage</A > </DT ><DD ><DL ></DL ></DD ><DT >on expressions, <A HREF="indexes-expressional.html" >Indexes on Expressions</A > </DT ><DD ><DL ></DL ></DD ><DT >for user-defined data type, <A HREF="xindex.html" >Interfacing Extensions To Indexes</A > </DT ><DD ><DL ></DL ></DD ><DT >GiST, <A HREF="gist.html#INTRO" >Introduction</A > </DT ><DD ><DL ></DL ></DD ><DT >hash, <A HREF="indexes-types.html" >Index Types</A > </DT ><DD ><DL ></DL ></DD ><DT >locks, <A HREF="locking-indexes.html" >Locking and Indexes</A > </DT ><DD ><DL ></DL ></DD ><DT >multicolumn, <A HREF="indexes-multicolumn.html" >Multicolumn Indexes</A > </DT ><DD ><DL ></DL ></DD ><DT >partial, <A HREF="indexes-partial.html" >Partial Indexes</A > </DT ><DD ><DL ></DL ></DD ><DT >R-tree, <A HREF="indexes-types.html" >Index Types</A > </DT ><DD ><DL ></DL ></DD ><DT >unique, <A HREF="indexes-unique.html" >Unique Indexes</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >index scan, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A > </DT ><DT >inet (data type), <A HREF="datatype-net-types.html#DATATYPE-INET" >inet</A > </DT ><DT >inet_client_addr, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >inet_client_port, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >inet_server_addr, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >inet_server_port, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >information schema, <A HREF="information-schema.html" >The Information Schema</A > </DT ><DT >inheritance, <A HREF="tutorial-inheritance.html" >Inheritance</A >, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-VERSION" >Previous PostgreSQL Versions</A > </DT ><DT >initdb, <A HREF="creating-cluster.html" >Creating a Database Cluster</A >, <A HREF="app-initdb.html" >initdb</A > </DT ><DT >input function, <A HREF="xtypes.html" >User-Defined Types</A > </DT ><DD ><DL ><DT >of a data type, <A HREF="xtypes.html" >User-Defined Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >INSERT, <A HREF="tutorial-populate.html" >Populating a Table With Rows</A >, <A HREF="dml.html#DML-INSERT" >Inserting Data</A >, <A HREF="sql-insert.html" >INSERT</A > </DT ><DT >inserting, <A HREF="dml.html#DML-INSERT" >Inserting Data</A > </DT ><DT >installation, <A HREF="installation.html" > Installation Instructions</A > </DT ><DD ><DL ><DT >on Windows, <A HREF="install-requirements.html" >Requirements</A >, <A HREF="install-win32.html" >Client-Only Installation on Windows</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >instr, <A HREF="plpgsql-porting.html#AEN33592" >Porting Examples</A > </DT ><DT >int2 </DT ><DD ><DL ><DT >see smallint</DT ></DL ></DD ><DT >int4 </DT ><DD ><DL ><DT >see integer</DT ></DL ></DD ><DT >int8 </DT ><DD ><DL ><DT >see bigint</DT ></DL ></DD ><DT >integer, <A HREF="sql-syntax.html#AEN1246" >Numeric Constants</A >, <A HREF="datatype.html#DATATYPE-INT" >Integer Types</A > </DT ><DT >integer_datetimes configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-PRESET" >Preset Options</A > </DT ><DT >interfaces, <A HREF="external-projects.html#EXTERNAL-INTERFACES" >Externally Developed Interfaces</A > </DT ><DT >internal, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >INTERSECT, <A HREF="queries-union.html" >Combining Queries</A > </DT ><DT >interval, <A HREF="datatype-datetime.html" >Date/Time Types</A >, <A HREF="datatype-datetime.html#AEN4564" >Intervals</A > </DT ><DT >ipcclean, <A HREF="app-ipcclean.html" >ipcclean</A > </DT ><DT >IRIX </DT ><DD ><DL ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >IS DISTINCT FROM, <A HREF="functions-comparison.html" >Comparison Operators</A >, <A HREF="functions-comparisons.html" >Row and Array Comparisons</A > </DT ><DT >IS FALSE, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DT >IS NOT FALSE, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DT >IS NOT NULL, <A HREF="functions-comparison.html" >Comparison Operators</A >, <A HREF="functions-comparisons.html" >Row and Array Comparisons</A > </DT ><DT >IS NOT TRUE, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DT >IS NOT UNKNOWN, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DT >IS NULL, <A HREF="functions-comparison.html" >Comparison Operators</A >, <A HREF="functions-comparisons.html" >Row and Array Comparisons</A >, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-CLIENTS" >Platform and Client Compatibility</A > </DT ><DT >IS TRUE, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DT >IS UNKNOWN, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DT >ISNULL, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN77145" >J</A ></H2 ><DL ><DT >join, <A HREF="tutorial-join.html" >Joins Between Tables</A >, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ><DT >controlling the order, <A HREF="explicit-joins.html" >Controlling the Planner with Explicit JOIN Clauses</A > </DT ><DD ><DL ></DL ></DD ><DT >cross, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >left, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >natural, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >outer, <A HREF="tutorial-join.html" >Joins Between Tables</A >, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >right, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >self, <A HREF="tutorial-join.html" >Joins Between Tables</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >join_collapse_limit configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-OTHER" >Other Planner Options</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN77169" >K</A ></H2 ><DL ><DT >Kerberos, <A HREF="auth-methods.html#KERBEROS-AUTH" >Kerberos authentication</A > </DT ><DT >key word </DT ><DD ><DL ><DT >list of, <A HREF="sql-keywords-appendix.html" >SQL Key Words</A > </DT ><DD ><DL ></DL ></DD ><DT >syntax of, <A HREF="sql-syntax.html#SQL-SYNTAX-IDENTIFIERS" >Identifiers and Key Words</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >krb_server_keyfile configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SECURITY" >Security and Authentication</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN77183" >L</A ></H2 ><DL ><DT >label </DT ><DD ><DL ><DT >see alias</DT ></DL ></DD ><DT >language_handler, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >large object </DT ><DD ><DL ><DT >backup, <A HREF="backup.html#BACKUP-DUMP-CAVEATS" >Caveats</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >large object, <A HREF="largeobjects.html" >Large Objects</A > </DT ><DT >lc_collate configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-PRESET" >Preset Options</A > </DT ><DT >lc_ctype configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-PRESET" >Preset Options</A > </DT ><DT >lc_messages configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DT >lc_monetary configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DT >lc_numeric configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DT >lc_time configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DT >ldconfig, <A HREF="install-post.html#AEN15603" >Shared Libraries</A > </DT ><DT >left join, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DT >length </DT ><DD ><DL ><DT >of a binary string </DT ><DD ><DL ><DT >see binary strings, length</DT ></DL ></DD ><DT >of a character string </DT ><DD ><DL ><DT >see character strings, length</DT ></DL ></DD ></DL ></DD ><DT >libperl, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >libpq, <A HREF="libpq.html" >libpq - C Library</A > </DT ><DT >libpq-fe.h, <A HREF="libpq.html" >libpq - C Library</A >, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >libpq-int.h, <A HREF="libpq-status.html" >Connection Status Functions</A >, <A HREF="libpq-build.html" >Building libpq Programs</A > </DT ><DT >libpython, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >LIKE, <A HREF="functions-matching.html#FUNCTIONS-LIKE" >LIKE</A > </DT ><DD ><DL ><DT >and locales, <A HREF="charset.html#AEN20454" >Behavior</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >LIMIT, <A HREF="queries-limit.html" >LIMIT and OFFSET</A > </DT ><DT >line segment, <A HREF="datatype-geometric.html#AEN4998" >Line Segments</A > </DT ><DT >Linux </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >start script, <A HREF="postmaster-start.html" >Starting the Database Server</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >LISTEN, <A HREF="sql-listen.html" >LISTEN</A > </DT ><DT >listen_addresses configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" >Connection Settings</A > </DT ><DT >LOAD, <A HREF="sql-load.html" >LOAD</A > </DT ><DT >locale, <A HREF="creating-cluster.html" >Creating a Database Cluster</A >, <A HREF="charset.html#LOCALE" >Locale Support</A > </DT ><DT >lock, <A HREF="explicit-locking.html" >Explicit Locking</A >, <A HREF="explicit-locking.html#LOCKING-TABLES" >Table-Level Locks</A >, <A HREF="sql-lock.html" >LOCK</A > </DT ><DD ><DL ><DT >monitoring, <A HREF="monitoring-locks.html" >Viewing Locks</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >log_connections configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A > </DT ><DT >log_destination configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where to log</A > </DT ><DT >log_directory configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where to log</A > </DT ><DT >log_disconnections configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A > </DT ><DT >log_duration configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A > </DT ><DT >log_error_verbosity configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHEN" >When To Log</A > </DT ><DT >log_executor_stats configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-STATISTICS-MONITOR" >Statistics Monitoring</A > </DT ><DT >log_filename configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where to log</A > </DT ><DT >log_hostname configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A > </DT ><DT >log_line_prefix configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A > </DT ><DT >log_min_duration_statement configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHEN" >When To Log</A > </DT ><DT >log_min_error_statement configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHEN" >When To Log</A > </DT ><DT >log_min_messages configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHEN" >When To Log</A > </DT ><DT >log_parser_stats configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-STATISTICS-MONITOR" >Statistics Monitoring</A > </DT ><DT >log_planner_stats configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-STATISTICS-MONITOR" >Statistics Monitoring</A > </DT ><DT >log_rotation_age configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where to log</A > </DT ><DT >log_rotation_size configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where to log</A > </DT ><DT >log_statement configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A > </DT ><DT >log_statement_stats configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-STATISTICS-MONITOR" >Statistics Monitoring</A > </DT ><DT >log_truncate_on_rotation configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where to log</A > </DT ><DT >loop </DT ><DD ><DL ><DT >in PL/pgSQL, <A HREF="plpgsql-control-structures.html#PLPGSQL-CONTROL-STRUCTURES-LOOPS" >Simple Loops</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >lo_close, <A HREF="lo-interfaces.html#AEN25079" >Closing a Large Object Descriptor</A > </DT ><DT >lo_creat, <A HREF="lo-interfaces.html#AEN24996" >Creating a Large Object</A >, <A HREF="lo-funcs.html" >Server-Side Functions</A > </DT ><DT >lo_export, <A HREF="lo-interfaces.html#AEN25015" >Exporting a Large Object</A >, <A HREF="lo-funcs.html" >Server-Side Functions</A > </DT ><DT >lo_import, <A HREF="lo-interfaces.html#AEN25008" >Importing a Large Object</A >, <A HREF="lo-funcs.html" >Server-Side Functions</A > </DT ><DT >lo_lseek, <A HREF="lo-interfaces.html#AEN25061" >Seeking in a Large Object</A > </DT ><DT >lo_open, <A HREF="lo-interfaces.html#AEN25023" >Opening an Existing Large Object</A > </DT ><DT >lo_read, <A HREF="lo-interfaces.html#AEN25050" >Reading Data from a Large Object</A > </DT ><DT >lo_tell, <A HREF="lo-interfaces.html#AEN25073" >Obtaining the Seek Position of a Large Object</A > </DT ><DT >lo_unlink, <A HREF="lo-interfaces.html#AEN25089" >Removing a Large Object</A >, <A HREF="lo-funcs.html" >Server-Side Functions</A > </DT ><DT >lo_write, <A HREF="lo-interfaces.html#AEN25039" >Writing Data to a Large Object</A > </DT ><DT >lseg, <A HREF="datatype-geometric.html#AEN4998" >Line Segments</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN77385" >M</A ></H2 ><DL ><DT >MAC address </DT ><DD ><DL ><DT >see macaddr</DT ></DL ></DD ><DT >macaddr (data type), <A HREF="datatype-net-types.html#DATATYPE-MACADDR" >macaddr</A > </DT ><DT >MacOS X </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >maintenance, <A HREF="maintenance.html" >Routine Database Maintenance Tasks</A > </DT ><DT >maintenance_work_mem configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-MEMORY" >Memory</A > </DT ><DT >make, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >MANPATH, <A HREF="install-post.html#AEN15660" >Environment Variables</A > </DT ><DT >max, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >max_connections configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" >Connection Settings</A > </DT ><DT >max_files_per_process configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-KERNEL" >Kernel Resource Usage</A > </DT ><DT >max_fsm_pages configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-FSM" >Free Space Map</A > </DT ><DT >max_fsm_relations configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-FSM" >Free Space Map</A > </DT ><DT >max_function_args configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-PRESET" >Preset Options</A > </DT ><DT >max_identifier_length configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-PRESET" >Preset Options</A > </DT ><DT >max_index_keys configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-PRESET" >Preset Options</A > </DT ><DT >max_locks_per_transaction configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOCKS" >Lock Management</A > </DT ><DT >max_stack_depth configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-MEMORY" >Memory</A > </DT ><DT >MD5, <A HREF="auth-methods.html#AUTH-PASSWORD" >Password authentication</A > </DT ><DT >memory context </DT ><DD ><DL ><DT >in SPI, <A HREF="spi-memory.html" >Memory Management</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >min, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >monitoring </DT ><DD ><DL ><DT >database activity, <A HREF="monitoring.html" >Monitoring Database Activity</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >MOVE, <A HREF="sql-move.html" >MOVE</A > </DT ><DT >MVCC, <A HREF="mvcc.html#MVCC-INTRO" >Introduction</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN77461" >N</A ></H2 ><DL ><DT >name </DT ><DD ><DL ><DT >qualified, <A HREF="ddl-schemas.html#DDL-SCHEMAS-CREATE" >Creating a Schema</A > </DT ><DD ><DL ></DL ></DD ><DT >syntax of, <A HREF="sql-syntax.html#SQL-SYNTAX-IDENTIFIERS" >Identifiers and Key Words</A > </DT ><DD ><DL ></DL ></DD ><DT >unqualified, <A HREF="ddl-schemas.html#DDL-SCHEMAS-PATH" >The Schema Search Path</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >natural join, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DT >negation, <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DT >NetBSD </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >start script, <A HREF="postmaster-start.html" >Starting the Database Server</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >network </DT ><DD ><DL ><DT >data types, <A HREF="datatype-net-types.html" >Network Address Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >nextval, <A HREF="functions-sequence.html" >Sequence Manipulation Functions</A > </DT ><DT >nonblocking connection, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A >, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >nonrepeatable read, <A HREF="transaction-iso.html" >Transaction Isolation</A > </DT ><DT >NOT (operator), <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DT >NOT IN, <A HREF="functions-subquery.html" >Subquery Expressions</A >, <A HREF="functions-comparisons.html" >Row and Array Comparisons</A > </DT ><DT >not-null constraint, <A HREF="ddl-constraints.html#AEN1970" >Not-Null Constraints</A > </DT ><DT >notice processing </DT ><DD ><DL ><DT >in libpq, <A HREF="libpq-notice-processing.html" >Notice Processing</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >notice processor, <A HREF="libpq-notice-processing.html" >Notice Processing</A > </DT ><DT >notice receiver, <A HREF="libpq-notice-processing.html" >Notice Processing</A > </DT ><DT >NOTIFY, <A HREF="sql-notify.html" >NOTIFY</A > </DT ><DD ><DL ><DT >in libpq, <A HREF="libpq-notify.html" >Asynchronous Notification</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >NOTNULL, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DT >null value </DT ><DD ><DL ><DT >with check constraints, <A HREF="ddl-constraints.html#AEN1936" >Check Constraints</A > </DT ><DD ><DL ></DL ></DD ><DT >comparing, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DD ><DL ></DL ></DD ><DT >default value, <A HREF="ddl-default.html" >Default Values</A > </DT ><DD ><DL ></DL ></DD ><DT >in DISTINCT, <A HREF="queries-select-lists.html#QUERIES-DISTINCT" >DISTINCT</A > </DT ><DD ><DL ></DL ></DD ><DT >in libpq, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/Perl, <A HREF="plperl.html#PLPERL-FUNCS" >PL/Perl Functions and Arguments</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/Python, <A HREF="plpython.html#PLPYTHON-FUNCS" >PL/Python Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >with unique constraints, <A HREF="ddl-constraints.html#AEN1996" >Unique Constraints</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >NULLIF, <A HREF="functions-conditional.html#AEN12073" >NULLIF</A > </DT ><DT >number </DT ><DD ><DL ><DT >constant, <A HREF="sql-syntax.html#AEN1246" >Numeric Constants</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >numeric, <A HREF="sql-syntax.html#AEN1246" >Numeric Constants</A > </DT ><DT >numeric (data type), <A HREF="datatype.html#DATATYPE-NUMERIC-DECIMAL" >Arbitrary Precision Numbers</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN77558" >O</A ></H2 ><DL ><DT >object identifier </DT ><DD ><DL ><DT >data type, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >object-oriented database, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >obj_description, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >OFFSET, <A HREF="queries-limit.html" >LIMIT and OFFSET</A > </DT ><DT >oid, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DD ><DL ><DT >column, <A HREF="ddl-system-columns.html" >System Columns</A > </DT ><DD ><DL ></DL ></DD ><DT >in libpq, <A HREF="libpq-exec.html#LIBPQ-EXEC-NONSELECT" >Retrieving Result Information for Other Commands</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >on-line backup, <A HREF="backup.html" >Backup and Restore</A > </DT ><DT >ONLY, <A HREF="queries-table-expressions.html#QUERIES-FROM" >The FROM Clause</A > </DT ><DT >opaque, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >OpenBSD </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >start script, <A HREF="postmaster-start.html" >Starting the Database Server</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >OpenSSL, <A HREF="install-procedure.html" >Installation Procedure</A > </DT ><DD ><DL ><DT >see also SSL</DT ></DL ></DD ><DT >operator, <A HREF="functions.html" >Functions and Operators</A > </DT ><DD ><DL ><DT >invocation, <A HREF="sql-expressions.html#AEN1653" >Operator Invocations</A > </DT ><DD ><DL ></DL ></DD ><DT >logical, <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DD ><DL ></DL ></DD ><DT >precedence, <A HREF="sql-syntax.html#SQL-PRECEDENCE" >Lexical Precedence</A > </DT ><DD ><DL ></DL ></DD ><DT >syntax, <A HREF="sql-syntax.html#SQL-SYNTAX-OPERATORS" >Operators</A > </DT ><DD ><DL ></DL ></DD ><DT >type resolution in an invocation, <A HREF="typeconv-oper.html" >Operators</A > </DT ><DD ><DL ></DL ></DD ><DT >user-defined, <A HREF="xoper.html" >User-Defined Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >operator class, <A HREF="indexes-opclass.html" >Operator Classes</A >, <A HREF="xindex.html#XINDEX-IM" >Index Methods and Operator Classes</A > </DT ><DT >OR (operator), <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DT >Oracle </DT ><DD ><DL ><DT >porting from PL/SQL to PL/pgSQL, <A HREF="plpgsql-porting.html" >Porting from Oracle PL/SQL</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >ORDER BY, <A HREF="tutorial-select.html" >Querying a Table</A >, <A HREF="queries-order.html" >Sorting Rows</A > </DT ><DD ><DL ><DT >and locales, <A HREF="charset.html#AEN20454" >Behavior</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >ordering operator, <A HREF="xindex.html#XINDEX-OPCLASS-DEPENDENCIES" >System Dependencies on Operator Classes</A > </DT ><DT >outer join, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DT >output function </DT ><DD ><DL ><DT >of a data type, <A HREF="xtypes.html" >User-Defined Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >output function, <A HREF="xtypes.html" >User-Defined Types</A > </DT ><DT >overlay, <A HREF="functions-string.html" >String Functions and Operators</A > </DT ><DT >overloading </DT ><DD ><DL ><DT >functions, <A HREF="xfunc-overload.html" >Function Overloading</A > </DT ><DD ><DL ></DL ></DD ><DT >operators, <A HREF="xoper.html" >User-Defined Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >owner, <A HREF="privileges.html" >Privileges</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN77658" >P</A ></H2 ><DL ><DT >palloc, <A HREF="xfunc-c.html#AEN30217" >Writing Code</A > </DT ><DT >PAM, <A HREF="install-procedure.html" >Installation Procedure</A >, <A HREF="auth-methods.html#AUTH-PAM" >PAM authentication</A > </DT ><DT >parameter </DT ><DD ><DL ><DT >syntax, <A HREF="sql-expressions.html#AEN1609" >Positional Parameters</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >parenthesis, <A HREF="sql-expressions.html" >Value Expressions</A > </DT ><DT >password, <A HREF="user-attributes.html" >User Attributes</A > </DT ><DD ><DL ><DT >authentication, <A HREF="auth-methods.html#AUTH-PASSWORD" >Password authentication</A > </DT ><DD ><DL ></DL ></DD ><DT >of the superuser, <A HREF="creating-cluster.html" >Creating a Database Cluster</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >password file, <A HREF="libpq-pgpass.html" >The Password File</A > </DT ><DT >password_encryption configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SECURITY" >Security and Authentication</A > </DT ><DT >PATH, <A HREF="install-post.html#AEN15660" >Environment Variables</A > </DT ><DD ><DL ><DT >for schemas, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >path (data type), <A HREF="datatype-geometric.html#AEN5054" >Paths</A > </DT ><DT >pattern matching, <A HREF="functions-matching.html" >Pattern Matching</A > </DT ><DT >performance, <A HREF="performance-tips.html" >Performance Tips</A > </DT ><DT >Perl, <A HREF="plperl.html" >PL/Perl - Perl Procedural Language</A > </DT ><DT >permission </DT ><DD ><DL ><DT >see privilege</DT ></DL ></DD ><DT >pfree, <A HREF="xfunc-c.html#AEN30217" >Writing Code</A > </DT ><DT >PGcancel, <A HREF="libpq-cancel.html" >Cancelling Queries in Progress</A > </DT ><DT >PGCLIENTENCODING, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGconn, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PGCONNECT_TIMEOUT, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGDATA, <A HREF="creating-cluster.html" >Creating a Database Cluster</A > </DT ><DT >PGDATABASE, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGDATESTYLE, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGGEQO, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGHOST, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGHOSTADDR, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGLOCALEDIR, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGOPTIONS, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGPASSWORD, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGPORT, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGREALM, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGREQUIRESSL, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGresult, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PGSERVICE, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGSSLMODE, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGSYSCONFDIR, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGTZ, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGUSER, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >pgxs, <A HREF="xfunc-c.html#XFUNC-C-PGXS" >Extension Building Infrastructure</A > </DT ><DT >pg_aggregate, <A HREF="catalog-pg-aggregate.html" >pg_aggregate</A > </DT ><DT >pg_am, <A HREF="catalog-pg-am.html" >pg_am</A > </DT ><DT >pg_amop, <A HREF="catalog-pg-amop.html" >pg_amop</A > </DT ><DT >pg_amproc, <A HREF="catalog-pg-amproc.html" >pg_amproc</A > </DT ><DT >pg_attrdef, <A HREF="catalog-pg-attrdef.html" >pg_attrdef</A > </DT ><DT >pg_attribute, <A HREF="catalog-pg-attribute.html" >pg_attribute</A > </DT ><DT >pg_cancel_backend, <A HREF="functions-admin.html" >System Administration Functions</A > </DT ><DT >pg_cast, <A HREF="catalog-pg-cast.html" >pg_cast</A > </DT ><DT >pg_class, <A HREF="catalog-pg-class.html" >pg_class</A > </DT ><DT >pg_config, <A HREF="app-pgconfig.html" >pg_config</A > </DT ><DD ><DL ><DT >with libpq, <A HREF="libpq-build.html" >Building libpq Programs</A > </DT ><DD ><DL ></DL ></DD ><DT >with user-defined C functions, <A HREF="xfunc-c.html#AEN30217" >Writing Code</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >pg_constraint, <A HREF="catalog-pg-constraint.html" >pg_constraint</A > </DT ><DT >pg_controldata, <A HREF="app-pgcontroldata.html" >pg_controldata</A > </DT ><DT >pg_conversion, <A HREF="catalog-pg-conversion.html" >pg_conversion</A > </DT ><DT >pg_conversion_is_visible, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_ctl, <A HREF="postmaster-start.html" >Starting the Database Server</A >, <A HREF="app-pg-ctl.html" >pg_ctl</A > </DT ><DT >pg_database, <A HREF="manage-ag-templatedbs.html" >Template Databases</A >, <A HREF="catalog-pg-database.html" >pg_database</A > </DT ><DT >pg_depend, <A HREF="catalog-pg-depend.html" >pg_depend</A > </DT ><DT >pg_description, <A HREF="catalog-pg-description.html" >pg_description</A > </DT ><DT >pg_dump, <A HREF="app-pgdump.html" >pg_dump</A > </DT ><DT >pg_dumpall, <A HREF="app-pg-dumpall.html" >pg_dumpall</A > </DT ><DD ><DL ><DT >use during upgrade, <A HREF="install-upgrading.html" >If You Are Upgrading</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >pg_function_is_visible, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_get_constraintdef, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_get_expr, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_get_indexdef, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_get_ruledef, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_get_serial_sequence, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_get_triggerdef, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_get_userbyid, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_get_viewdef, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_group, <A HREF="catalog-pg-group.html" >pg_group</A > </DT ><DT >pg_hba.conf, <A HREF="client-authentication.html#AUTH-PG-HBA-CONF" >The pg_hba.conf file</A > </DT ><DT >pg_ident.conf, <A HREF="auth-methods.html#AUTH-IDENT-MAPS" >Ident Maps</A > </DT ><DT >pg_index, <A HREF="catalog-pg-index.html" >pg_index</A > </DT ><DT >pg_indexes, <A HREF="view-pg-indexes.html" >pg_indexes</A > </DT ><DT >pg_inherits, <A HREF="catalog-pg-inherits.html" >pg_inherits</A > </DT ><DT >pg_language, <A HREF="catalog-pg-language.html" >pg_language</A > </DT ><DT >pg_largeobject, <A HREF="catalog-pg-largeobject.html" >pg_largeobject</A > </DT ><DT >pg_listener, <A HREF="catalog-pg-listener.html" >pg_listener</A > </DT ><DT >pg_locks, <A HREF="view-pg-locks.html" >pg_locks</A > </DT ><DT >pg_namespace, <A HREF="catalog-pg-namespace.html" >pg_namespace</A > </DT ><DT >pg_opclass, <A HREF="catalog-pg-opclass.html" >pg_opclass</A > </DT ><DT >pg_opclass_is_visible, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_operator, <A HREF="catalog-pg-operator.html" >pg_operator</A > </DT ><DT >pg_operator_is_visible, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_proc, <A HREF="catalog-pg-proc.html" >pg_proc</A > </DT ><DT >pg_restore, <A HREF="app-pgrestore.html" >pg_restore</A > </DT ><DT >pg_rewrite, <A HREF="catalog-pg-rewrite.html" >pg_rewrite</A > </DT ><DT >pg_rules, <A HREF="view-pg-rules.html" >pg_rules</A > </DT ><DT >pg_settings, <A HREF="view-pg-settings.html" >pg_settings</A > </DT ><DT >pg_shadow, <A HREF="catalog-pg-shadow.html" >pg_shadow</A > </DT ><DT >pg_start_backup, <A HREF="functions-admin.html" >System Administration Functions</A > </DT ><DT >pg_statistic, <A HREF="planner-stats.html" >Statistics Used by the Planner</A >, <A HREF="catalog-pg-statistic.html" >pg_statistic</A > </DT ><DT >pg_stats, <A HREF="planner-stats.html" >Statistics Used by the Planner</A >, <A HREF="view-pg-stats.html" >pg_stats</A > </DT ><DT >pg_stop_backup, <A HREF="functions-admin.html" >System Administration Functions</A > </DT ><DT >pg_tables, <A HREF="view-pg-tables.html" >pg_tables</A > </DT ><DT >pg_tablespace, <A HREF="catalog-pg-tablespace.html" >pg_tablespace</A > </DT ><DT >pg_tablespace_databases, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_table_is_visible, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_trigger, <A HREF="catalog-pg-trigger.html" >pg_trigger</A > </DT ><DT >pg_type, <A HREF="catalog-pg-type.html" >pg_type</A > </DT ><DT >pg_type_is_visible, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DT >pg_user, <A HREF="view-pg-user.html" >pg_user</A > </DT ><DT >pg_views, <A HREF="view-pg-views.html" >pg_views</A > </DT ><DT >phantom read, <A HREF="transaction-iso.html" >Transaction Isolation</A > </DT ><DT >PIC, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >PID </DT ><DD ><DL ><DT >determining PID of server process </DT ><DD ><DL ><DT >in libpq, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ></DL ></DD ></DL ></DD ><DT >PITR, <A HREF="backup.html" >Backup and Restore</A > </DT ><DT >PL/Perl, <A HREF="plperl.html" >PL/Perl - Perl Procedural Language</A > </DT ><DT >PL/PerlU, <A HREF="plperl-trusted.html" >Trusted and Untrusted PL/Perl</A > </DT ><DT >PL/pgSQL, <A HREF="plpgsql.html" >PL/pgSQL - SQL Procedural Language</A > </DT ><DT >PL/Python, <A HREF="plpython.html" >PL/Python - Python Procedural Language</A > </DT ><DT >PL/SQL (Oracle) </DT ><DD ><DL ><DT >porting to PL/pgSQL, <A HREF="plpgsql-porting.html" >Porting from Oracle PL/SQL</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >PL/Tcl, <A HREF="pltcl.html" >PL/Tcl - Tcl Procedural Language</A > </DT ><DT >point, <A HREF="datatype-geometric.html#AEN4985" >Points</A > </DT ><DT >point-in-time recovery, <A HREF="backup.html" >Backup and Restore</A > </DT ><DT >polygon, <A HREF="datatype-geometric.html#AEN5087" >Polygons</A > </DT ><DT >polymorphic function, <A HREF="extend-type-system.html#EXTEND-TYPES-POLYMORPHIC" >Polymorphic Types</A > </DT ><DT >polymorphic type, <A HREF="extend-type-system.html#EXTEND-TYPES-POLYMORPHIC" >Polymorphic Types</A > </DT ><DT >port, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >port configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" >Connection Settings</A > </DT ><DT >POSTGRES, <A HREF="history.html#HISTORY-BERKELEY" >The Berkeley POSTGRES Project</A > </DT ><DT >postgres (the program), <A HREF="app-postgres.html" >postgres</A > </DT ><DT >postgres user, <A HREF="runtime.html#POSTGRES-USER" >The PostgreSQL User Account</A > </DT ><DT >Postgres95, <A HREF="history.html#HISTORY-POSTGRES95" >Postgres95</A > </DT ><DT >postgresql.conf, <A HREF="runtime-config.html" >Run-time Configuration</A > </DT ><DT >postmaster, <A HREF="tutorial-arch.html" >Architectural Fundamentals</A >, <A HREF="postmaster-start.html" >Starting the Database Server</A >, <A HREF="app-postmaster.html" >postmaster</A > </DT ><DT >PQbackendPID, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQbinaryTuples, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DD ><DL ><DT >with COPY, <A HREF="libpq-copy.html" >Functions Associated with the COPY Command</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >PQcancel, <A HREF="libpq-cancel.html" >Cancelling Queries in Progress</A > </DT ><DT >PQclear, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PQcmdStatus, <A HREF="libpq-exec.html#LIBPQ-EXEC-NONSELECT" >Retrieving Result Information for Other Commands</A > </DT ><DT >PQcmdTuples, <A HREF="libpq-exec.html#LIBPQ-EXEC-NONSELECT" >Retrieving Result Information for Other Commands</A > </DT ><DT >PQconndefaults, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PQconnectdb, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PQconnectPoll, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PQconnectStart, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PQconsumeInput, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >PQdb, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQendcopy, <A HREF="libpq-copy.html#LIBPQ-COPY-DEPRECATED" >Obsolete Functions for COPY</A > </DT ><DT >PQerrorMessage, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQescapeBytea, <A HREF="libpq-exec.html#LIBPQ-EXEC-ESCAPE-BYTEA" >Escaping Binary Strings for Inclusion in SQL Commands</A > </DT ><DT >PQescapeByteaConn, <A HREF="libpq-exec.html#LIBPQ-EXEC-ESCAPE-BYTEA" >Escaping Binary Strings for Inclusion in SQL Commands</A > </DT ><DT >PQescapeString, <A HREF="libpq-exec.html#LIBPQ-EXEC-ESCAPE-STRING" >Escaping Strings for Inclusion in SQL Commands</A > </DT ><DT >PQescapeStringConn, <A HREF="libpq-exec.html#LIBPQ-EXEC-ESCAPE-STRING" >Escaping Strings for Inclusion in SQL Commands</A > </DT ><DT >PQexec, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PQexecParams, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PQexecPrepared, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PQfformat, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DD ><DL ><DT >with COPY, <A HREF="libpq-copy.html" >Functions Associated with the COPY Command</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >PQfinish, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PQflush, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >PQfmod, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQfn, <A HREF="libpq-fastpath.html" >The Fast-Path Interface</A > </DT ><DT >PQfname, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQfnumber, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQfreeCancel, <A HREF="libpq-cancel.html" >Cancelling Queries in Progress</A > </DT ><DT >PQfreemem, <A HREF="libpq-exec.html#LIBPQ-EXEC-ESCAPE-BYTEA" >Escaping Binary Strings for Inclusion in SQL Commands</A > </DT ><DT >PQfsize, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQftable, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQftablecol, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQftype, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQgetCancel, <A HREF="libpq-cancel.html" >Cancelling Queries in Progress</A > </DT ><DT >PQgetCopyData, <A HREF="libpq-copy.html#LIBPQ-COPY-RECEIVE" >Functions for Receiving COPY Data</A > </DT ><DT >PQgetisnull, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQgetlength, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQgetline, <A HREF="libpq-copy.html#LIBPQ-COPY-DEPRECATED" >Obsolete Functions for COPY</A > </DT ><DT >PQgetlineAsync, <A HREF="libpq-copy.html#LIBPQ-COPY-DEPRECATED" >Obsolete Functions for COPY</A > </DT ><DT >PQgetResult, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >PQgetssl, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQgetvalue, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQhost, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQisBusy, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >PQisnonblocking, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >PQmakeEmptyPGresult, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PQnfields, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DD ><DL ><DT >with COPY, <A HREF="libpq-copy.html" >Functions Associated with the COPY Command</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >PQnotifies, <A HREF="libpq-notify.html" >Asynchronous Notification</A > </DT ><DT >PQntuples, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQoidStatus, <A HREF="libpq-exec.html#LIBPQ-EXEC-NONSELECT" >Retrieving Result Information for Other Commands</A > </DT ><DT >PQoidValue, <A HREF="libpq-exec.html#LIBPQ-EXEC-NONSELECT" >Retrieving Result Information for Other Commands</A > </DT ><DT >PQoptions, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQparameterStatus, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQpass, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQport, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQprepare, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PQprint, <A HREF="libpq-exec.html#LIBPQ-EXEC-SELECT-INFO" >Retrieving Query Result Information</A > </DT ><DT >PQprotocolVersion, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQputCopyData, <A HREF="libpq-copy.html#LIBPQ-COPY-SEND" >Functions for Sending COPY Data</A > </DT ><DT >PQputCopyEnd, <A HREF="libpq-copy.html#LIBPQ-COPY-SEND" >Functions for Sending COPY Data</A > </DT ><DT >PQputline, <A HREF="libpq-copy.html#LIBPQ-COPY-DEPRECATED" >Obsolete Functions for COPY</A > </DT ><DT >PQputnbytes, <A HREF="libpq-copy.html#LIBPQ-COPY-DEPRECATED" >Obsolete Functions for COPY</A > </DT ><DT >PQrequestCancel, <A HREF="libpq-cancel.html" >Cancelling Queries in Progress</A > </DT ><DT >PQreset, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PQresetPoll, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PQresetStart, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PQresStatus, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PQresultErrorField, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PQresultErrorMessage, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PQresultStatus, <A HREF="libpq-exec.html#LIBPQ-EXEC-MAIN" >Main Functions</A > </DT ><DT >PQsendPrepare, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >PQsendQuery, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >PQsendQueryParams, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >PQsendQueryPrepared, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >PQserverVersion, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQsetdb, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PQsetdbLogin, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >PQsetErrorVerbosity, <A HREF="libpq-control.html" >Control Functions</A > </DT ><DT >PQsetnonblocking, <A HREF="libpq-async.html" >Asynchronous Command Processing</A > </DT ><DT >PQsetNoticeProcessor, <A HREF="libpq-notice-processing.html" >Notice Processing</A > </DT ><DT >PQsetNoticeReceiver, <A HREF="libpq-notice-processing.html" >Notice Processing</A > </DT ><DT >PQsocket, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQstatus, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQtrace, <A HREF="libpq-control.html" >Control Functions</A > </DT ><DT >PQtransactionStatus, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQtty, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >PQunescapeBytea, <A HREF="libpq-exec.html#LIBPQ-EXEC-ESCAPE-BYTEA" >Escaping Binary Strings for Inclusion in SQL Commands</A > </DT ><DT >PQuntrace, <A HREF="libpq-control.html" >Control Functions</A > </DT ><DT >PQuser, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DT >predicate locking, <A HREF="transaction-iso.html#MVCC-SERIALIZABILITY" >Serializable Isolation versus True Serializability</A > </DT ><DT >preload_libraries configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-KERNEL" >Kernel Resource Usage</A > </DT ><DT >PREPARE, <A HREF="sql-prepare.html" >PREPARE</A > </DT ><DT >prepared statements </DT ><DD ><DL ><DT >creating, <A HREF="sql-prepare.html" >PREPARE</A > </DT ><DD ><DL ></DL ></DD ><DT >executing, <A HREF="sql-execute.html" >EXECUTE</A > </DT ><DD ><DL ></DL ></DD ><DT >removing, <A HREF="sql-deallocate.html" >DEALLOCATE</A > </DT ><DD ><DL ></DL ></DD ><DT >showing the query plan, <A HREF="sql-explain.html" >EXPLAIN</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >preparing a query </DT ><DD ><DL ><DT >in PL/Tcl, <A HREF="pltcl-dbaccess.html" >Database Access from PL/Tcl</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/pgSQL, <A HREF="plpgsql.html#PLPGSQL-OVERVIEW" >Overview</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/Python, <A HREF="plpython-database.html" >Database Access</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >pre_auth_delay configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-DEVELOPER" >Developer Options</A > </DT ><DT >primary key, <A HREF="ddl-constraints.html#AEN2018" >Primary Keys</A > </DT ><DT >privilege, <A HREF="ddl-priv.html" >Privileges</A >, <A HREF="privileges.html" >Privileges</A > </DT ><DD ><DL ><DT >querying, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >with rules, <A HREF="rules-privileges.html" >Rules and Privileges</A > </DT ><DD ><DL ></DL ></DD ><DT >for schemas, <A HREF="ddl-schemas.html#DDL-SCHEMAS-PRIV" >Schemas and Privileges</A > </DT ><DD ><DL ></DL ></DD ><DT >with views, <A HREF="rules-privileges.html" >Rules and Privileges</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >procedural language, <A HREF="xplang.html" >Procedural Languages</A > </DT ><DD ><DL ><DT >handler for, <A HREF="plhandler.html" >Writing A Procedural Language Handler</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >ps </DT ><DD ><DL ><DT >to monitor activity, <A HREF="monitoring.html#MONITORING-PS" >Standard Unix Tools</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >psql, <A HREF="tutorial-accessdb.html" >Accessing a Database</A >, <A HREF="app-psql.html" >psql</A > </DT ><DT >Python, <A HREF="plpython.html" >PL/Python - Python Procedural Language</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN78389" >Q</A ></H2 ><DL ><DT >qualified name, <A HREF="ddl-schemas.html#DDL-SCHEMAS-CREATE" >Creating a Schema</A > </DT ><DT >query, <A HREF="tutorial-select.html" >Querying a Table</A >, <A HREF="queries.html" >Queries</A > </DT ><DT >query plan, <A HREF="performance-tips.html#USING-EXPLAIN" >Using EXPLAIN</A > </DT ><DT >query tree, <A HREF="rules.html#QUERYTREE" >The Query Tree</A > </DT ><DT >quotation marks </DT ><DD ><DL ><DT >and identifiers, <A HREF="sql-syntax.html#SQL-SYNTAX-IDENTIFIERS" >Identifiers and Key Words</A > </DT ><DD ><DL ></DL ></DD ><DT >escaping, <A HREF="sql-syntax.html#SQL-SYNTAX-STRINGS" >String Constants</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >quote_ident, <A HREF="functions-string.html" >String Functions and Operators</A > </DT ><DD ><DL ><DT >use in PL/pgSQL, <A HREF="plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN" >Executing Dynamic Commands</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >quote_literal, <A HREF="functions-string.html" >String Functions and Operators</A > </DT ><DD ><DL ><DT >use in PL/pgSQL, <A HREF="plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN" >Executing Dynamic Commands</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN78420" >R</A ></H2 ><DL ><DT >R-tree </DT ><DD ><DL ><DT >see index</DT ></DL ></DD ><DT >random_page_cost configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-CONSTANTS" > Planner Cost Constants </A > </DT ><DT >range table, <A HREF="rules.html#QUERYTREE" >The Query Tree</A > </DT ><DT >read-only transaction, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A > </DT ><DT >readline, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >real, <A HREF="datatype.html#DATATYPE-FLOAT" >Floating-Point Types</A > </DT ><DT >record, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >rectangle, <A HREF="datatype-geometric.html#AEN5026" >Boxes</A > </DT ><DT >redirect_stderr configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where to log</A > </DT ><DT >referential integrity, <A HREF="tutorial-fk.html" >Foreign Keys</A >, <A HREF="ddl-constraints.html#DDL-CONSTRAINTS-FK" >Foreign Keys</A > </DT ><DT >regclass, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regex_flavor configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-VERSION" >Previous PostgreSQL Versions</A > </DT ><DT >regoper, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regoperator, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regproc, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regprocedure, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regression test, <A HREF="install-procedure.html" >Installation Procedure</A > </DT ><DT >regression tests, <A HREF="regress.html" >Regression Tests</A > </DT ><DT >regtype, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regular expression, <A HREF="functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP" >SIMILAR TO Regular Expressions</A >, <A HREF="functions-matching.html#FUNCTIONS-POSIX-REGEXP" >POSIX Regular Expressions</A > </DT ><DD ><DL ><DT >see also pattern matching</DT ></DL ></DD ><DT >regular expressions, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-VERSION" >Previous PostgreSQL Versions</A > </DT ><DT >reindex, <A HREF="routine-reindex.html" >Routine Reindexing</A >, <A HREF="sql-reindex.html" >REINDEX</A > </DT ><DT >relation, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >relational database, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >RELEASE SAVEPOINT, <A HREF="sql-release-savepoint.html" >RELEASE SAVEPOINT</A > </DT ><DT >rendezvous_name configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" >Connection Settings</A > </DT ><DT >RESET, <A HREF="sql-reset.html" >RESET</A > </DT ><DT >RESTRICT </DT ><DD ><DL ><DT >with DROP, <A HREF="ddl-depend.html" >Dependency Tracking</A > </DT ><DD ><DL ></DL ></DD ><DT >foreign key action, <A HREF="ddl-constraints.html#DDL-CONSTRAINTS-FK" >Foreign Keys</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >REVOKE, <A HREF="privileges.html" >Privileges</A >, <A HREF="sql-revoke.html" >REVOKE</A > </DT ><DT >right join, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DT >ROLLBACK, <A HREF="sql-rollback.html" >ROLLBACK</A > </DT ><DT >ROLLBACK TO SAVEPOINT, <A HREF="sql-rollback-to.html" >ROLLBACK TO SAVEPOINT</A > </DT ><DT >row, <A HREF="tutorial-concepts.html" >Concepts</A >, <A HREF="sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS" >Row Constructors</A >, <A HREF="ddl.html#DDL-BASICS" >Table Basics</A > </DT ><DT >row type, <A HREF="rowtypes.html" >Composite Types</A > </DT ><DD ><DL ><DT >constructor, <A HREF="sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS" >Row Constructors</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >rule, <A HREF="rules.html" >The Rule System</A > </DT ><DD ><DL ><DT >and views, <A HREF="rules-views.html" >Views and the Rule System</A > </DT ><DD ><DL ></DL ></DD ><DT >for DELETE, <A HREF="rules-update.html" >Rules on INSERT, UPDATE, and DELETE</A > </DT ><DD ><DL ></DL ></DD ><DT >for INSERT, <A HREF="rules-update.html" >Rules on INSERT, UPDATE, and DELETE</A > </DT ><DD ><DL ></DL ></DD ><DT >for SELECT, <A HREF="rules-views.html#RULES-SELECT" >How SELECT Rules Work</A > </DT ><DD ><DL ></DL ></DD ><DT >compared with triggers, <A HREF="rules-triggers.html" >Rules versus Triggers</A > </DT ><DD ><DL ></DL ></DD ><DT >for UPDATE, <A HREF="rules-update.html" >Rules on INSERT, UPDATE, and DELETE</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN78551" >S</A ></H2 ><DL ><DT >SAVEPOINT, <A HREF="sql-savepoint.html" >SAVEPOINT</A > </DT ><DT >savepoints </DT ><DD ><DL ><DT >defining, <A HREF="sql-savepoint.html" >SAVEPOINT</A > </DT ><DD ><DL ></DL ></DD ><DT >releasing, <A HREF="sql-release-savepoint.html" >RELEASE SAVEPOINT</A > </DT ><DD ><DL ></DL ></DD ><DT >rolling back, <A HREF="sql-rollback-to.html" >ROLLBACK TO SAVEPOINT</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >scalar </DT ><DD ><DL ><DT >see expression</DT ></DL ></DD ><DT >schema, <A HREF="ddl-schemas.html" >Schemas</A >, <A HREF="managing-databases.html#MANAGE-AG-OVERVIEW" >Overview</A > </DT ><DD ><DL ><DT >creating, <A HREF="ddl-schemas.html#DDL-SCHEMAS-CREATE" >Creating a Schema</A > </DT ><DD ><DL ></DL ></DD ><DT >current, <A HREF="ddl-schemas.html#DDL-SCHEMAS-PATH" >The Schema Search Path</A >, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >public, <A HREF="ddl-schemas.html#DDL-SCHEMAS-PUBLIC" >The Public Schema</A > </DT ><DD ><DL ></DL ></DD ><DT >removing, <A HREF="ddl-schemas.html#DDL-SCHEMAS-CREATE" >Creating a Schema</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >SCO OpenServer </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >search path, <A HREF="ddl-schemas.html#DDL-SCHEMAS-PATH" >The Schema Search Path</A > </DT ><DD ><DL ><DT >current, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >search_path, <A HREF="ddl-schemas.html#DDL-SCHEMAS-PATH" >The Schema Search Path</A > </DT ><DT >search_path configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A > </DT ><DT >SELECT, <A HREF="tutorial-select.html" >Querying a Table</A >, <A HREF="queries.html" >Queries</A >, <A HREF="sql-select.html" >SELECT</A > </DT ><DD ><DL ><DT >select list, <A HREF="queries-select-lists.html" >Select Lists</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >SELECT INTO, <A HREF="sql-selectinto.html" >SELECT INTO</A > </DT ><DD ><DL ><DT >in PL/pgSQL, <A HREF="plpgsql-statements.html#PLPGSQL-SELECT-INTO" >SELECT INTO</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >semaphores, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DT >sequence, <A HREF="functions-sequence.html" >Sequence Manipulation Functions</A > </DT ><DD ><DL ><DT >and serial type, <A HREF="datatype.html#DATATYPE-SERIAL" >Serial Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >sequential scan, <A HREF="runtime-config.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A > </DT ><DT >serial, <A HREF="datatype.html#DATATYPE-SERIAL" >Serial Types</A > </DT ><DT >serial4, <A HREF="datatype.html#DATATYPE-SERIAL" >Serial Types</A > </DT ><DT >serial8, <A HREF="datatype.html#DATATYPE-SERIAL" >Serial Types</A > </DT ><DT >serializability, <A HREF="transaction-iso.html#MVCC-SERIALIZABILITY" >Serializable Isolation versus True Serializability</A > </DT ><DT >server log, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING" >Error Reporting and Logging</A > </DT ><DD ><DL ><DT >log file maintenance, <A HREF="logfile-maintenance.html" >Log File Maintenance</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >server_encoding configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-PRESET" >Preset Options</A > </DT ><DT >server_version configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-PRESET" >Preset Options</A > </DT ><DT >SET, <A HREF="functions-admin.html" >System Administration Functions</A >, <A HREF="sql-set.html" >SET</A > </DT ><DT >SET CONSTRAINTS, <A HREF="sql-set-constraints.html" >SET CONSTRAINTS</A > </DT ><DT >set difference, <A HREF="queries-union.html" >Combining Queries</A > </DT ><DT >set intersection, <A HREF="queries-union.html" >Combining Queries</A > </DT ><DT >set operation, <A HREF="queries-union.html" >Combining Queries</A > </DT ><DT >set returning functions </DT ><DD ><DL ><DT >functions, <A HREF="functions-srf.html" >Set Returning Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >SET SESSION AUTHORIZATION, <A HREF="sql-set-session-authorization.html" >SET SESSION AUTHORIZATION</A > </DT ><DT >SET TRANSACTION, <A HREF="sql-set-transaction.html" >SET TRANSACTION</A > </DT ><DT >set union, <A HREF="queries-union.html" >Combining Queries</A > </DT ><DT >SETOF, <A HREF="xfunc-sql.html" >Query Language (SQL) Functions</A > </DT ><DT >setval, <A HREF="functions-sequence.html" >Sequence Manipulation Functions</A > </DT ><DT >set_bit, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DT >set_byte, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DT >shared library, <A HREF="install-post.html#AEN15603" >Shared Libraries</A >, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >shared memory, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DT >shared_buffers configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-MEMORY" >Memory</A > </DT ><DT >SHMMAX, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DT >SHOW, <A HREF="functions-admin.html" >System Administration Functions</A >, <A HREF="sql-show.html" >SHOW</A > </DT ><DT >shutdown, <A HREF="postmaster-shutdown.html" >Shutting Down the Server</A > </DT ><DT >SIGHUP, <A HREF="runtime-config.html" >Run-time Configuration</A >, <A HREF="client-authentication.html#AUTH-PG-HBA-CONF" >The pg_hba.conf file</A >, <A HREF="auth-methods.html#AUTH-IDENT-MAPS" >Ident Maps</A > </DT ><DT >SIGINT, <A HREF="postmaster-shutdown.html" >Shutting Down the Server</A > </DT ><DT >signal </DT ><DD ><DL ><DT >backend processes, <A HREF="functions-admin.html" >System Administration Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >significant digits, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DT >SIGQUIT, <A HREF="postmaster-shutdown.html" >Shutting Down the Server</A > </DT ><DT >SIGTERM, <A HREF="postmaster-shutdown.html" >Shutting Down the Server</A > </DT ><DT >silent_mode configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHEN" >When To Log</A > </DT ><DT >SIMILAR TO, <A HREF="functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP" >SIMILAR TO Regular Expressions</A > </DT ><DT >sliced bread </DT ><DD ><DL ><DT >see TOAST</DT ></DL ></DD ><DT >smallint, <A HREF="datatype.html#DATATYPE-INT" >Integer Types</A > </DT ><DT >Solaris </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >start script, <A HREF="postmaster-start.html" >Starting the Database Server</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >SOME, <A HREF="functions-aggregate.html" >Aggregate Functions</A >, <A HREF="functions-subquery.html" >Subquery Expressions</A >, <A HREF="functions-comparisons.html" >Row and Array Comparisons</A > </DT ><DT >sorting, <A HREF="queries-order.html" >Sorting Rows</A > </DT ><DT >SPI, <A HREF="spi.html" >Server Programming Interface</A > </DT ><DT >SPI_connect, <A HREF="spi-spi-connect.html" >SPI_connect</A > </DT ><DT >SPI_copytuple, <A HREF="spi-spi-copytuple.html" >SPI_copytuple</A > </DT ><DT >SPI_cursor_close, <A HREF="spi-spi-cursor-close.html" >SPI_cursor_close</A > </DT ><DT >SPI_cursor_fetch, <A HREF="spi-spi-cursor-fetch.html" >SPI_cursor_fetch</A > </DT ><DT >SPI_cursor_find, <A HREF="spi-spi-cursor-find.html" >SPI_cursor_find</A > </DT ><DT >SPI_cursor_move, <A HREF="spi-spi-cursor-move.html" >SPI_cursor_move</A > </DT ><DT >SPI_cursor_open, <A HREF="spi-spi-cursor-open.html" >SPI_cursor_open</A > </DT ><DT >SPI_exec, <A HREF="spi-spi-exec.html" >SPI_exec</A > </DT ><DT >SPI_execp, <A HREF="spi-spi-execp.html" >SPI_execp</A > </DT ><DT >SPI_execute, <A HREF="spi-spi-execute.html" >SPI_execute</A > </DT ><DT >SPI_execute_plan, <A HREF="spi-spi-execute-plan.html" >SPI_execute_plan</A > </DT ><DT >spi_exec_query </DT ><DD ><DL ><DT >in PL/Perl, <A HREF="plperl-database.html" >Database Access from PL/Perl</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >SPI_finish, <A HREF="spi-spi-finish.html" >SPI_finish</A > </DT ><DT >SPI_fname, <A HREF="spi-spi-fname.html" >SPI_fname</A > </DT ><DT >SPI_fnumber, <A HREF="spi-spi-fnumber.html" >SPI_fnumber</A > </DT ><DT >SPI_freeplan, <A HREF="spi-spi-freeplan.html" >SPI_freeplan</A > </DT ><DT >SPI_freetuple, <A HREF="spi-spi-freetuple.html" >SPI_freetuple</A > </DT ><DT >SPI_freetuptable, <A HREF="spi-spi-freetupletable.html" >SPI_freetuptable</A > </DT ><DT >SPI_getargcount, <A HREF="spi-spi-getargcount.html" >SPI_getargcount</A > </DT ><DT >SPI_getargtypeid, <A HREF="spi-spi-getargtypeid.html" >SPI_getargtypeid</A > </DT ><DT >SPI_getbinval, <A HREF="spi-spi-getbinval.html" >SPI_getbinval</A > </DT ><DT >SPI_getrelname, <A HREF="spi-spi-getrelname.html" >SPI_getrelname</A > </DT ><DT >SPI_gettype, <A HREF="spi-spi-gettype.html" >SPI_gettype</A > </DT ><DT >SPI_gettypeid, <A HREF="spi-spi-gettypeid.html" >SPI_gettypeid</A > </DT ><DT >SPI_getvalue, <A HREF="spi-spi-getvalue.html" >SPI_getvalue</A > </DT ><DT >SPI_is_cursor_plan, <A HREF="spi-spi-is-cursor-plan.html" >SPI_is_cursor_plan</A > </DT ><DT >spi_lastoid, <A HREF="pltcl-dbaccess.html" >Database Access from PL/Tcl</A > </DT ><DT >SPI_modifytuple, <A HREF="spi-spi-modifytuple.html" >SPI_modifytuple</A > </DT ><DT >SPI_palloc, <A HREF="spi-spi-palloc.html" >SPI_palloc</A > </DT ><DT >SPI_pfree, <A HREF="spi-spi-pfree.html" >SPI_pfree</A > </DT ><DT >SPI_pop, <A HREF="spi-spi-pop.html" >SPI_pop</A > </DT ><DT >SPI_prepare, <A HREF="spi-spi-prepare.html" >SPI_prepare</A > </DT ><DT >SPI_push, <A HREF="spi-spi-push.html" >SPI_push</A > </DT ><DT >SPI_repalloc, <A HREF="spi-realloc.html" >SPI_repalloc</A > </DT ><DT >SPI_returntuple, <A HREF="spi-spi-returntuple.html" >SPI_returntuple</A > </DT ><DT >SPI_saveplan, <A HREF="spi-spi-saveplan.html" >SPI_saveplan</A > </DT ><DT >sql_inheritance configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-VERSION" >Previous PostgreSQL Versions</A > </DT ><DT >ssh, <A HREF="ssh-tunnels.html" >Secure TCP/IP Connections with SSH Tunnels</A > </DT ><DT >SSL, <A HREF="ssl-tcp.html" >Secure TCP/IP Connections with SSL</A >, <A HREF="libpq-ssl.html" >SSL Support</A > </DT ><DD ><DL ><DT >with libpq, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A >, <A HREF="libpq-status.html" >Connection Status Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >ssl configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SECURITY" >Security and Authentication</A > </DT ><DT >STABLE, <A HREF="xfunc-volatility.html" >Function Volatility Categories</A > </DT ><DT >standard deviation, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DT >START TRANSACTION, <A HREF="sql-start-transaction.html" >START TRANSACTION</A > </DT ><DT >statement_timeout configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A > </DT ><DT >statistics, <A HREF="monitoring-stats.html" >The Statistics Collector</A > </DT ><DD ><DL ><DT >of the planner, <A HREF="planner-stats.html" >Statistics Used by the Planner</A >, <A HREF="maintenance.html#VACUUM-FOR-STATISTICS" >Updating planner statistics</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >stats_block_level configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR" >Query and Index Statistics Collector</A > </DT ><DT >stats_command_string configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR" >Query and Index Statistics Collector</A > </DT ><DT >stats_reset_on_server_start configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR" >Query and Index Statistics Collector</A > </DT ><DT >stats_row_level configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR" >Query and Index Statistics Collector</A > </DT ><DT >stats_start_collector configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR" >Query and Index Statistics Collector</A > </DT ><DT >string </DT ><DD ><DL ><DT >see character string</DT ></DL ></DD ><DT >strings </DT ><DD ><DL ><DT >backslash quotes, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-VERSION" >Previous PostgreSQL Versions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >subquery, <A HREF="tutorial-agg.html" >Aggregate Functions</A >, <A HREF="sql-expressions.html#SQL-SYNTAX-SCALAR-SUBQUERIES" >Scalar Subqueries</A >, <A HREF="queries-table-expressions.html#QUERIES-SUBQUERIES" >Subqueries</A >, <A HREF="functions-subquery.html" >Subquery Expressions</A > </DT ><DT >subscript, <A HREF="sql-expressions.html#AEN1623" >Subscripts</A > </DT ><DT >substring, <A HREF="functions-string.html" >String Functions and Operators</A >, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A >, <A HREF="functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP" >SIMILAR TO Regular Expressions</A > </DT ><DT >sum, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >superuser, <A HREF="tutorial-accessdb.html" >Accessing a Database</A >, <A HREF="user-attributes.html" >User Attributes</A > </DT ><DT >superuser_reserved_connections configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" >Connection Settings</A > </DT ><DT >syntax </DT ><DD ><DL ><DT >SQL, <A HREF="sql-syntax.html" >SQL Syntax</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >syslog_facility configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where to log</A > </DT ><DT >syslog_identity configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where to log</A > </DT ><DT >system catalog </DT ><DD ><DL ><DT >schema, <A HREF="ddl-schemas.html#DDL-SCHEMAS-CATALOG" >The System Catalog Schema</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN78957" >T</A ></H2 ><DL ><DT >table, <A HREF="tutorial-concepts.html" >Concepts</A >, <A HREF="ddl.html#DDL-BASICS" >Table Basics</A > </DT ><DD ><DL ><DT >creating, <A HREF="ddl.html#DDL-BASICS" >Table Basics</A > </DT ><DD ><DL ></DL ></DD ><DT >modifying, <A HREF="ddl-alter.html" >Modifying Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >removing, <A HREF="ddl.html#DDL-BASICS" >Table Basics</A > </DT ><DD ><DL ></DL ></DD ><DT >renaming, <A HREF="ddl-alter.html#AEN2349" >Renaming a Table</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >table expression, <A HREF="queries-table-expressions.html" >Table Expressions</A > </DT ><DT >table function, <A HREF="queries-table-expressions.html#QUERIES-TABLEFUNCTIONS" >Table Functions</A > </DT ><DT >tableoid, <A HREF="ddl-system-columns.html" >System Columns</A > </DT ><DT >tablespace, <A HREF="manage-ag-tablespaces.html" >Tablespaces</A > </DT ><DD ><DL ><DT >default, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >target list, <A HREF="rules.html#QUERYTREE" >The Query Tree</A > </DT ><DT >Tcl, <A HREF="pltcl.html" >PL/Tcl - Tcl Procedural Language</A > </DT ><DT >template0, <A HREF="manage-ag-templatedbs.html" >Template Databases</A > </DT ><DT >template1, <A HREF="manage-ag-createdb.html" >Creating a Database</A >, <A HREF="manage-ag-templatedbs.html" >Template Databases</A > </DT ><DT >test, <A HREF="regress.html" >Regression Tests</A > </DT ><DT >text, <A HREF="datatype-character.html" >Character Types</A > </DT ><DT >threads </DT ><DD ><DL ><DT >with libpq, <A HREF="libpq-threading.html" >Behavior in Threaded Programs</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >tid, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >time, <A HREF="datatype-datetime.html" >Date/Time Types</A >, <A HREF="datatype-datetime.html#AEN4410" >Times</A > </DT ><DD ><DL ><DT >constants, <A HREF="datatype-datetime.html#AEN4599" >Special Values</A > </DT ><DD ><DL ></DL ></DD ><DT >current, <A HREF="functions-datetime.html#FUNCTIONS-DATETIME-CURRENT" >Current Date/Time</A > </DT ><DD ><DL ></DL ></DD ><DT >output format, <A HREF="datatype-datetime.html#DATATYPE-DATETIME-OUTPUT" >Date/Time Output</A > </DT ><DD ><DL ><DT >see also formatting</DT ></DL ></DD ></DL ></DD ><DT >time span, <A HREF="datatype-datetime.html" >Date/Time Types</A > </DT ><DT >time with time zone, <A HREF="datatype-datetime.html" >Date/Time Types</A >, <A HREF="datatype-datetime.html#AEN4410" >Times</A > </DT ><DT >time without time zone, <A HREF="datatype-datetime.html" >Date/Time Types</A >, <A HREF="datatype-datetime.html#AEN4410" >Times</A > </DT ><DT >time zone, <A HREF="datatype-datetime.html#DATATYPE-TIMEZONES" >Time Zones</A >, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DD ><DL ><DT >Australian, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DD ><DL ></DL ></DD ><DT >configuration names, <A HREF="datetime-keywords.html" >Date/Time Key Words</A > </DT ><DD ><DL ></DL ></DD ><DT >conversion, <A HREF="functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT" >AT TIME ZONE</A > </DT ><DD ><DL ></DL ></DD ><DT >input abbreviations, <A HREF="datetime-keywords.html" >Date/Time Key Words</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >timelines, <A HREF="backup.html" >Backup and Restore</A > </DT ><DT >timeout </DT ><DD ><DL ><DT >client authentication, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SECURITY" >Security and Authentication</A > </DT ><DD ><DL ></DL ></DD ><DT >deadlock, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOCKS" >Lock Management</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >timestamp, <A HREF="datatype-datetime.html" >Date/Time Types</A >, <A HREF="datatype-datetime.html#AEN4516" >Time Stamps</A > </DT ><DT >timestamp with time zone, <A HREF="datatype-datetime.html" >Date/Time Types</A >, <A HREF="datatype-datetime.html#AEN4516" >Time Stamps</A > </DT ><DT >timestamp without time zone, <A HREF="datatype-datetime.html" >Date/Time Types</A >, <A HREF="datatype-datetime.html#AEN4516" >Time Stamps</A > </DT ><DT >timezone configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A > </DT ><DT >TOAST, <A HREF="storage-toast.html" >TOAST</A > </DT ><DD ><DL ><DT >and user-defined types, <A HREF="xtypes.html" >User-Defined Types</A > </DT ><DD ><DL ></DL ></DD ><DT >per-column storage settings, <A HREF="sql-altertable.html#AEN37155" >Description</A > </DT ><DD ><DL ></DL ></DD ><DT >versus large objects, <A HREF="largeobjects.html#LO-HISTORY" >History</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >token, <A HREF="sql-syntax.html#SQL-SYNTAX-LEXICAL" >Lexical Structure</A > </DT ><DT >to_char, <A HREF="functions-formatting.html" >Data Type Formatting Functions</A > </DT ><DT >trace_notify configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-DEVELOPER" >Developer Options</A > </DT ><DT >transaction, <A HREF="tutorial-transactions.html" >Transactions</A > </DT ><DT >transaction ID </DT ><DD ><DL ><DT >wraparound, <A HREF="maintenance.html#VACUUM-FOR-WRAPAROUND" >Preventing transaction ID wraparound failures</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >transaction isolation, <A HREF="transaction-iso.html" >Transaction Isolation</A > </DT ><DT >transaction isolation level, <A HREF="transaction-iso.html" >Transaction Isolation</A >, <A HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A > </DT ><DD ><DL ><DT >read committed, <A HREF="transaction-iso.html#XACT-READ-COMMITTED" >Read Committed Isolation Level</A > </DT ><DD ><DL ></DL ></DD ><DT >serializable, <A HREF="transaction-iso.html#XACT-SERIALIZABLE" >Serializable Isolation Level</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >transaction log </DT ><DD ><DL ><DT >see WAL</DT ></DL ></DD ><DT >transform_null_equals configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE-CLIENTS" >Platform and Client Compatibility</A > </DT ><DT >trigger, <A HREF="datatype-pseudo.html" >Pseudo-Types</A >, <A HREF="triggers.html" >Triggers</A > </DT ><DD ><DL ><DT >arguments for trigger functions, <A HREF="triggers.html#TRIGGER-DEFINITION" >Overview of Trigger Behavior</A > </DT ><DD ><DL ></DL ></DD ><DT >in C, <A HREF="trigger-interface.html" >Writing Trigger Functions in C</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/pgSQL, <A HREF="plpgsql-trigger.html" >Trigger Procedures</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/Python, <A HREF="plpython-trigger.html" >Trigger Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >in PL/Tcl, <A HREF="pltcl-trigger.html" >Trigger Procedures in PL/Tcl</A > </DT ><DD ><DL ></DL ></DD ><DT >compared with rules, <A HREF="rules-triggers.html" >Rules versus Triggers</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >Tru64 UNIX </DT ><DD ><DL ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >true, <A HREF="datatype-boolean.html" >Boolean Type</A > </DT ><DT >TRUNCATE, <A HREF="sql-truncate.html" >TRUNCATE</A > </DT ><DT >trusted </DT ><DD ><DL ><DT >PL/Perl, <A HREF="plperl-trusted.html" >Trusted and Untrusted PL/Perl</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >type </DT ><DD ><DL ><DT >see data type</DT ><DT >polymorphic, <A HREF="extend-type-system.html#EXTEND-TYPES-POLYMORPHIC" >Polymorphic Types</A > </DT ></DL ></DD ><DT >type cast, <A HREF="sql-syntax.html#AEN1246" >Numeric Constants</A >, <A HREF="sql-expressions.html#SQL-SYNTAX-TYPE-CASTS" >Type Casts</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN79150" >U</A ></H2 ><DL ><DT >UNION, <A HREF="queries-union.html" >Combining Queries</A > </DT ><DD ><DL ><DT >determination of result type, <A HREF="typeconv-union-case.html" >UNION, CASE, and ARRAY Constructs</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >unique constraint, <A HREF="ddl-constraints.html#AEN1996" >Unique Constraints</A > </DT ><DT >Unix domain socket, <A HREF="libpq.html#LIBPQ-CONNECT" >Database Connection Control Functions</A > </DT ><DT >UnixWare </DT ><DD ><DL ><DT >IPC configuration, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DD ><DL ></DL ></DD ><DT >shared library, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >unix_socket_directory configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" >Connection Settings</A > </DT ><DT >unix_socket_group configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" >Connection Settings</A > </DT ><DT >unix_socket_permissions configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" >Connection Settings</A > </DT ><DT >UNLISTEN, <A HREF="sql-unlisten.html" >UNLISTEN</A > </DT ><DT >unqualified name, <A HREF="ddl-schemas.html#DDL-SCHEMAS-PATH" >The Schema Search Path</A > </DT ><DT >UPDATE, <A HREF="tutorial-update.html" >Updates</A >, <A HREF="dml-update.html" >Updating Data</A >, <A HREF="sql-update.html" >UPDATE</A > </DT ><DT >updating, <A HREF="dml-update.html" >Updating Data</A > </DT ><DT >upgrading, <A HREF="install-upgrading.html" >If You Are Upgrading</A >, <A HREF="migration.html" >Migration Between Releases</A > </DT ><DT >user, <A HREF="user-manag.html#DATABASE-USERS" >Database Users</A > </DT ><DD ><DL ><DT >current, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN79201" >V</A ></H2 ><DL ><DT >vacuum, <A HREF="maintenance.html#ROUTINE-VACUUMING" >Routine Vacuuming</A >, <A HREF="sql-vacuum.html" >VACUUM</A > </DT ><DT >vacuumdb, <A HREF="app-vacuumdb.html" >vacuumdb</A > </DT ><DT >vacuum_cost_delay configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST" >Cost-Based Vacuum Delay</A > </DT ><DT >vacuum_cost_limit configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST" >Cost-Based Vacuum Delay</A > </DT ><DT >vacuum_cost_page_dirty configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST" >Cost-Based Vacuum Delay</A > </DT ><DT >vacuum_cost_page_hit configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST" >Cost-Based Vacuum Delay</A > </DT ><DT >vacuum_cost_page_miss configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST" >Cost-Based Vacuum Delay</A > </DT ><DT >value expression, <A HREF="sql-expressions.html" >Value Expressions</A > </DT ><DT >varchar, <A HREF="datatype-character.html" >Character Types</A > </DT ><DT >variance, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DT >version, <A HREF="tutorial-accessdb.html" >Accessing a Database</A >, <A HREF="functions-info.html" >System Information Functions</A > </DT ><DD ><DL ><DT >compatibility, <A HREF="migration.html" >Migration Between Releases</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >view, <A HREF="tutorial-views.html" >Views</A > </DT ><DD ><DL ><DT >implementation through rules, <A HREF="rules-views.html" >Views and the Rule System</A > </DT ><DD ><DL ></DL ></DD ><DT >updating, <A HREF="rules-update.html#RULES-UPDATE-VIEWS" >Cooperation with Views</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >void, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >VOLATILE, <A HREF="xfunc-volatility.html" >Function Volatility Categories</A > </DT ><DT >volatility </DT ><DD ><DL ><DT >functions, <A HREF="xfunc-volatility.html" >Function Volatility Categories</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN79257" >W</A ></H2 ><DL ><DT >WAL, <A HREF="wal.html" >Write-Ahead Logging (WAL)</A > </DT ><DT >wal_buffers configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-WAL-SETTINGS" >Settings</A > </DT ><DT >wal_debug configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-DEVELOPER" >Developer Options</A > </DT ><DT >wal_sync_method configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-WAL-SETTINGS" >Settings</A > </DT ><DT >WHERE, <A HREF="queries-table-expressions.html#QUERIES-WHERE" >The WHERE Clause</A > </DT ><DT >where to log, <A HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where to log</A > </DT ><DT >work_mem configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE-MEMORY" >Memory</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN79280" >X</A ></H2 ><DL ><DT >xid, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >xmax, <A HREF="ddl-system-columns.html" >System Columns</A > </DT ><DT >xmin, <A HREF="ddl-system-columns.html" >System Columns</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN79291" >Y</A ></H2 ><DL ><DT >yacc, <A HREF="install-requirements.html" >Requirements</A > </DT ></DL ></DIV ><DIV CLASS="INDEXDIV" ><H2 CLASS="INDEXDIV" ><A NAME="AEN79296" >Z</A ></H2 ><DL ><DT >zero_damaged_pages configuration parameter, <A HREF="runtime-config.html#RUNTIME-CONFIG-DEVELOPER" >Developer Options</A > </DT ><DT >zlib, <A HREF="install-procedure.html" >Installation Procedure</A > </DT ></DL ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="biblio.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" > </TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Bibliography</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" > </TD ></TR ></TABLE ></DIV ></BODY ></HTML >