PostgreSQL: Documentation: 9.0: Index

PostgreSQL 9.0.23 Documentation
Prev	Home

Symbols

$, Positional Parameters
$libdir, Dynamic Loading
$libdir/plugins, Other Defaults, Description
*, Select-List Items
.pgpass, The Password File
.pg_service.conf, The Connection Service File
::, Type Casts
_PG_fini, Dynamic Loading
_PG_init, Dynamic Loading

A

ABORT, ABORT

abs, Mathematical Functions and Operators

acos, Mathematical Functions and Operators

adminpack, adminpack

age, Date/Time Functions and Operators

aggregate function, Aggregate Functions

built-in, Aggregate Functions
invocation, Aggregate Expressions
user-defined, User-Defined Aggregates

AIX

installation on, AIX
IPC configuration, Shared Memory and Semaphores

alias

for table name in query, Joins Between Tables
in the FROM clause, Table and Column Aliases
in the select list, Column Labels

ALL, Subquery Expressions, Row and Array Comparisons

allow_system_table_mods configuration parameter, Developer Options

ALTER AGGREGATE, ALTER AGGREGATE

ALTER CONVERSION, ALTER CONVERSION

ALTER DATABASE, ALTER DATABASE

ALTER DEFAULT PRIVILEGES, ALTER DEFAULT PRIVILEGES

ALTER DOMAIN, ALTER DOMAIN

ALTER FOREIGN DATA WRAPPER, ALTER FOREIGN DATA WRAPPER

ALTER FUNCTION, ALTER FUNCTION

ALTER GROUP, ALTER GROUP

ALTER INDEX, ALTER INDEX

ALTER LANGUAGE, ALTER LANGUAGE

ALTER LARGE OBJECT, ALTER LARGE OBJECT

ALTER OPERATOR, ALTER OPERATOR

ALTER OPERATOR CLASS, ALTER OPERATOR CLASS

ALTER OPERATOR FAMILY, ALTER OPERATOR FAMILY

ALTER ROLE, Role Attributes, ALTER ROLE

ALTER SCHEMA, ALTER SCHEMA

ALTER SEQUENCE, ALTER SEQUENCE

ALTER SERVER, ALTER SERVER

ALTER TABLE, ALTER TABLE

ALTER TABLESPACE, ALTER TABLESPACE

ALTER TEXT SEARCH CONFIGURATION, ALTER TEXT SEARCH CONFIGURATION

ALTER TEXT SEARCH DICTIONARY, ALTER TEXT SEARCH DICTIONARY

ALTER TEXT SEARCH PARSER, ALTER TEXT SEARCH PARSER

ALTER TEXT SEARCH TEMPLATE, ALTER TEXT SEARCH TEMPLATE

ALTER TRIGGER, ALTER TRIGGER

ALTER TYPE, ALTER TYPE

ALTER USER, ALTER USER

ALTER USER MAPPING, ALTER USER MAPPING

ALTER VIEW, ALTER VIEW

ANALYZE, Updating Planner Statistics, ANALYZE

AND (operator), Logical Operators

anonymous code blocks, DO

any, Pseudo-Types, Aggregate Functions, Subquery Expressions, Row and Array Comparisons

anyarray, Pseudo-Types

anyelement, Pseudo-Types

anyenum, Pseudo-Types

anynonarray, Pseudo-Types

applicable role, applicable_roles

application_name configuration parameter, What To Log

arbitrary precision numbers, Arbitrary Precision Numbers

archive_cleanup_command recovery parameter, Archive recovery settings

archive_command configuration parameter, Archiving

archive_mode configuration parameter, Archiving

archive_timeout configuration parameter, Archiving

area, Geometric Functions and Operators

ARRAY, Array Constructors, Arrays

accessing, Accessing Arrays
constant, Array Value Input
constructor, Array Constructors
declaration, Declaration of Array Types
determination of result type, UNION, CASE, and Related Constructs
I/O, Array Input and Output Syntax
modifying, Modifying Arrays
of user-defined type, User-Defined Types
searching, Searching in Arrays

array_agg, Aggregate Functions

array_append, Array Functions and Operators

array_cat, Array Functions and Operators

array_dims, Array Functions and Operators

array_fill, Array Functions and Operators

array_length, Array Functions and Operators

array_lower, Array Functions and Operators

array_ndims, Array Functions and Operators

array_nulls configuration parameter, Previous PostgreSQL Versions

array_prepend, Array Functions and Operators

array_to_string, Array Functions and Operators

array_upper, Array Functions and Operators

ascii, String Functions and Operators

asin, Mathematical Functions and Operators

asynchronous commit, Asynchronous Commit

AT TIME ZONE, AT TIME ZONE

atan, Mathematical Functions and Operators

atan2, Mathematical Functions and Operators

authentication_timeout configuration parameter, Security and Authentication

auto-increment

see serial

autocommit

bulk-loading data, Disable Autocommit
psql, Variables

autovacuum

configuration parameters, Automatic Vacuuming
general information, The Autovacuum Daemon

autovacuum configuration parameter, Automatic Vacuuming

autovacuum_analyze_scale_factor configuration parameter, Automatic Vacuuming

autovacuum_analyze_threshold configuration parameter, Automatic Vacuuming

autovacuum_freeze_max_age configuration parameter, Automatic Vacuuming

autovacuum_max_workers configuration parameter, Automatic Vacuuming

autovacuum_naptime configuration parameter, Automatic Vacuuming

autovacuum_vacuum_cost_delay configuration parameter, Automatic Vacuuming

autovacuum_vacuum_cost_limit configuration parameter, Automatic Vacuuming

autovacuum_vacuum_scale_factor configuration parameter, Automatic Vacuuming

autovacuum_vacuum_threshold configuration parameter, Automatic Vacuuming

auto_explain, auto_explain

auto_explain.log_analyze configuration parameter, Configuration parameters

auto_explain.log_buffers configuration parameter, Configuration parameters

auto_explain.log_format configuration parameter, Configuration parameters

auto_explain.log_min_duration configuration parameter, Configuration parameters

auto_explain.log_nested_statements configuration parameter, Configuration parameters

auto_explain.log_verbose configuration parameter, Configuration parameters

average, Aggregate Functions, Aggregate Functions

B

B-tree

see index

backslash escapes, String Constants with C-Style Escapes

backslash_quote configuration parameter, Previous PostgreSQL Versions

backup, System Administration Functions, Backup and Restore

base type, The PostgreSQL Type System

BEGIN, BEGIN

BETWEEN, Comparison Operators

BETWEEN SYMMETRIC, Comparison Operators

bgwriter_delay configuration parameter, Background Writer

bgwriter_lru_maxpages configuration parameter, Background Writer

bgwriter_lru_multiplier configuration parameter, Background Writer

bigint, Numeric Constants, Integer Types

bigserial, Serial Types

binary data, Binary Data Types

functions, Binary String Functions and Operators

binary string

concatenation, Binary String Functions and Operators
length, Binary String Functions and Operators

bison, Requirements

bit string

constant, Bit-String Constants
data type, Bit String Types

bit strings

functions, Bit String Functions and Operators

bitmap scan, Combining Multiple Indexes, Planner Method Configuration

bit_and, Aggregate Functions

bit_length, String Functions and Operators

bit_or, Aggregate Functions

BLOB

see large object

block_size configuration parameter, Preset Options

bonjour configuration parameter, Connection Settings

bonjour_name configuration parameter, Connection Settings

Boolean

data type, Boolean Type

operators

see operators, logical

bool_and, Aggregate Functions

bool_or, Aggregate Functions

booting

starting the server during, Starting the Database Server

box (data type), Boxes

BSD/OS

IPC configuration, Shared Memory and Semaphores
shared library, Compiling and Linking Dynamically-Loaded Functions

btree_gin, btree_gin

btree_gist, btree_gist

btrim, String Functions and Operators

bytea, Binary Data Types

bytea_output configuration parameter, Statement Behavior

C

C, libpq - C Library, ECPG - Embedded SQL in C

C++, Using C++ for Extensibility

canceling

SQL command, Cancelling Queries in Progress

CASCADE

with DROP, Dependency Tracking
foreign key action, Foreign Keys

CASE, Conditional Expressions

determination of result type, UNION, CASE, and Related Constructs

case sensitivity

of SQL commands, Identifiers and Key Words

cast

I/O conversion, CREATE CAST

cbrt, Mathematical Functions and Operators

ceiling, Mathematical Functions and Operators

center, Geometric Functions and Operators

Certificate, Certificate authentication

char, Character Types

character, Character Types

character set, Locale and Formatting, Preset Options, Character Set Support

character string

concatenation, String Functions and Operators
constant, String Constants
data types, Character Types
length, String Functions and Operators

character varying, Character Types

char_length, String Functions and Operators

check constraint, Check Constraints

checkpoint, WAL Configuration, CHECKPOINT

checkpoint_completion_target configuration parameter, Checkpoints

checkpoint_segments configuration parameter, Checkpoints

checkpoint_timeout configuration parameter, Checkpoints

checkpoint_warning configuration parameter, Checkpoints

check_function_bodies configuration parameter, Statement Behavior

chkpass, chkpass

chr, String Functions and Operators

cid, Object Identifier Types

cidr, cidr

circle, Circles

citext, citext

client authentication, Client Authentication

timeout during, Security and Authentication

client_encoding configuration parameter, Locale and Formatting

client_min_messages configuration parameter, When To Log

clock_timestamp, Date/Time Functions and Operators

CLOSE, CLOSE

CLUSTER, CLUSTER

of databases

see database cluster

clusterdb, clusterdb

clustering, High Availability, Load Balancing, and Replication

cmax, System Columns

cmin, System Columns

COALESCE, COALESCE

column, Concepts, Table Basics

adding, Adding a Column
removing, Removing a Column
renaming, Renaming a Column
system column, System Columns

column data type

changing, Changing a Column's Data Type

column reference, Column References

col_description, System Information Functions

COMMENT, COMMENT

about database objects, System Information Functions
in SQL, Comments

COMMIT, COMMIT

COMMIT PREPARED, COMMIT PREPARED

commit_delay configuration parameter, Settings

commit_siblings configuration parameter, Settings

common table expression

see WITH

comparison

operators, Comparison Operators
row-wise, Row and Array Comparisons
subquery result row, Subquery Expressions

compiling

libpq applications, Building libpq Programs

composite type, Composite Types, The PostgreSQL Type System

constant, Composite Value Input
constructor, Row Constructors

computed field, SQL Functions on Composite Types

concurrency, Concurrency Control

conditional expression, Conditional Expressions

configuration

of recovery

of a standby server, Recovery Configuration

of the server, Server Configuration

of the server

functions, System Administration Functions

configure, Installation Procedure

config_file configuration parameter, File Locations

conjunction, Logical Operators

connection service file, The Connection Service File

constant, Constants

constraint, Constraints

adding, Adding a Constraint
check, Check Constraints
exclusion, Exclusion Constraints
foreign key, Foreign Keys
name, Check Constraints
NOT NULL, Not-Null Constraints
primary key, Primary Keys
removing, Removing a Constraint
unique, Unique Constraints

constraint exclusion, Partitioning and Constraint Exclusion, Other Planner Options

constraint_exclusion configuration parameter, Other Planner Options

CONTINUE

in PL/pgSQL, CONTINUE

continuous archiving, Backup and Restore

convert, String Functions and Operators

convert_from, String Functions and Operators

convert_to, String Functions and Operators

COPY, Populating a Table With Rows, COPY

with libpq, Functions Associated with the COPY Command

correlation, Aggregate Functions

cos, Mathematical Functions and Operators

cot, Mathematical Functions and Operators

count, Aggregate Functions

covariance

population, Aggregate Functions
sample, Aggregate Functions

cpu_index_tuple_cost configuration parameter, Planner Cost Constants

cpu_operator_cost configuration parameter, Planner Cost Constants

cpu_tuple_cost configuration parameter, Planner Cost Constants

CREATE DATABASE, Creating a Database

CREATE AGGREGATE, CREATE AGGREGATE

CREATE CAST, CREATE CAST

CREATE CONSTRAINT TRIGGER, CREATE CONSTRAINT TRIGGER

CREATE CONVERSION, CREATE CONVERSION

CREATE DATABASE, CREATE DATABASE

CREATE DOMAIN, CREATE DOMAIN

CREATE FOREIGN DATA WRAPPER, CREATE FOREIGN DATA WRAPPER

CREATE FUNCTION, CREATE FUNCTION

CREATE GROUP, CREATE GROUP

CREATE INDEX, CREATE INDEX

CREATE LANGUAGE, CREATE LANGUAGE

CREATE OPERATOR, CREATE OPERATOR

CREATE OPERATOR CLASS, CREATE OPERATOR CLASS

CREATE OPERATOR FAMILY, CREATE OPERATOR FAMILY

CREATE ROLE, Database Roles, CREATE ROLE

CREATE RULE, CREATE RULE

CREATE SCHEMA, CREATE SCHEMA

CREATE SEQUENCE, CREATE SEQUENCE

CREATE SERVER, CREATE SERVER

CREATE TABLE, Creating a New Table, CREATE TABLE

CREATE TABLE AS, CREATE TABLE AS

CREATE TABLESPACE, Tablespaces, CREATE TABLESPACE

CREATE TEXT SEARCH CONFIGURATION, CREATE TEXT SEARCH CONFIGURATION

CREATE TEXT SEARCH DICTIONARY, CREATE TEXT SEARCH DICTIONARY

CREATE TEXT SEARCH PARSER, CREATE TEXT SEARCH PARSER

CREATE TEXT SEARCH TEMPLATE, CREATE TEXT SEARCH TEMPLATE

CREATE TRIGGER, CREATE TRIGGER

CREATE TYPE, CREATE TYPE

CREATE USER, CREATE USER

CREATE USER MAPPING, CREATE USER MAPPING

CREATE VIEW, CREATE VIEW

createdb, Creating a Database, Creating a Database, createdb

createlang, createlang

createuser, Database Roles, createuser

cross compilation, Installation Procedure

cross join, Joined Tables

cstring, Pseudo-Types

ctid, System Columns, View Rules in Non-SELECT Statements

cube, cube

cume_dist, Window Functions

current_catalog, System Information Functions

current_database, System Information Functions

current_date, Date/Time Functions and Operators

current_schema, System Information Functions

current_time, Date/Time Functions and Operators

current_timestamp, Date/Time Functions and Operators

current_user, System Information Functions

currval, Sequence Manipulation Functions

cursor

CLOSE, CLOSE
DECLARE, DECLARE
FETCH, FETCH
in PL/pgSQL, Cursors
MOVE, MOVE
showing the query plan, EXPLAIN

cursor_tuple_fraction configuration parameter, Other Planner Options

custom_variable_classes configuration parameter, Customized Options

Cygwin

installation on, Cygwin

D

data area

see database cluster

data partitioning, High Availability, Load Balancing, and Replication

data type, Data Types

base, The PostgreSQL Type System
category, Overview
composite, The PostgreSQL Type System
constant, Constants of Other Types
conversion, Type Conversion
enumerated (enum), Enumerated Types
internal organization, Base Types in C-Language Functions
numeric, Numeric Types
type cast, Type Casts
user-defined, User-Defined Types

database, Managing Databases

creating, Creating a Database
privilege to create, Role Attributes

database activity

monitoring, Monitoring Database Activity

database cluster, Concepts, Creating a Database Cluster

data_directory configuration parameter, File Locations

date, Date/Time Types, Dates

constants, Special Values

current, Current Date/Time

output format, Date/Time Output

see also formatting

DateStyle configuration parameter, Locale and Formatting

date_part, Date/Time Functions and Operators, EXTRACT, date_part

date_trunc, Date/Time Functions and Operators, date_trunc

dblink, dblink

db_user_namespace configuration parameter, Security and Authentication

deadlock, Deadlocks

timeout during, Lock Management

deadlock_timeout configuration parameter, Lock Management

DEALLOCATE, DEALLOCATE

debug_assertions configuration parameter, Developer Options

debug_deadlocks configuration parameter, Developer Options

debug_pretty_print configuration parameter, What To Log

debug_print_parse configuration parameter, What To Log

debug_print_plan configuration parameter, What To Log

debug_print_rewritten configuration parameter, What To Log

decimal

see numeric

DECLARE, DECLARE

decode, String Functions and Operators

decode_bytea

in PL/Perl, Utility functions in PL/Perl

default value, Default Values

changing, Changing a Column's Default Value

default_statistics_target configuration parameter, Other Planner Options

default_tablespace configuration parameter, Statement Behavior

default_text_search_config configuration parameter, Locale and Formatting

default_transaction_isolation configuration parameter, Statement Behavior

default_transaction_read_only configuration parameter, Statement Behavior

default_with_oids configuration parameter, Previous PostgreSQL Versions

degrees, Mathematical Functions and Operators

delay, Delaying Execution

DELETE, Deletions, Deleting Data, DELETE

deleting, Deleting Data

dense_rank, Window Functions

diameter, Geometric Functions and Operators

dict_int, dict_int

dict_xsyn, dict_xsyn

Digital UNIX

see Tru64 UNIX

dirty read, Transaction Isolation

DISCARD, DISCARD

disjunction, Logical Operators

disk drive, WAL Internals

disk space, Recovering Disk Space

disk usage, Determining Disk Usage

DISTINCT, Querying a Table, DISTINCT

div, Mathematical Functions and Operators

DO, DO

document

text search, What Is a Document?

dollar quoting, Dollar-Quoted String Constants

double precision, Floating-Point Types

DROP AGGREGATE, DROP AGGREGATE

DROP CAST, DROP CAST

DROP CONVERSION, DROP CONVERSION

DROP DATABASE, Destroying a Database, DROP DATABASE

DROP DOMAIN, DROP DOMAIN

DROP FOREIGN DATA WRAPPER, DROP FOREIGN DATA WRAPPER

DROP FUNCTION, DROP FUNCTION

DROP GROUP, DROP GROUP

DROP INDEX, DROP INDEX

DROP LANGUAGE, DROP LANGUAGE

DROP OPERATOR, DROP OPERATOR

DROP OPERATOR CLASS, DROP OPERATOR CLASS

DROP OPERATOR FAMILY, DROP OPERATOR FAMILY

DROP OWNED, DROP OWNED

DROP ROLE, Database Roles, DROP ROLE

DROP RULE, DROP RULE

DROP SCHEMA, DROP SCHEMA

DROP SEQUENCE, DROP SEQUENCE

DROP SERVER, DROP SERVER

DROP TABLE, Creating a New Table, DROP TABLE

DROP TABLESPACE, DROP TABLESPACE

DROP TEXT SEARCH CONFIGURATION, DROP TEXT SEARCH CONFIGURATION

DROP TEXT SEARCH DICTIONARY, DROP TEXT SEARCH DICTIONARY

DROP TEXT SEARCH PARSER, DROP TEXT SEARCH PARSER

DROP TEXT SEARCH TEMPLATE, DROP TEXT SEARCH TEMPLATE

DROP TRIGGER, DROP TRIGGER

DROP TYPE, DROP TYPE

DROP USER, DROP USER

DROP USER MAPPING, DROP USER MAPPING

DROP VIEW, DROP VIEW

dropdb, Destroying a Database, dropdb

droplang, droplang

dropuser, Database Roles, dropuser

DTD, Creating XML Values

DTrace, Installation Procedure, Dynamic Tracing

duplicate, Querying a Table

duplicates, DISTINCT

dynamic loading, Other Defaults, Dynamic Loading

dynamic_library_path, Dynamic Loading

dynamic_library_path configuration parameter, Other Defaults

E

earthdistance, earthdistance

ECPG, ECPG - Embedded SQL in C, ecpg

effective_cache_size configuration parameter, Planner Cost Constants

effective_io_concurrency configuration parameter, Asynchronous Behavior

elog, Reporting Errors Within the Server

in PL/Perl, Utility functions in PL/Perl
in PL/Python, Utility Functions
in PL/Tcl, Database Access from PL/Tcl

embedded SQL

in C, ECPG - Embedded SQL in C

enabled role, enabled_roles

enable_bitmapscan configuration parameter, Planner Method Configuration

enable_hashagg configuration parameter, Planner Method Configuration

enable_hashjoin configuration parameter, Planner Method Configuration

enable_indexscan configuration parameter, Planner Method Configuration

enable_material configuration parameter, Planner Method Configuration

enable_mergejoin configuration parameter, Planner Method Configuration

enable_nestloop configuration parameter, Planner Method Configuration

enable_seqscan configuration parameter, Planner Method Configuration

enable_sort configuration parameter, Planner Method Configuration

enable_tidscan configuration parameter, Planner Method Configuration

encode, String Functions and Operators

encode_array_constructor

in PL/Perl, Utility functions in PL/Perl

encode_array_literal

in PL/Perl, Utility functions in PL/Perl

encode_bytea

in PL/Perl, Utility functions in PL/Perl

encryption, Encryption Options

for specific columns, pgcrypto

END, END

enumerated types, Enumerated Types

environment variable, Environment Variables

ereport, Reporting Errors Within the Server

error codes

libpq, Main Functions
list of, PostgreSQL Error Codes

error message, Connection Status Functions

escape string syntax, String Constants with C-Style Escapes

escape_string_warning configuration parameter, Previous PostgreSQL Versions

escaping strings

in libpq, Escaping Strings for Inclusion in SQL Commands

every, Aggregate Functions

EXCEPT, Combining Queries

exceptions

in PL/PgSQL, Trapping Errors

exclusion constraint, Exclusion Constraints

EXECUTE, EXECUTE

EXISTS, Subquery Expressions

EXIT

in PL/pgSQL, EXIT

exp, Mathematical Functions and Operators

EXPLAIN, Using EXPLAIN, EXPLAIN

expression

order of evaluation, Expression Evaluation Rules
syntax, Value Expressions

extending SQL, Extending SQL

extensions, Extensions

external_pid_file configuration parameter, File Locations

extract, Date/Time Functions and Operators, EXTRACT, date_part

extra_float_digits configuration parameter, Locale and Formatting

F

failover, High Availability, Load Balancing, and Replication

false, Boolean Type

fast path, The Fast-Path Interface

FETCH, FETCH

field

computed, SQL Functions on Composite Types

field selection, Field Selection

file system mount points, Use of Secondary File Systems

first_value, Window Functions

flex, Requirements

float4

see real

float8

see double precision

floating point, Floating-Point Types

floating-point

display, Locale and Formatting

floor, Mathematical Functions and Operators

foreign key, Foreign Keys, Foreign Keys

formatting, Data Type Formatting Functions

format_type, System Information Functions

Free Space Map, Free Space Map

FreeBSD

IPC configuration, Shared Memory and Semaphores
shared library, Compiling and Linking Dynamically-Loaded Functions
start script, Starting the Database Server

from_collapse_limit configuration parameter, Other Planner Options

FSM

see Free Space Map

fsync configuration parameter, Settings

full text search, Full Text Search

data types, Text Search Types
functions and operators, Text Search Types

full_page_writes configuration parameter, Settings

function, Functions and Operators

default values for arguments, SQL Functions with Default Values for Arguments

in the FROM clause, Table Functions

internal, Internal Functions

invocation, Function Calls

mixed notation, Using mixed notation

named notation, Using named notation

named parameter, SQL Functions with Parameter Names

output parameter, SQL Functions with Output Parameters

polymorphic, Polymorphic Types

positional notation, Using positional notation

RETURNS TABLE, SQL Functions Returning TABLE

type resolution in an invocation, Functions

user-defined, User-Defined Functions

in C, C-Language Functions
in SQL, Query Language (SQL) Functions

variadic, SQL Functions with Variable Numbers of Arguments

with SETOF, SQL Functions Returning Sets

fuzzystrmatch, fuzzystrmatch

G

generate_series, Set Returning Functions

generate_subscripts, Set Returning Functions

genetic query optimization, Genetic Query Optimizer

GEQO

see genetic query optimization

geqo configuration parameter, Genetic Query Optimizer

geqo_effort configuration parameter, Genetic Query Optimizer

geqo_generations configuration parameter, Genetic Query Optimizer

geqo_pool_size configuration parameter, Genetic Query Optimizer

geqo_seed configuration parameter, Genetic Query Optimizer

geqo_selection_bias configuration parameter, Genetic Query Optimizer

geqo_threshold configuration parameter, Genetic Query Optimizer

get_bit, Binary String Functions and Operators

get_byte, Binary String Functions and Operators

GIN

see index

gin_fuzzy_search_limit configuration parameter, Other Defaults

GiST

see index

global data

in PL/Python, Sharing Data
in PL/Tcl, Global Data in PL/Tcl

GRANT, Privileges, GRANT

GREATEST, GREATEST and LEAST

determination of result type, UNION, CASE, and Related Constructs

GROUP BY, Aggregate Functions, The GROUP BY and HAVING Clauses

grouping, The GROUP BY and HAVING Clauses

GSSAPI, GSSAPI authentication

GUID, UUID Type

H

hash

see index

has_any_column_privilege, System Information Functions

has_column_privilege, System Information Functions

has_database_privilege, System Information Functions

has_foreign_data_wrapper_privilege, System Information Functions

has_function_privilege, System Information Functions

has_language_privilege, System Information Functions

has_schema_privilege, System Information Functions

has_sequence_privilege, System Information Functions

has_server_privilege, System Information Functions

has_tablespace_privilege, System Information Functions

has_table_privilege, System Information Functions

HAVING, Aggregate Functions, The GROUP BY and HAVING Clauses

hba_file configuration parameter, File Locations

height, Geometric Functions and Operators

hierarchical database, Concepts

high availability, High Availability, Load Balancing, and Replication

history

of PostgreSQL, A Brief History of PostgreSQL

host name, Database Connection Control Functions

Hot Standby, High Availability, Load Balancing, and Replication

hot_standby configuration parameter, Standby Servers

HP-UX

installation on, HP-UX
IPC configuration, Shared Memory and Semaphores
shared library, Compiling and Linking Dynamically-Loaded Functions

hstore, hstore

I

ident, Ident-based authentication

identifier

length, Identifiers and Key Words
syntax of, Identifiers and Key Words

ident_file configuration parameter, File Locations

IFNULL, COALESCE

ignore_system_indexes configuration parameter, Developer Options

IMMUTABLE, Function Volatility Categories

IN, Subquery Expressions, Row and Array Comparisons

include

in configuration file, Setting Parameters

index, Indexes

and ORDER BY, Indexes and ORDER BY

B-tree, Index Types

building concurrently, Building Indexes Concurrently

combining multiple indexes, Combining Multiple Indexes

examining usage, Examining Index Usage

on expressions, Indexes on Expressions

for user-defined data type, Interfacing Extensions To Indexes

GIN, Index Types, GIN Indexes

text search, GiST and GIN Index Types

GiST, Index Types, GiST Indexes

text search, GiST and GIN Index Types

hash, Index Types

locks, Locking and Indexes

multicolumn, Multicolumn Indexes

partial, Partial Indexes

unique, Unique Indexes

index scan, Planner Method Configuration

inet (data type), inet

inet_client_addr, System Information Functions

inet_client_port, System Information Functions

inet_server_addr, System Information Functions

inet_server_port, System Information Functions

information schema, The Information Schema

inheritance, Inheritance, Inheritance, Previous PostgreSQL Versions

initcap, String Functions and Operators

initdb, Creating a Database Cluster, initdb

input function, User-Defined Types

of a data type, User-Defined Types

INSERT, Populating a Table With Rows, Inserting Data, INSERT

inserting, Inserting Data

installation, Installation from Source Code

on Windows, Installation from Source Code on Windows

instr, Porting Examples

int2

see smallint

int4

see integer

int8

see bigint

intagg, intagg

intarray, intarray

integer, Numeric Constants, Integer Types

integer_datetimes configuration parameter, Preset Options

interfaces

externally maintained, Client Interfaces

internal, Pseudo-Types

INTERSECT, Combining Queries

interval, Date/Time Types, Interval Input

output format, Interval Output

see also formatting

IntervalStyle configuration parameter, Locale and Formatting

IRIX

installation on, IRIX
shared library, Compiling and Linking Dynamically-Loaded Functions

IS DISTINCT FROM, Comparison Operators, Row and Array Comparisons

IS DOCUMENT, XML Predicates

IS FALSE, Comparison Operators

IS NOT DISTINCT FROM, Comparison Operators, Row and Array Comparisons

IS NOT FALSE, Comparison Operators

IS NOT NULL, Comparison Operators

IS NOT TRUE, Comparison Operators

IS NOT UNKNOWN, Comparison Operators

IS NULL, Comparison Operators, Platform and Client Compatibility

IS TRUE, Comparison Operators

IS UNKNOWN, Comparison Operators

isclosed, Geometric Functions and Operators

isfinite, Date/Time Functions and Operators

isn, isn

ISNULL, Comparison Operators

isopen, Geometric Functions and Operators

J

join, Joins Between Tables, Joined Tables

controlling the order, Controlling the Planner with Explicit JOIN Clauses
cross, Joined Tables
left, Joined Tables
natural, Joined Tables
outer, Joins Between Tables, Joined Tables
right, Joined Tables
self, Joins Between Tables

join_collapse_limit configuration parameter, Other Planner Options

justify_days, Date/Time Functions and Operators

justify_hours, Date/Time Functions and Operators

justify_interval, Date/Time Functions and Operators

K

Kerberos, Kerberos authentication

key word

list of, SQL Key Words
syntax of, Identifiers and Key Words

krb_caseins_users configuration parameter, Security and Authentication

krb_server_keyfile configuration parameter, Security and Authentication

krb_srvname configuration parameter, Security and Authentication

L

label

see alias

lag, Window Functions

language_handler, Pseudo-Types

large object, Large Objects

lastval, Sequence Manipulation Functions

last_value, Window Functions

lc_collate configuration parameter, Preset Options

lc_ctype configuration parameter, Preset Options

lc_messages configuration parameter, Locale and Formatting

lc_monetary configuration parameter, Locale and Formatting

lc_numeric configuration parameter, Locale and Formatting

lc_time configuration parameter, Locale and Formatting

LDAP, Installation Procedure, LDAP authentication

LDAP connection parameter lookup,