|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /proc/self/root/usr/share/doc/postgresql-8.1.9/html/ |
Upload File : |
<!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.1.9 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-04-20T04:40:08"></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.1.9 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="AEN82711"
>Symbols</A
></H2
><DL
><DT
>$,
<A
HREF="sql-expressions.html#AEN1626"
>Positional Parameters</A
>
</DT
><DT
>$libdir,
<A
HREF="xfunc-c.html#XFUNC-C-DYNLOAD"
>Dynamic Loading</A
>
</DT
><DT
>&#960;,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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="AEN82728"
>A</A
></H2
><DL
><DT
>ABORT,
<A
HREF="sql-abort.html"
>ABORT</A
>
</DT
><DT
>abs,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>acos,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>add_missing_from configuration parameter,
<A
HREF="runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION"
>Previous PostgreSQL Versions</A
>
</DT
><DT
>age,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</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 ROLE,
<A
HREF="role-attributes.html"
>Role Attributes</A
>,
<A
HREF="sql-alterrole.html"
>ALTER ROLE</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="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-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING"
>Archiving</A
>
</DT
><DT
>area,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</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#AEN5596"
>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 Related 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
>ascii,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>asin,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>AT TIME ZONE,
<A
HREF="functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT"
>AT TIME ZONE</A
>
</DT
><DT
>atan,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>atan2,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>australian_timezones configuration parameter,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>
</DT
><DT
>authentication_timeout configuration parameter,
<A
HREF="runtime-config-connection.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
>autovacuum
</DT
><DD
><DL
><DT
>general information,
<A
HREF="maintenance.html#AUTOVACUUM"
>The auto-vacuum daemon</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>global configuration parameters,
<A
HREF="runtime-config-autovacuum.html"
>Automatic Vacuuming</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>table-specific configuration,
<A
HREF="catalog-pg-autovacuum.html"
>pg_autovacuum</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>autovacuum configuration parameter,
<A
HREF="runtime-config-autovacuum.html"
>Automatic Vacuuming</A
>
</DT
><DT
>autovacuum_analyze_scale_factor configuration parameter,
<A
HREF="runtime-config-autovacuum.html"
>Automatic Vacuuming</A
>
</DT
><DT
>autovacuum_analyze_threshold configuration parameter,
<A
HREF="runtime-config-autovacuum.html"
>Automatic Vacuuming</A
>
</DT
><DT
>autovacuum_naptime configuration parameter,
<A
HREF="runtime-config-autovacuum.html"
>Automatic Vacuuming</A
>
</DT
><DT
>autovacuum_vacuum_cost_delay configuration parameter,
<A
HREF="runtime-config-autovacuum.html"
>Automatic Vacuuming</A
>
</DT
><DT
>autovacuum_vacuum_cost_limit configuration parameter,
<A
HREF="runtime-config-autovacuum.html"
>Automatic Vacuuming</A
>
</DT
><DT
>autovacuum_vacuum_scale_factor configuration parameter,
<A
HREF="runtime-config-autovacuum.html"
>Automatic Vacuuming</A
>
</DT
><DT
>autovacuum_vacuum_threshold configuration parameter,
<A
HREF="runtime-config-autovacuum.html"
>Automatic Vacuuming</A
>
</DT
><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="AEN82928"
>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-compatible.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
>BETWEEN SYMMETRIC,
<A
HREF="functions-comparison.html"
>Comparison Operators</A
>
</DT
><DT
>bgwriter_all_maxpages configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER"
>Background Writer</A
>
</DT
><DT
>bgwriter_all_percent configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER"
>Background Writer</A
>
</DT
><DT
>bgwriter_delay configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER"
>Background Writer</A
>
</DT
><DT
>bgwriter_lru_maxpages configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER"
>Background Writer</A
>
</DT
><DT
>bgwriter_lru_percent configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER"
>Background Writer</A
>
</DT
><DT
>bigint,
<A
HREF="sql-syntax.html#AEN1255"
>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
>bitmap scan,
<A
HREF="indexes-bitmap-scans.html"
>Combining Multiple Indexes</A
>,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
>Planner Method Configuration</A
>
</DT
><DT
>bit_and,
<A
HREF="functions-aggregate.html"
>Aggregate Functions</A
>
</DT
><DT
>bit_length,
<A
HREF="functions-string.html"
>String Functions and Operators</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-preset.html"
>Preset Options</A
>
</DT
><DT
>bonjour_name configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS"
>Connection Settings</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#AEN5233"
>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
>btrim,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><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="AEN83053"
>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 Related 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
>cbrt,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>ceiling,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>center,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</A
>
</DT
><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-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>,
<A
HREF="runtime-config-preset.html"
>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
>char_length,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>check constraint,
<A
HREF="ddl-constraints.html#AEN1954"
>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-wal.html#RUNTIME-CONFIG-WAL-CHECKPOINTS"
>Checkpoints</A
>
</DT
><DT
>checkpoint_timeout configuration parameter,
<A
HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-CHECKPOINTS"
>Checkpoints</A
>
</DT
><DT
>checkpoint_warning configuration parameter,
<A
HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-CHECKPOINTS"
>Checkpoints</A
>
</DT
><DT
>check_function_bodies configuration parameter,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT"
>Statement Behavior</A
>
</DT
><DT
>chr,
<A
HREF="functions-string.html"
>String Functions and Operators</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#AEN5319"
>Circles</A
>
</DT
><DT
>client authentication,
<A
HREF="client-authentication.html"
>Client Authentication</A
>
</DT
><DD
><DL
><DT
>timeout during,
<A
HREF="runtime-config-connection.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-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>
</DT
><DT
>client_min_messages configuration parameter,
<A
HREF="runtime-config-logging.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#AEN12654"
>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#AEN2233"
>Adding a Column</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>removing,
<A
HREF="ddl-alter.html#AEN2245"
>Removing a Column</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>renaming,
<A
HREF="ddl-alter.html#AEN2300"
>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#AEN2290"
>Changing a Column's Data Type</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>column reference,
<A
HREF="sql-expressions.html#AEN1610"
>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 PREPARED,
<A
HREF="sql-commit-prepared.html"
>COMMIT PREPARED</A
>
</DT
><DT
>commit_delay configuration parameter,
<A
HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-SETTINGS"
>Settings</A
>
</DT
><DT
>commit_siblings configuration parameter,
<A
HREF="runtime-config-wal.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#AEN5768"
>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#AEN31703"
>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"
>Server 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-file-locations.html"
>File Locations</A
>
</DT
><DT
>conjunction,
<A
HREF="functions.html#FUNCTIONS-LOGICAL"
>Logical Operators</A
>
</DT
><DT
>connection service file,
<A
HREF="libpq-pgservice.html"
>The Connection Service File</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#AEN2256"
>Adding a Constraint</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>check,
<A
HREF="ddl-constraints.html#AEN1954"
>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#AEN1954"
>Check Constraints</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>NOT NULL,
<A
HREF="ddl-constraints.html#AEN1990"
>Not-Null Constraints</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>primary key,
<A
HREF="ddl-constraints.html#AEN2038"
>Primary Keys</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>removing,
<A
HREF="ddl-alter.html#AEN2265"
>Removing a Constraint</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>unique,
<A
HREF="ddl-constraints.html#AEN2016"
>Unique Constraints</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>constraint exclusion,
<A
HREF="ddl-partitioning.html#DDL-PARTITIONING-CONSTRAINT-EXCLUSION"
>Partitioning and Constraint Exclusion</A
>,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-OTHER"
>Other Planner Options</A
>
</DT
><DT
>constraint_exclusion configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-OTHER"
>Other Planner Options</A
>
</DT
><DT
>CONTINUE
</DT
><DD
><DL
><DT
>in PL/pgSQL,
<A
HREF="plpgsql-control-structures.html#AEN35385"
>CONTINUE</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>convert,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><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
>cos,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>cot,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>count,
<A
HREF="tutorial-agg.html"
>Aggregate Functions</A
>
</DT
><DT
>cpu_index_tuple_cost configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-CONSTANTS"
> Planner Cost Constants </A
>
</DT
><DT
>cpu_operator_cost configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-CONSTANTS"
> Planner Cost Constants </A
>
</DT
><DT
>cpu_tuple_cost configuration parameter,
<A
HREF="runtime-config-query.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 ROLE,
<A
HREF="user-manag.html#DATABASE-ROLES"
>Database Roles</A
>,
<A
HREF="sql-createrole.html"
>CREATE ROLE</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="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-ROLES"
>Database Roles</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
><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#AEN34031"
>View Rules in Non-SELECT Statements</A
>
</DT
><DT
>current_date,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>
</DT
><DT
>current_time,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>
</DT
><DT
>current_timestamp,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</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-custom.html"
>Customized Options</A
>
</DT
></DL
></DIV
><DIV
CLASS="INDEXDIV"
><H2
CLASS="INDEXDIV"
><A
NAME="AEN83454"
>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 organization,
<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="role-attributes.html"
>Role 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-file-locations.html"
>File Locations</A
>
</DT
><DT
>date,
<A
HREF="datatype-datetime.html"
>Date/Time Types</A
>,
<A
HREF="datatype-datetime.html#AEN4546"
>Dates</A
>
</DT
><DD
><DL
><DT
>constants,
<A
HREF="datatype-datetime.html#AEN4815"
>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-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>
</DT
><DT
>date_part,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>,
<A
HREF="functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT"
>EXTRACT, date_part</A
>
</DT
><DT
>date_trunc,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>,
<A
HREF="functions-datetime.html#FUNCTIONS-DATETIME-TRUNC"
>date_trunc</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-connection.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-locks.html"
>Lock Management</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>deadlock_timeout configuration parameter,
<A
HREF="runtime-config-locks.html"
>Lock Management</A
>
</DT
><DT
>DEALLOCATE,
<A
HREF="sql-deallocate.html"
>DEALLOCATE</A
>
</DT
><DT
>debug_assertions configuration parameter,
<A
HREF="runtime-config-developer.html"
>Developer Options</A
>
</DT
><DT
>debug_pretty_print configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
>What To Log</A
>
</DT
><DT
>debug_print_parse configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
>What To Log</A
>
</DT
><DT
>debug_print_plan configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
>What To Log</A
>
</DT
><DT
>debug_print_rewritten configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
>What To Log</A
>
</DT
><DT
>decimal
</DT
><DD
><DL
><DT
>see numeric</DT
></DL
></DD
><DT
>DECLARE,
<A
HREF="sql-declare.html"
>DECLARE</A
>
</DT
><DT
>decode,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>default value,
<A
HREF="ddl-default.html"
>Default Values</A
>
</DT
><DD
><DL
><DT
>changing,
<A
HREF="ddl-alter.html#AEN2280"
>Changing a Column's Default Value</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>default_statistics_target configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-OTHER"
>Other Planner Options</A
>
</DT
><DT
>default_tablespace configuration parameter,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT"
>Statement Behavior</A
>
</DT
><DT
>default_transaction_isolation configuration parameter,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT"
>Statement Behavior</A
>
</DT
><DT
>default_transaction_read_only configuration parameter,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT"
>Statement Behavior</A
>
</DT
><DT
>default_with_oids configuration parameter,
<A
HREF="runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION"
>Previous PostgreSQL Versions</A
>
</DT
><DT
>degrees,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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
>diameter,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</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"
>WAL 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 ROLE,
<A
HREF="user-manag.html#DATABASE-ROLES"
>Database Roles</A
>,
<A
HREF="sql-droprole.html"
>DROP ROLE</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="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-ROLES"
>Database Roles</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-client.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-client.html#RUNTIME-CONFIG-CLIENT-OTHER"
>Other Defaults</A
>
</DT
></DL
></DIV
><DIV
CLASS="INDEXDIV"
><H2
CLASS="INDEXDIV"
><A
NAME="AEN83716"
>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-query.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_bitmapscan configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
>Planner Method Configuration</A
>
</DT
><DT
>enable_hashagg configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
>Planner Method Configuration</A
>
</DT
><DT
>enable_hashjoin configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
>Planner Method Configuration</A
>
</DT
><DT
>enable_indexscan configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
>Planner Method Configuration</A
>
</DT
><DT
>enable_mergejoin configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
>Planner Method Configuration</A
>
</DT
><DT
>enable_nestloop configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
>Planner Method Configuration</A
>
</DT
><DT
>enable_seqscan configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
>Planner Method Configuration</A
>
</DT
><DT
>enable_sort configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
>Planner Method Configuration</A
>
</DT
><DT
>enable_tidscan configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
>Planner Method Configuration</A
>
</DT
><DT
>encode,
<A
HREF="functions-string.html"
>String Functions and Operators</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
>escape_string_warning configuration parameter,
<A
HREF="runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION"
>Previous PostgreSQL Versions</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
>exceptions
</DT
><DD
><DL
><DT
>in PL/PgSQL,
<A
HREF="plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING"
>Trapping Errors</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>EXECUTE,
<A
HREF="sql-execute.html"
>EXECUTE</A
>
</DT
><DT
>EXISTS,
<A
HREF="functions-subquery.html"
>Subquery Expressions</A
>
</DT
><DT
>EXIT
</DT
><DD
><DL
><DT
>in PL/pgSQL,
<A
HREF="plpgsql-control-structures.html#AEN35359"
>EXIT</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>exp,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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-client.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-file-locations.html"
>File Locations</A
>
</DT
><DT
>extract,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>,
<A
HREF="functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT"
>EXTRACT, date_part</A
>
</DT
><DT
>extra_float_digits configuration parameter,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>
</DT
></DL
></DIV
><DIV
CLASS="INDEXDIV"
><H2
CLASS="INDEXDIV"
><A
NAME="AEN83847"
>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#AEN31703"
>SQL Functions on Composite Types</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>field selection,
<A
HREF="sql-expressions.html#AEN1659"
>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-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>floor,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><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
>free space map,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-FSM"
>Free Space Map</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-compatible.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-query.html#RUNTIME-CONFIG-QUERY-OTHER"
>Other Planner Options</A
>
</DT
><DT
>fsync configuration parameter,
<A
HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-SETTINGS"
>Settings</A
>
</DT
><DT
>full_page_writes configuration parameter,
<A
HREF="runtime-config-wal.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#AEN1699"
>Function Calls</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>output parameter,
<A
HREF="xfunc-sql.html#XFUNC-OUTPUT-PARAMETERS"
>Functions with Output Parameters</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-c.html"
>C-Language 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="AEN83942"
>G</A
></H2
><DL
><DT
>generate_series,
<A
HREF="functions-srf.html"
>Set Returning Functions</A
>
</DT
><DT
>genetic query optimization,
<A
HREF="runtime-config-query.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-query.html#RUNTIME-CONFIG-QUERY-GEQO"
>Genetic Query Optimizer</A
>
</DT
><DT
>geqo_effort configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-GEQO"
>Genetic Query Optimizer</A
>
</DT
><DT
>geqo_generations configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-GEQO"
>Genetic Query Optimizer</A
>
</DT
><DT
>geqo_pool_size configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-GEQO"
>Genetic Query Optimizer</A
>
</DT
><DT
>geqo_selection_bias configuration parameter,
<A
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-GEQO"
>Genetic Query Optimizer</A
>
</DT
><DT
>geqo_threshold configuration parameter,
<A
HREF="runtime-config-query.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
>GREATEST,
<A
HREF="functions-conditional.html#AEN12695"
>GREATEST and LEAST</A
>
</DT
><DD
><DL
><DT
>determination of result type,
<A
HREF="typeconv-union-case.html"
>UNION, CASE, and Related Constructs</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><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="AEN84002"
>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-file-locations.html"
>File Locations</A
>
</DT
><DT
>height,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</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="AEN84051"
>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-file-locations.html"
>File Locations</A
>
</DT
><DT
>IFNULL,
<A
HREF="functions-conditional.html#AEN12654"
>COALESCE</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
>combining multiple indexes,
<A
HREF="indexes-bitmap-scans.html"
>Combining Multiple Indexes</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#GIST-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-query.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="ddl-inherit.html"
>Inheritance</A
>,
<A
HREF="runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION"
>Previous PostgreSQL Versions</A
>
</DT
><DT
>initcap,
<A
HREF="functions-string.html"
>String Functions and Operators</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#AEN35904"
>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#AEN1255"
>Numeric Constants</A
>,
<A
HREF="datatype.html#DATATYPE-INT"
>Integer Types</A
>
</DT
><DT
>integer_datetimes configuration parameter,
<A
HREF="runtime-config-preset.html"
>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#AEN4775"
>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
>,
<A
HREF="functions-comparisons.html#AEN13423"
>Row-wise Comparison</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-compatible.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
>isclosed,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</A
>
</DT
><DT
>isfinite,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>
</DT
><DT
>ISNULL,
<A
HREF="functions-comparison.html"
>Comparison Operators</A
>
</DT
><DT
>isopen,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</A
>
</DT
></DL
></DIV
><DIV
CLASS="INDEXDIV"
><H2
CLASS="INDEXDIV"
><A
NAME="AEN84237"
>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-query.html#RUNTIME-CONFIG-QUERY-OTHER"
>Other Planner Options</A
>
</DT
><DT
>justify_days,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>
</DT
><DT
>justify_hours,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>
</DT
></DL
></DIV
><DIV
CLASS="INDEXDIV"
><H2
CLASS="INDEXDIV"
><A
NAME="AEN84267"
>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_caseins_users configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SECURITY"
>Security and Authentication</A
>
</DT
><DT
>krb_server_hostname configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SECURITY"
>Security and Authentication</A
>
</DT
><DT
>krb_server_keyfile configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SECURITY"
>Security and Authentication</A
>
</DT
><DT
>krb_srvname configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SECURITY"
>Security and Authentication</A
>
</DT
></DL
></DIV
><DIV
CLASS="INDEXDIV"
><H2
CLASS="INDEXDIV"
><A
NAME="AEN84290"
>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,
<A
HREF="largeobjects.html"
>Large Objects</A
>
</DT
><DT
>lastval,
<A
HREF="functions-sequence.html"
>Sequence Manipulation Functions</A
>
</DT
><DT
>lc_collate configuration parameter,
<A
HREF="runtime-config-preset.html"
>Preset Options</A
>
</DT
><DT
>lc_ctype configuration parameter,
<A
HREF="runtime-config-preset.html"
>Preset Options</A
>
</DT
><DT
>lc_messages configuration parameter,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>
</DT
><DT
>lc_monetary configuration parameter,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>
</DT
><DT
>lc_numeric configuration parameter,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>
</DT
><DT
>lc_time configuration parameter,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>
</DT
><DT
>ldconfig,
<A
HREF="install-post.html#AEN16621"
>Shared Libraries</A
>
</DT
><DT
>LEAST,
<A
HREF="functions-conditional.html#AEN12695"
>GREATEST and LEAST</A
>
</DT
><DD
><DL
><DT
>determination of result type,
<A
HREF="typeconv-union-case.html"
>UNION, CASE, and Related Constructs</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>left join,
<A
HREF="queries-table-expressions.html#QUERIES-JOIN"
>Joined Tables</A
>
</DT
><DT
>length,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</A
>
</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 string, 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#AEN22133"
>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#AEN5205"
>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-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS"
>Connection Settings</A
>
</DT
><DT
>ln,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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
>localtime,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>
</DT
><DT
>localtimestamp,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</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,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>login privilege,
<A
HREF="role-attributes.html"
>Role Attributes</A
>
</DT
><DT
>log_connections configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
>What To Log</A
>
</DT
><DT
>log_destination configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE"
>Where To Log</A
>
</DT
><DT
>log_directory configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE"
>Where To Log</A
>
</DT
><DT
>log_disconnections configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
>What To Log</A
>
</DT
><DT
>log_duration configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
>What To Log</A
>
</DT
><DT
>log_error_verbosity configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN"
>When To Log</A
>
</DT
><DT
>log_executor_stats configuration parameter,
<A
HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-MONITOR"
>Statistics Monitoring</A
>
</DT
><DT
>log_filename configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE"
>Where To Log</A
>
</DT
><DT
>log_hostname configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
>What To Log</A
>
</DT
><DT
>log_line_prefix configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
>What To Log</A
>
</DT
><DT
>log_min_duration_statement configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN"
>When To Log</A
>
</DT
><DT
>log_min_error_statement configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN"
>When To Log</A
>
</DT
><DT
>log_min_messages configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN"
>When To Log</A
>
</DT
><DT
>log_parser_stats configuration parameter,
<A
HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-MONITOR"
>Statistics Monitoring</A
>
</DT
><DT
>log_planner_stats configuration parameter,
<A
HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-MONITOR"
>Statistics Monitoring</A
>
</DT
><DT
>log_rotation_age configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE"
>Where To Log</A
>
</DT
><DT
>log_rotation_size configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE"
>Where To Log</A
>
</DT
><DT
>log_statement configuration parameter,
<A
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
>What To Log</A
>
</DT
><DT
>log_statement_stats configuration parameter,
<A
HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-MONITOR"
>Statistics Monitoring</A
>
</DT
><DT
>log_truncate_on_rotation configuration parameter,
<A
HREF="runtime-config-logging.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
>lower,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DD
><DL
><DT
>and locales,
<A
HREF="charset.html#AEN22133"
>Behavior</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>lo_close,
<A
HREF="lo-interfaces.html#AEN27196"
>Closing a Large Object Descriptor</A
>
</DT
><DT
>lo_creat,
<A
HREF="lo-interfaces.html#AEN27081"
>Creating a Large Object</A
>,
<A
HREF="lo-funcs.html"
>Server-Side Functions</A
>
</DT
><DT
>lo_create,
<A
HREF="lo-interfaces.html#AEN27081"
>Creating a Large Object</A
>,
<A
HREF="lo-funcs.html"
>Server-Side Functions</A
>
</DT
><DT
>lo_export,
<A
HREF="lo-interfaces.html#AEN27117"
>Exporting a Large Object</A
>,
<A
HREF="lo-funcs.html"
>Server-Side Functions</A
>
</DT
><DT
>lo_import,
<A
HREF="lo-interfaces.html#AEN27110"
>Importing a Large Object</A
>,
<A
HREF="lo-funcs.html"
>Server-Side Functions</A
>
</DT
><DT
>lo_lseek,
<A
HREF="lo-interfaces.html#AEN27178"
>Seeking in a Large Object</A
>
</DT
><DT
>lo_open,
<A
HREF="lo-interfaces.html#AEN27125"
>Opening an Existing Large Object</A
>
</DT
><DT
>lo_read,
<A
HREF="lo-interfaces.html#AEN27167"
>Reading Data from a Large Object</A
>
</DT
><DT
>lo_tell,
<A
HREF="lo-interfaces.html#AEN27190"
>Obtaining the Seek Position of a Large Object</A
>
</DT
><DT
>lo_unlink,
<A
HREF="lo-interfaces.html#AEN27206"
>Removing a Large Object</A
>,
<A
HREF="lo-funcs.html"
>Server-Side Functions</A
>
</DT
><DT
>lo_write,
<A
HREF="lo-interfaces.html#AEN27156"
>Writing Data to a Large Object</A
>
</DT
><DT
>lpad,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>lseg,
<A
HREF="datatype-geometric.html#AEN5205"
>Line Segments</A
>
</DT
><DT
>ltrim,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
></DL
></DIV
><DIV
CLASS="INDEXDIV"
><H2
CLASS="INDEXDIV"
><A
NAME="AEN84527"
>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-resource.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#AEN16678"
>Environment Variables</A
>
</DT
><DT
>max,
<A
HREF="tutorial-agg.html"
>Aggregate Functions</A
>
</DT
><DT
>max_connections configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS"
>Connection Settings</A
>
</DT
><DT
>max_files_per_process configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-KERNEL"
>Kernel Resource Usage</A
>
</DT
><DT
>max_fsm_pages configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-FSM"
>Free Space Map</A
>
</DT
><DT
>max_fsm_relations configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-FSM"
>Free Space Map</A
>
</DT
><DT
>max_function_args configuration parameter,
<A
HREF="runtime-config-preset.html"
>Preset Options</A
>
</DT
><DT
>max_identifier_length configuration parameter,
<A
HREF="runtime-config-preset.html"
>Preset Options</A
>
</DT
><DT
>max_index_keys configuration parameter,
<A
HREF="runtime-config-preset.html"
>Preset Options</A
>
</DT
><DT
>max_locks_per_transaction configuration parameter,
<A
HREF="runtime-config-locks.html"
>Lock Management</A
>
</DT
><DT
>max_prepared_transactions configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY"
>Memory</A
>
</DT
><DT
>max_stack_depth configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY"
>Memory</A
>
</DT
><DT
>md5,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>,
<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
>mod,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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="AEN84610"
>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#AEN1990"
>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
>now,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>
</DT
><DT
>npoints,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</A
>
</DT
><DT
>null value
</DT
><DD
><DL
><DT
>with check constraints,
<A
HREF="ddl-constraints.html#AEN1954"
>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#AEN2016"
>Unique Constraints</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>NULLIF,
<A
HREF="functions-conditional.html#AEN12675"
>NULLIF</A
>
</DT
><DT
>number
</DT
><DD
><DL
><DT
>constant,
<A
HREF="sql-syntax.html#AEN1255"
>Numeric Constants</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>numeric,
<A
HREF="sql-syntax.html#AEN1255"
>Numeric Constants</A
>
</DT
><DT
>numeric (data type),
<A
HREF="datatype.html#DATATYPE-NUMERIC-DECIMAL"
>Arbitrary Precision Numbers</A
>
</DT
><DT
>NVL,
<A
HREF="functions-conditional.html#AEN12654"
>COALESCE</A
>
</DT
></DL
></DIV
><DIV
CLASS="INDEXDIV"
><H2
CLASS="INDEXDIV"
><A
NAME="AEN84716"
>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
>octet_length,
<A
HREF="functions-string.html"
>String Functions and Operators</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#AEN1670"
>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#AEN22133"
>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="AEN84819"
>P</A
></H2
><DL
><DT
>palloc,
<A
HREF="xfunc-c.html#AEN32368"
>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#AEN1626"
>Positional Parameters</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>parenthesis,
<A
HREF="sql-expressions.html"
>Value Expressions</A
>
</DT
><DT
>partitioning,
<A
HREF="ddl-partitioning.html"
>Partitioning</A
>
</DT
><DT
>password,
<A
HREF="role-attributes.html"
>Role 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-connection.html#RUNTIME-CONFIG-CONNECTION-SECURITY"
>Security and Authentication</A
>
</DT
><DT
>PATH,
<A
HREF="install-post.html#AEN16678"
>Environment Variables</A
>
</DT
><DD
><DL
><DT
>for schemas,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT"
>Statement Behavior</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>path (data type),
<A
HREF="datatype-geometric.html#AEN5261"
>Paths</A
>
</DT
><DT
>pattern matching,
<A
HREF="functions-matching.html"
>Pattern Matching</A
>
</DT
><DT
>pclose,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</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#AEN32368"
>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
>PGKRBSRVNAME,
<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
>PGPASSFILE,
<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_authid,
<A
HREF="catalog-pg-authid.html"
>pg_authid</A
>
</DT
><DT
>pg_auth_members,
<A
HREF="catalog-pg-auth-members.html"
>pg_auth_members</A
>
</DT
><DT
>pg_autovacuum,
<A
HREF="catalog-pg-autovacuum.html"
>pg_autovacuum</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_client_encoding,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>pg_column_size,
<A
HREF="functions-admin.html"
>System Administration Functions</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#AEN32368"
>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_database_size,
<A
HREF="functions-admin.html"
>System Administration Functions</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="view-pg-group.html"
>pg_group</A
>
</DT
><DT
>pg_has_role,
<A
HREF="functions-info.html"
>System Information Functions</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_ls_dir,
<A
HREF="functions-admin.html"
>System Administration Functions</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_pltemplate,
<A
HREF="catalog-pg-pltemplate.html"
>pg_pltemplate</A
>
</DT
><DT
>pg_postmaster_start_time,
<A
HREF="functions-info.html"
>System Information Functions</A
>
</DT
><DT
>pg_prepared_xacts,
<A
HREF="view-pg-prepared-xacts.html"
>pg_prepared_xacts</A
>
</DT
><DT
>pg_proc,
<A
HREF="catalog-pg-proc.html"
>pg_proc</A
>
</DT
><DT
>pg_read_file,
<A
HREF="functions-admin.html"
>System Administration Functions</A
>
</DT
><DT
>pg_relation_size,
<A
HREF="functions-admin.html"
>System Administration Functions</A
>
</DT
><DT
>pg_reload_conf,
<A
HREF="functions-admin.html"
>System Administration Functions</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_roles,
<A
HREF="view-pg-roles.html"
>pg_roles</A
>
</DT
><DT
>pg_rotate_logfile,
<A
HREF="functions-admin.html"
>System Administration Functions</A
>
</DT
><DT
>pg_rules,
<A
HREF="view-pg-rules.html"
>pg_rules</A
>
</DT
><DT
>pg_service.conf,
<A
HREF="libpq-pgservice.html"
>The Connection Service File</A
>
</DT
><DT
>pg_settings,
<A
HREF="view-pg-settings.html"
>pg_settings</A
>
</DT
><DT
>pg_shadow,
<A
HREF="view-pg-shadow.html"
>pg_shadow</A
>
</DT
><DT
>pg_shdepend,
<A
HREF="catalog-pg-shdepend.html"
>pg_shdepend</A
>
</DT
><DT
>pg_size_pretty,
<A
HREF="functions-admin.html"
>System Administration Functions</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_stat_file,
<A
HREF="functions-admin.html"
>System Administration Functions</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_tablespace_size,
<A
HREF="functions-admin.html"
>System Administration Functions</A
>
</DT
><DT
>pg_table_is_visible,
<A
HREF="functions-info.html"
>System Information Functions</A
>
</DT
><DT
>pg_total_relation_size,
<A
HREF="functions-admin.html"
>System Administration 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#AEN5192"
>Points</A
>
</DT
><DT
>point-in-time recovery,
<A
HREF="backup.html"
>Backup and Restore</A
>
</DT
><DT
>polygon,
<A
HREF="datatype-geometric.html#AEN5294"
>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
>popen,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</A
>
</DT
><DT
>port,
<A
HREF="libpq.html#LIBPQ-CONNECT"
>Database Connection Control Functions</A
>
</DT
><DT
>port configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS"
>Connection Settings</A
>
</DT
><DT
>position,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>POSTGRES,
<A
HREF="history.html#HISTORY-BERKELEY"
>The Berkeley POSTGRES Project</A
>,
<A
HREF="manage-ag-createdb.html"
>Creating a Database</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#CONFIG-SETTING"
>Setting Parameters</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
>power,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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-resource.html#RUNTIME-CONFIG-RESOURCE-KERNEL"
>Kernel Resource Usage</A
>
</DT
><DT
>PREPARE,
<A
HREF="sql-prepare.html"
>PREPARE</A
>
</DT
><DT
>PREPARE TRANSACTION,
<A
HREF="sql-prepare-transaction.html"
>PREPARE TRANSACTION</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-developer.html"
>Developer Options</A
>
</DT
><DT
>primary key,
<A
HREF="ddl-constraints.html#AEN2038"
>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="AEN85641"
>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="AEN85672"
>R</A
></H2
><DL
><DT
>R-tree
</DT
><DD
><DL
><DT
>see index</DT
></DL
></DD
><DT
>radians,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>radius,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</A
>
</DT
><DT
>RAISE,
<A
HREF="plpgsql-errors-and-messages.html"
>Errors and Messages</A
>
</DT
><DT
>random,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>random_page_cost configuration parameter,
<A
HREF="runtime-config-query.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-client.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#AEN5233"
>Boxes</A
>
</DT
><DT
>redirect_stderr configuration parameter,
<A
HREF="runtime-config-logging.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
>regexp_replace,
<A
HREF="functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP"
>SIMILAR TO Regular Expressions</A
>
</DT
><DT
>regex_flavor configuration parameter,
<A
HREF="runtime-config-compatible.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-compatible.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
>reindexdb,
<A
HREF="app-reindexdb.html"
>reindexdb</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
>repeat,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>replace,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>reporting errors
</DT
><DD
><DL
><DT
>in PL/PgSQL,
<A
HREF="plpgsql-errors-and-messages.html"
>Errors and Messages</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><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
>role,
<A
HREF="user-manag.html#DATABASE-ROLES"
>Database Roles</A
>
</DT
><DD
><DL
><DT
>membership in,
<A
HREF="role-membership.html"
>Role Membership</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>privilege to create,
<A
HREF="role-attributes.html"
>Role Attributes</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>ROLLBACK,
<A
HREF="sql-rollback.html"
>ROLLBACK</A
>
</DT
><DD
><DL
><DT
>psql,
<A
HREF="app-psql.html#APP-PSQL-VARIABLES"
>Variables</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>ROLLBACK PREPARED,
<A
HREF="sql-rollback-prepared.html"
>ROLLBACK PREPARED</A
>
</DT
><DT
>ROLLBACK TO SAVEPOINT,
<A
HREF="sql-rollback-to.html"
>ROLLBACK TO SAVEPOINT</A
>
</DT
><DT
>round,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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 estimation
</DT
><DD
><DL
><DT
>planner,
<A
HREF="planner-stats-details.html#ROW-ESTIMATION-EXAMPLES"
>Row Estimation Examples</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><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
>rpad,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>rtrim,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><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="AEN85853"
>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-client.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-query.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-logging.html"
>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-preset.html"
>Preset Options</A
>
</DT
><DT
>server_version configuration parameter,
<A
HREF="runtime-config-preset.html"
>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 ROLE,
<A
HREF="sql-set-role.html"
>SET ROLE</A
>
</DT
><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
><DD
><DL
><DT
>see also function</DT
></DL
></DD
><DT
>setseed,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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#AEN16621"
>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-resource.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#CONFIG-SETTING"
>Setting Parameters</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
>sign,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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-client.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-logging.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
>sin,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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_getnspname,
<A
HREF="spi-spi-getnspname.html"
>SPI_getnspname</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
>split_part,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>sql_inheritance configuration parameter,
<A
HREF="runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION"
>Previous PostgreSQL Versions</A
>
</DT
><DT
>sqrt,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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-connection.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
>standard_conforming_strings configuration parameter,
<A
HREF="runtime-config-preset.html"
>Preset Options</A
>
</DT
><DT
>START TRANSACTION,
<A
HREF="sql-start-transaction.html"
>START TRANSACTION</A
>
</DT
><DT
>statement_timeout configuration parameter,
<A
HREF="runtime-config-client.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-statistics.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR"
>Query and Index Statistics Collector</A
>
</DT
><DT
>stats_command_string configuration parameter,
<A
HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR"
>Query and Index Statistics Collector</A
>
</DT
><DT
>stats_reset_on_server_start configuration parameter,
<A
HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR"
>Query and Index Statistics Collector</A
>
</DT
><DT
>stats_row_level configuration parameter,
<A
HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR"
>Query and Index Statistics Collector</A
>
</DT
><DT
>stats_start_collector configuration parameter,
<A
HREF="runtime-config-statistics.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-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION"
>Previous PostgreSQL Versions</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>escape,
<A
HREF="runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION"
>Previous PostgreSQL Versions</A
>,
<A
HREF="runtime-config-preset.html"
>Preset Options</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>strpos,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><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#AEN1640"
>Subscripts</A
>
</DT
><DT
>substr,
<A
HREF="functions-string.html"
>String Functions and Operators</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="role-attributes.html"
>Role Attributes</A
>
</DT
><DT
>superuser_reserved_connections configuration parameter,
<A
HREF="runtime-config-connection.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-logging.html#RUNTIME-CONFIG-LOGGING-WHERE"
>Where To Log</A
>
</DT
><DT
>syslog_identity configuration parameter,
<A
HREF="runtime-config-logging.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="AEN86293"
>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
>inheritance,
<A
HREF="ddl-inherit.html"
>Inheritance</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>modifying,
<A
HREF="ddl-alter.html"
>Modifying Tables</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>partitioning,
<A
HREF="ddl-partitioning.html"
>Partitioning</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#AEN2307"
>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-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT"
>Statement Behavior</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>tan,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><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
>tcp_keepalives_count configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS"
>Connection Settings</A
>
</DT
><DT
>tcp_keepalives_idle configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS"
>Connection Settings</A
>
</DT
><DT
>tcp_keepalives_interval configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS"
>Connection Settings</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
>temp_buffers configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY"
>Memory</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#AEN4619"
>Times</A
>
</DT
><DD
><DL
><DT
>constants,
<A
HREF="datatype-datetime.html#AEN4815"
>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#AEN4619"
>Times</A
>
</DT
><DT
>time without time zone,
<A
HREF="datatype-datetime.html"
>Date/Time Types</A
>,
<A
HREF="datatype-datetime.html#AEN4619"
>Times</A
>
</DT
><DT
>time zone,
<A
HREF="datatype-datetime.html#DATATYPE-TIMEZONES"
>Time Zones</A
>,
<A
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
>Locale and Formatting</A
>
</DT
><DD
><DL
><DT
>Australian,
<A
HREF="runtime-config-client.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
>timeofday,
<A
HREF="functions-datetime.html"
>Date/Time Functions and Operators</A
>
</DT
><DT
>timeout
</DT
><DD
><DL
><DT
>client authentication,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SECURITY"
>Security and Authentication</A
>
</DT
><DD
><DL
></DL
></DD
><DT
>deadlock,
<A
HREF="runtime-config-locks.html"
>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#AEN4725"
>Time Stamps</A
>
</DT
><DT
>timestamp with time zone,
<A
HREF="datatype-datetime.html"
>Date/Time Types</A
>,
<A
HREF="datatype-datetime.html#AEN4725"
>Time Stamps</A
>
</DT
><DT
>timestamp without time zone,
<A
HREF="datatype-datetime.html"
>Date/Time Types</A
>,
<A
HREF="datatype-datetime.html#AEN4725"
>Time Stamps</A
>
</DT
><DT
>timezone configuration parameter,
<A
HREF="runtime-config-client.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#AEN39866"
>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_ascii,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>to_char,
<A
HREF="functions-formatting.html"
>Data Type Formatting Functions</A
>
</DT
><DD
><DL
><DT
>and locales,
<A
HREF="charset.html#AEN22133"
>Behavior</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>to_date,
<A
HREF="functions-formatting.html"
>Data Type Formatting Functions</A
>
</DT
><DT
>to_hex,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DT
>to_number,
<A
HREF="functions-formatting.html"
>Data Type Formatting Functions</A
>
</DT
><DT
>to_timestamp,
<A
HREF="functions-formatting.html"
>Data Type Formatting Functions</A
>
</DT
><DT
>trace_notify configuration parameter,
<A
HREF="runtime-config-developer.html"
>Developer Options</A
>
</DT
><DT
>trace_sort configuration parameter,
<A
HREF="runtime-config-developer.html"
>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-client.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-compatible.html#RUNTIME-CONFIG-COMPATIBLE-CLIENTS"
>Platform and Client Compatibility</A
>
</DT
><DT
>translate,
<A
HREF="functions-string.html"
>String Functions and Operators</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
>trim,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><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
>trunc,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</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#AEN1255"
>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="AEN86537"
>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 Related Constructs</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>unique constraint,
<A
HREF="ddl-constraints.html#AEN2016"
>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-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS"
>Connection Settings</A
>
</DT
><DT
>unix_socket_group configuration parameter,
<A
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS"
>Connection Settings</A
>
</DT
><DT
>unix_socket_permissions configuration parameter,
<A
HREF="runtime-config-connection.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
>upper,
<A
HREF="functions-string.html"
>String Functions and Operators</A
>
</DT
><DD
><DL
><DT
>and locales,
<A
HREF="charset.html#AEN22133"
>Behavior</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>user,
<A
HREF="user-manag.html#DATABASE-ROLES"
>Database Roles</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="AEN86593"
>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-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST"
> Cost-Based Vacuum Delay </A
>
</DT
><DT
>vacuum_cost_limit configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST"
> Cost-Based Vacuum Delay </A
>
</DT
><DT
>vacuum_cost_page_dirty configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST"
> Cost-Based Vacuum Delay </A
>
</DT
><DT
>vacuum_cost_page_hit configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST"
> Cost-Based Vacuum Delay </A
>
</DT
><DT
>vacuum_cost_page_miss configuration parameter,
<A
HREF="runtime-config-resource.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="AEN86649"
>W</A
></H2
><DL
><DT
>WAL,
<A
HREF="wal.html"
>Reliability and the Write-Ahead Log</A
>
</DT
><DT
>wal_buffers configuration parameter,
<A
HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-SETTINGS"
>Settings</A
>
</DT
><DT
>wal_debug configuration parameter,
<A
HREF="runtime-config-developer.html"
>Developer Options</A
>
</DT
><DT
>wal_sync_method configuration parameter,
<A
HREF="runtime-config-wal.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-logging.html#RUNTIME-CONFIG-LOGGING-WHERE"
>Where To Log</A
>
</DT
><DT
>WHILE
</DT
><DD
><DL
><DT
>in PL/pgSQL,
<A
HREF="plpgsql-control-structures.html#AEN35407"
>WHILE</A
>
</DT
><DD
><DL
></DL
></DD
></DL
></DD
><DT
>width,
<A
HREF="functions-geometry.html"
>Geometric Functions and Operators</A
>
</DT
><DT
>width_bucket,
<A
HREF="functions-math.html"
>Mathematical Functions and Operators</A
>
</DT
><DT
>work_mem configuration parameter,
<A
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY"
>Memory</A
>
</DT
></DL
></DIV
><DIV
CLASS="INDEXDIV"
><H2
CLASS="INDEXDIV"
><A
NAME="AEN86682"
>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="AEN86693"
>Y</A
></H2
><DL
><DT
>yacc,
<A
HREF="install-requirements.html"
>Requirements</A
>
</DT
></DL
></DIV
><DIV
CLASS="INDEXDIV"
><H2
CLASS="INDEXDIV"
><A
NAME="AEN86698"
>Z</A
></H2
><DL
><DT
>zero_damaged_pages configuration parameter,
<A
HREF="runtime-config-developer.html"
>Developer Options</A
>
</DT
><DT
>zlib,
<A
HREF="install-requirements.html"
>Requirements</A
>,
<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
>