Index
Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
- $, 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
- abbrev, Network Address
Functions and Operators
- ABORT, ABORT
- abs, Mathematical Functions
and Operators
- acos, Mathematical
Functions and Operators
- administration tools
-
- externally maintained, Administration Tools
- adminpack, adminpack
- advisory lock, Advisory
Locks
- 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 COLLATION, ALTER
COLLATION
- ALTER CONVERSION, ALTER CONVERSION
- ALTER DATABASE, ALTER
DATABASE
- ALTER DEFAULT PRIVILEGES, ALTER DEFAULT
PRIVILEGES
- ALTER DOMAIN, ALTER
DOMAIN
- ALTER EXTENSION, ALTER
EXTENSION
- ALTER FOREIGN DATA WRAPPER, ALTER FOREIGN DATA
WRAPPER
- ALTER FOREIGN TABLE, ALTER FOREIGN TABLE
- 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
- auth_delay, auth_delay
- auth_delay.milliseconds configuration parameter, Configuration Parameters
- 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
- avg, Aggregate
Functions
- 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, Geometric
Functions and Operators
- box (data type), Boxes
- broadcast, Network Address
Functions and Operators
- 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, Binary String Functions and
Operators
- bytea, Binary Data
Types
- bytea_output configuration parameter, Statement
Behavior
- C, libpq - C Library, ECPG - Embedded SQL in C
- C++, Using C++ for
Extensibility
- canceling
-
- SQL command, Canceling
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
- ceil, 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, Geometric Functions and
Operators
- 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
- COLLATE, Collation
Expressions
- collation, Collation
Support
-
- in PL/pgSQL,
Collation of PL/pgSQL Variables
- in SQL functions, SQL Functions with
Collations
- 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
- concat, String Functions
and Operators
- concat_ws, String
Functions and Operators
- 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
- control file, Extension Files
- 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
- corr, Aggregate
Functions
- correlation, Aggregate
Functions
- cos, Mathematical Functions
and Operators
- cot, Mathematical Functions
and Operators
- count, Aggregate
Functions
- covariance
-
- population, Aggregate Functions
- sample, Aggregate
Functions
- covar_pop, Aggregate
Functions
- covar_samp, 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 AGGREGATE, CREATE AGGREGATE
- CREATE CAST, CREATE
CAST
- CREATE COLLATION, CREATE COLLATION
- CREATE CONVERSION, CREATE CONVERSION
- CREATE DATABASE, Creating a Database, CREATE DATABASE
- CREATE DOMAIN, CREATE
DOMAIN
- CREATE EXTENSION, CREATE EXTENSION
- CREATE FOREIGN DATA WRAPPER, CREATE FOREIGN DATA
WRAPPER
- CREATE FOREIGN TABLE, CREATE FOREIGN TABLE
- 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_query, System
Information Functions
- current_schema, System
Information Functions
- current_schemas, System
Information Functions
- current_setting, System
Administration 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
- 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, Binary 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_deferrable configuration parameter,
Statement
Behavior
- default_transaction_isolation configuration parameter,
Statement
Behavior
- default_transaction_read_only configuration parameter,
Statement
Behavior
- default_with_oids configuration parameter,
Previous PostgreSQL Versions
- deferrable transaction
-
- setting, SET
TRANSACTION
- setting default,
Statement Behavior
- 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 COLLATION, DROP
COLLATION
- DROP CONVERSION, DROP
CONVERSION
- DROP DATABASE, Destroying
a Database, DROP
DATABASE
- DROP DOMAIN, DROP
DOMAIN
- DROP EXTENSION, DROP
EXTENSION
- DROP FOREIGN DATA WRAPPER, DROP FOREIGN DATA
WRAPPER
- DROP FOREIGN TABLE, DROP FOREIGN TABLE
- 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
- dummy_seclabel, dummy_seclabel
- duplicate, Querying a
Table
- duplicates, DISTINCT
- dynamic loading, Other
Defaults, Dynamic
Loading
- dynamic_library_path, Dynamic Loading
- dynamic_library_path configuration parameter, Other
Defaults
- 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, Binary 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
- encode_typed_literal
-
- in PL/Perl, Utility
Functions in PL/Perl
- encryption, Encryption
Options
-
- for specific columns, pgcrypto
- END, END
- enumerated types, Enumerated
Types
- enum_first, Enum Support
Functions
- enum_last, Enum Support
Functions
- enum_range, Enum Support
Functions
- 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
- exit_on_error configuration parameter, Error Handling
- exp, Mathematical Functions
and Operators
- EXPLAIN, Using EXPLAIN,
EXPLAIN
- expression
-
- order of evaluation, Expression
Evaluation Rules
- syntax, Value
Expressions
- extending SQL, Extending
SQL
- extension, Packaging
Related Objects into an Extension
-
- externally maintained, 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
- failover, High
Availability, Load Balancing, and Replication
- false, Boolean
Type
- family, Network Address
Functions and Operators
- fast path, The Fast-Path
Interface
- fdw_handler, Pseudo-Types
- FETCH, FETCH
- field
-
- computed, SQL
Functions on Composite Types
- field selection, Field
Selection
- file_fdw, file_fdw
- 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 data, Foreign
Data
- foreign data wrapper
-
- handler for, Writing A
Foreign Data Wrapper
- foreign key, Foreign Keys,
Foreign
Keys
- foreign table, Foreign
Data
- format, String Functions
and Operators
-
- use in PL/pgSQL,
Executing Dynamic Commands
- 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
- functional dependency, The GROUP BY
and HAVING Clauses
- fuzzystrmatch, fuzzystrmatch
- 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
- get_current_ts_config, Text Search 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
- 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, Network Address
Functions and Operators
- host name, Database
Connection Control Functions
- hostmask, Network Address
Functions and Operators
- Hot Standby, High
Availability, Load Balancing, and Replication
- hot_standby configuration parameter,
Standby Servers
- hot_standby_feedback 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
- ident, Ident
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
- Initialization Fork, The
Initialization Fork
- input function, 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, IS
DOCUMENT
- 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
- is_array_ref
-
- in PL/Perl, Utility
Functions in PL/Perl
- 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
- 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, LDAP Lookup of Connection
Parameters
- ldconfig, Shared
Libraries
- lead, Window
Functions
- LEAST, GREATEST
and LEAST
-
- determination of result type, UNION, CASE, and Related
Constructs
- left, String Functions
and Operators
- left join, Joined
Tables
- length, String Functions
and Operators, Binary String Functions and
Operators, Geometric
Functions and Operators, Text Search Functions and
Operators
-
- of a binary string
-
- see binary strings, length
- of a character string
-
- see character string, length
- length(tsvector), Manipulating
Documents
- lex, Requirements
- libedit, Requirements
- libperl, Requirements
- libpq, libpq - C Library
- libpq-fe.h, libpq - C Library,
Connection Status
Functions
- libpq-int.h, Connection
Status Functions
- libpython, Requirements
- library finalization function, Dynamic Loading
- library initialization function, Dynamic Loading
- LIKE, LIKE
-
- and locales, Behavior
- LIMIT, LIMIT and
OFFSET
- line segment, Line Segments
- linear regression, Aggregate Functions
- Linux
-
- IPC configuration, Shared Memory and
Semaphores
- shared library, Compiling and Linking
Dynamically-loaded Functions
- start script, Starting
the Database Server
- LISTEN, LISTEN
- listen_addresses configuration parameter,
Connection Settings
- ln, Mathematical Functions
and Operators
- lo, lo
- LOAD, LOAD
- load balancing, High
Availability, Load Balancing, and Replication
- locale, Creating a
Database Cluster, Locale
Support
- localtime, Date/Time
Functions and Operators
- localtimestamp, Date/Time Functions and
Operators
- local_preload_libraries configuration parameter, Other
Defaults
- lock, Explicit
Locking, Table-level Locks,
LOCK
-
- advisory, Advisory
Locks
- monitoring, Viewing
Locks
- log, Mathematical Functions
and Operators
- log shipping, High
Availability, Load Balancing, and Replication
- logging_collector configuration parameter, Where
To Log
- login privilege, Role
Attributes
- log_autovacuum_min_duration configuration parameter,
Automatic
Vacuuming
- log_btree_build_stats configuration parameter, Developer Options
- log_checkpoints configuration parameter, What
To Log
- log_connections configuration parameter, What
To Log
- log_destination configuration parameter, Where
To Log
- log_directory configuration parameter, Where
To Log
- log_disconnections configuration parameter, What
To Log
- log_duration configuration parameter, What
To Log
- log_error_verbosity configuration parameter, What
To Log
- log_executor_stats configuration parameter,
Statistics Monitoring
- log_filename configuration parameter, Where
To Log
- log_file_mode configuration parameter, Where
To Log
- log_hostname configuration parameter, What
To Log
- log_line_prefix configuration parameter, What
To Log
- log_lock_waits configuration parameter, What
To Log
- log_min_duration_statement configuration parameter,
When
To Log
- log_min_error_statement configuration parameter, When
To Log
- log_min_messages configuration parameter, When
To Log
- log_parser_stats configuration parameter,
Statistics Monitoring
- log_planner_stats configuration parameter,
Statistics Monitoring
- log_rotation_age configuration parameter, Where
To Log
- log_rotation_size configuration parameter, Where
To Log
- log_statement configuration parameter, What
To Log
- log_statement_stats configuration parameter,
Statistics Monitoring
- log_temp_files configuration parameter, What
To Log
- log_timezone configuration parameter, What
To Log
- log_truncate_on_rotation configuration parameter,
Where To Log
- looks_like_number
-
- in PL/Perl, Utility
Functions in PL/Perl
- loop
-
- in PL/pgSQL,
Simple Loops
- lower, String Functions
and Operators
-
- and locales, Behavior
- lo_close, Closing a
Large Object Descriptor
- lo_compat_privileges configuration parameter,
Previous PostgreSQL Versions
- lo_creat, Creating
a Large Object, Server-side
Functions
- lo_create, Creating a Large Object,
Server-side Functions
- lo_export, Exporting a Large Object,
Server-side Functions
- lo_import, Importing a Large Object,
Server-side Functions
- lo_import_with_oid, Importing a Large
Object
- lo_lseek, Seeking in
a Large Object
- lo_open, Opening an
Existing Large Object
- lo_read, Reading
Data from a Large Object
- lo_tell, Obtaining
the Seek Position of a Large Object
- lo_truncate, Truncating a Large
Object
- lo_unlink, Removing a Large Object,
Server-side Functions
- lo_write, Writing
Data to a Large Object
- lpad, String Functions
and Operators
- lseg, Line
Segments, Geometric
Functions and Operators
- ltree, ltree
- ltrim, String Functions
and Operators
- MAC address
-
- see macaddr
- Mac OS X
-
- IPC configuration, Shared Memory and
Semaphores
- shared library, Compiling and Linking
Dynamically-loaded Functions
- macaddr (data type), macaddr
- magic block, Dynamic Loading
- maintenance, Routine Database
Maintenance Tasks
- maintenance_work_mem configuration parameter,
Memory
- make, Requirements
- MANPATH, Environment
Variables
- masklen, Network Address
Functions and Operators
- max, Aggregate
Functions
- max_connections configuration parameter,
Connection Settings
- max_files_per_process configuration parameter,
Kernel Resource Usage
- max_function_args configuration parameter, Preset Options
- max_identifier_length configuration parameter, Preset Options
- max_index_keys configuration parameter, Preset Options
- max_locks_per_transaction configuration parameter,
Lock Management
- max_pred_locks_per_transaction configuration parameter,
Lock Management
- max_prepared_transactions configuration parameter,
Memory
- max_stack_depth configuration parameter,
Memory
- max_standby_archive_delay configuration parameter,
Standby Servers
- max_standby_streaming_delay configuration parameter,
Standby Servers
- max_wal_senders configuration parameter,
Master Server
- md5, String Functions and
Operators, Binary
String Functions and Operators, Password
Authentication
- memory context
-
- in SPI, Memory
Management
- min, Aggregate
Functions
- MinGW
-
- installation on,
MinGW/Native Windows
- mod, Mathematical Functions
and Operators
- monitoring
-
- database activity, Monitoring Database Activity
- MOVE, MOVE
- Multiversion Concurrency Control, Introduction
- MVCC, Introduction
- name
-
- qualified, Creating a
Schema
- syntax of, Identifiers
and Key Words
- unqualified, The Schema Search
Path
- NaN
-
- see not a number
- natural join, Joined
Tables
- negation, Logical
Operators
- NetBSD
-
- IPC configuration, Shared Memory and
Semaphores
- shared library, Compiling and Linking
Dynamically-loaded Functions
- start script, Starting
the Database Server
- netmask, Network Address
Functions and Operators
- network, Network Address
Functions and Operators
-
- data types, Network
Address Types
- Network Attached Storage (NAS)
-
- see Network File Systems
- Network File Systems, Network File
Systems
- nextval, Sequence
Manipulation Functions
- NFS
-
- see Network File Systems
- non-durable, Non-Durable
Settings
- nonblocking connection, Database Connection Control
Functions, Asynchronous
Command Processing
- nonrepeatable read, Transaction Isolation
- NOT (operator), Logical
Operators
- not a number
-
- double precision, Floating-Point
Types
- numeric (data type), Arbitrary
Precision Numbers
- NOT IN, Subquery
Expressions, Row and
Array Comparisons
- not-null constraint, Not-Null Constraints
- notation
-
- functions, Calling
Functions
- notice processing
-
- in libpq, Notice Processing
- notice processor, Notice Processing
- notice receiver, Notice Processing
- NOTIFY, NOTIFY
-
- in libpq, Asynchronous
Notification
- NOTNULL, Comparison
Operators
- now, Date/Time
Functions and Operators
- npoints, Geometric
Functions and Operators
- nth_value, Window
Functions
- ntile, Window
Functions
- null value
-
- with check constraints, Check Constraints
- comparing, Comparison Operators
- default value, Default
Values
- in DISTINCT, DISTINCT
- in libpq, Retrieving Query
Result Information
- in PL/Perl, PL/Perl
Functions and Arguments
- in PL/Python, Null, None
- with unique constraints, Unique
Constraints
- NULLIF, NULLIF
- number
-
- constant, Numeric
Constants
- numeric, Numeric Constants
- numeric (data type), Arbitrary
Precision Numbers
- numnode, Text Search
Functions and Operators, Manipulating
Queries
- NVL, COALESCE
- object identifier
-
- data type, Object
Identifier Types
- object-oriented database, Concepts
- obj_description, System
Information Functions
- octet_length, String
Functions and Operators, Binary String Functions and
Operators
- OFFSET, LIMIT and
OFFSET
- oid, Object Identifier
Types
-
- column, System
Columns
- in libpq, Retrieving Other
Result Information
- oid2name, oid2name
- ONLY, The FROM
Clause
- opaque, Pseudo-Types
- OpenBSD
-
- IPC configuration, Shared Memory and
Semaphores
- shared library, Compiling and Linking
Dynamically-loaded Functions
- start script, Starting
the Database Server
- OpenSSL, Installation
Procedure
-
- see also SSL
- operator, Functions and
Operators
-
- invocation, Operator
Invocations
- logical, Logical
Operators
- precedence, Operator
Precedence
- syntax, Operators
- type resolution in an invocation, Operators
- user-defined, User-defined
Operators
- operator class, Operator
Classes and Operator Families, Index Methods and Operator
Classes
- operator family, Operator
Classes and Operator Families, Operator Classes and Operator
Families
- OR (operator), Logical
Operators
- Oracle
-
- porting from PL/SQL to PL/pgSQL, Porting from Oracle
PL/SQL
- ORDER BY, Querying a
Table, Sorting Rows
-
- and locales, Behavior
- ordering operator, System Dependencies
on Operator Classes
- outer join, Joined
Tables
- output function, User-defined
Types
- OVER clause, Window
Function Calls
- overlay, String Functions
and Operators, Binary String Functions and
Operators
- overloading
-
- functions, Function
Overloading
- operators, User-defined
Operators
- owner, Privileges
- pageinspect, pageinspect
- palloc, Writing
Code
- PAM, Installation
Procedure, PAM
Authentication
- parameter
-
- syntax, Positional
Parameters
- parenthesis, Value
Expressions
- partitioning, Partitioning
- password, Role
Attributes
-
- authentication, Password
Authentication
- of the superuser, Creating a Database
Cluster
- password file, The Password
File
- passwordcheck, passwordcheck
- password_encryption configuration parameter,
Security and Authentication
- path, Geometric
Functions and Operators, Environment Variables
-
- for schemas,
Statement Behavior
- path (data type), Paths
- pattern matching, Pattern Matching
- patterns
-
- in psql and pg_dump, Patterns
- pause_at_recovery_target recovery parameter, Recovery Target
Settings
- pclose, Geometric
Functions and Operators
- peer, Peer
Authentication
- percent_rank, Window
Functions
- performance, Performance
Tips
- perl, Requirements, PL/Perl - Perl Procedural Language
- permission
-
- see privilege
- pfree, Writing
Code
- PGAPPNAME, Environment
Variables
- pgbench, pgbench
- PGcancel, Canceling Queries
in Progress
- PGCLIENTENCODING, Environment
Variables
- PGconn, Database Connection
Control Functions
- PGCONNECT_TIMEOUT, Environment Variables
- pgcrypto, pgcrypto
- PGDATA, Creating a
Database Cluster
- PGDATABASE, Environment
Variables
- PGDATESTYLE, Environment
Variables
- PGEventProc, Event Callback
Procedure
- PGGEQO, Environment
Variables
- PGGSSLIB, Environment
Variables
- PGHOST, Environment
Variables
- PGHOSTADDR, Environment
Variables
- PGKRBSRVNAME, Environment
Variables
- PGLOCALEDIR, Environment
Variables
- PGOPTIONS, Environment
Variables
- PGPASSFILE, Environment
Variables
- PGPASSWORD, Environment
Variables
- PGPORT, Environment
Variables
- PGREALM, Environment
Variables
- PGREQUIREPEER, Environment
Variables
- PGREQUIRESSL, Environment
Variables
- PGresult, Main
Functions
- pgrowlocks, pgrowlocks
- PGSERVICE, Environment
Variables
- PGSERVICEFILE, Environment
Variables
- PGSSLCERT, Environment
Variables
- PGSSLCRL, Environment
Variables
- PGSSLKEY, Environment
Variables
- PGSSLMODE, Environment
Variables
- PGSSLROOTCERT, Environment
Variables
- pgstattuple, pgstattuple
- PGSYSCONFDIR, Environment
Variables
- PGTZ, Environment
Variables
- PGUSER, Environment
Variables
- pgxs, Extension Building
Infrastructure
- pg_advisory_lock, System
Administration Functions
- pg_advisory_lock_shared, System Administration
Functions
- pg_advisory_unlock, System
Administration Functions
- pg_advisory_unlock_all, System Administration
Functions
- pg_advisory_unlock_shared, System Administration
Functions
- pg_advisory_xact_lock, System Administration
Functions
- pg_advisory_xact_lock_shared, System Administration
Functions
- pg_aggregate, pg_aggregate
- pg_am, pg_am
- pg_amop, pg_amop
- pg_amproc, pg_amproc
- pg_archivecleanup, pg_archivecleanup
- pg_attrdef, pg_attrdef
- pg_attribute, pg_attribute
- pg_authid, pg_authid
- pg_auth_members, pg_auth_members
- pg_available_extensions, pg_available_extensions
- pg_available_extension_versions, pg_available_extension_versions
- pg_backend_pid, System
Information Functions
- pg_basebackup, pg_basebackup
- pg_buffercache, pg_buffercache
- pg_cancel_backend, System
Administration Functions
- pg_cast, pg_cast
- pg_class, pg_class
- pg_client_encoding, String Functions and
Operators
- pg_collation, pg_collation
- pg_collation_is_visible, System Information Functions
- pg_column_size, System
Administration Functions
- pg_config, pg_config
-
- with libpq, Building libpq
Programs
- with user-defined C functions, Writing Code
- pg_conf_load_time, System
Information Functions
- pg_constraint, pg_constraint
- pg_controldata, pg_controldata
- pg_conversion, pg_conversion
- pg_conversion_is_visible, System Information Functions
- pg_create_restore_point, System Administration
Functions
- pg_ctl, Creating a
Database Cluster, Starting
the Database Server, pg_ctl
- pg_current_xlog_insert_location, System Administration
Functions
- pg_current_xlog_location, System Administration
Functions
- pg_cursors, pg_cursors
- pg_database, Template Databases, pg_database
- pg_database_size, System
Administration Functions
- pg_db_role_setting, pg_db_role_setting
- pg_default_acl, pg_default_acl
- pg_depend, pg_depend
- pg_describe_object, System
Information Functions
- pg_description, pg_description
- pg_dump, pg_dump
- pg_dumpall, pg_dumpall
-
- use during upgrade, Upgrading Data
via pg_dump
- pg_enum, pg_enum
- pg_extension, pg_extension
- pg_extension_config_dump, Extension Configuration
Tables
- pg_foreign_data_wrapper, pg_foreign_data_wrapper
- pg_foreign_server, pg_foreign_server
- pg_foreign_table, pg_foreign_table
- pg_freespacemap, pg_freespacemap
- pg_function_is_visible, System Information Functions
- pg_get_constraintdef, System Information Functions
- pg_get_expr, System
Information Functions
- pg_get_functiondef, System
Information Functions
- pg_get_function_arguments, System Information Functions
- pg_get_function_identity_arguments, System Information Functions
- pg_get_function_result, System Information Functions
- pg_get_indexdef, System
Information Functions
- pg_get_keywords, System
Information Functions
- pg_get_ruledef, System
Information Functions
- pg_get_serial_sequence, System Information Functions
- pg_get_triggerdef, System
Information Functions
- pg_get_userbyid, System
Information Functions
- pg_get_viewdef, System
Information Functions
- pg_group, pg_group
- pg_has_role, System
Information Functions
- pg_hba.conf, The
pg_hba.conf File
- pg_ident.conf, User
Name Maps
- pg_index, pg_index
- pg_indexes, pg_indexes
- pg_indexes_size, System
Administration Functions
- pg_inherits, pg_inherits
- pg_is_in_recovery, System
Administration Functions
- pg_is_other_temp_schema, System Information Functions
- pg_is_xlog_replay_paused, System Administration
Functions
- pg_language, pg_language
- pg_largeobject, pg_largeobject
- pg_largeobject_metadata, pg_largeobject_metadata
- pg_last_xact_replay_timestamp, System Administration
Functions
- pg_last_xlog_receive_location, System Administration
Functions
- pg_last_xlog_replay_location, System Administration
Functions
- pg_listening_channels, System Information Functions
- pg_locks, pg_locks
- pg_ls_dir, System
Administration Functions
- pg_my_temp_schema, System
Information Functions
- pg_namespace, pg_namespace
- pg_notify, pg_notify
- pg_opclass, pg_opclass
- pg_opclass_is_visible, System Information Functions
- pg_operator, pg_operator
- pg_operator_is_visible, System Information Functions
- pg_opfamily, pg_opfamily
- pg_options_to_table, System
Information Functions
- pg_pltemplate, pg_pltemplate
- pg_postmaster_start_time, System Information Functions
- pg_prepared_statements, pg_prepared_statements
- pg_prepared_xacts, pg_prepared_xacts
- pg_proc, pg_proc
- pg_read_binary_file, System Administration
Functions
- pg_read_file, System
Administration Functions
- pg_relation_filenode, System Administration
Functions
- pg_relation_filepath, System Administration
Functions
- pg_relation_size, System
Administration Functions
- pg_reload_conf, System
Administration Functions
- pg_restore, pg_restore
- pg_rewrite, pg_rewrite
- pg_roles, pg_roles
- pg_rotate_logfile, System
Administration Functions
- pg_rules, pg_rules
- pg_seclabel, pg_seclabel
- pg_seclabels, pg_seclabels
- pg_service.conf, The
Connection Service File
- pg_settings, pg_settings
- pg_shadow, pg_shadow
- pg_shdepend, pg_shdepend
- pg_shdescription, pg_shdescription
- pg_size_pretty, System
Administration Functions
- pg_sleep, Delaying
Execution
- pg_standby, pg_standby
- pg_start_backup, System
Administration Functions
- pg_statio_all_indexes, Viewing
Collected Statistics
- pg_statio_all_sequences, Viewing
Collected Statistics
- pg_statio_all_tables, Viewing
Collected Statistics
- pg_statio_sys_indexes, Viewing
Collected Statistics
- pg_statio_sys_sequences, Viewing
Collected Statistics
- pg_statio_sys_tables, Viewing
Collected Statistics
- pg_statio_user_indexes, Viewing
Collected Statistics
- pg_statio_user_sequences, Viewing
Collected Statistics
- pg_statio_user_tables, Viewing
Collected Statistics
- pg_statistic, Statistics
Used by the Planner, pg_statistic
- pg_stats, Statistics Used by
the Planner, pg_stats
- pg_stat_activity, Viewing
Collected Statistics
- pg_stat_all_indexes, Viewing
Collected Statistics
- pg_stat_all_tables, Viewing
Collected Statistics
- pg_stat_bgwriter, Viewing
Collected Statistics
- pg_stat_database, Viewing
Collected Statistics
- pg_stat_database_conflicts, Viewing
Collected Statistics
- pg_stat_file, System
Administration Functions
- pg_stat_replication, Viewing
Collected Statistics
- pg_stat_statements, pg_stat_statements
- pg_stat_sys_indexes, Viewing
Collected Statistics
- pg_stat_sys_tables, Viewing
Collected Statistics
- pg_stat_user_functions, Viewing
Collected Statistics
- pg_stat_user_indexes, Viewing
Collected Statistics
- pg_stat_user_tables, Viewing
Collected Statistics
- pg_stat_xact_all_tables, Viewing
Collected Statistics
- pg_stat_xact_sys_tables, Viewing
Collected Statistics
- pg_stat_xact_user_functions, Viewing
Collected Statistics
- pg_stat_xact_user_tables, Viewing
Collected Statistics
- pg_stop_backup, System
Administration Functions
- pg_switch_xlog, System
Administration Functions
- pg_tables, pg_tables
- pg_tablespace, pg_tablespace
- pg_tablespace_databases, System Information Functions
- pg_tablespace_size, System
Administration Functions
- pg_table_is_visible, System
Information Functions
- pg_table_size, System
Administration Functions
- pg_terminate_backend, System Administration
Functions
- pg_test_fsync, pg_test_fsync
- pg_timezone_abbrevs, pg_timezone_abbrevs
- pg_timezone_names, pg_timezone_names
- pg_total_relation_size, System Administration
Functions
- pg_trgm, pg_trgm
- pg_trigger, pg_trigger
- pg_try_advisory_lock, System Administration
Functions
- pg_try_advisory_lock_shared, System Administration
Functions
- pg_try_advisory_xact_lock, System Administration
Functions
- pg_try_advisory_xact_lock_shared, System Administration
Functions
- pg_ts_config, pg_ts_config
- pg_ts_config_is_visible, System Information Functions
- pg_ts_config_map, pg_ts_config_map
- pg_ts_dict, pg_ts_dict
- pg_ts_dict_is_visible, System Information Functions
- pg_ts_parser, pg_ts_parser
- pg_ts_parser_is_visible, System Information Functions
- pg_ts_template, pg_ts_template
- pg_ts_template_is_visible, System Information Functions
- pg_type, pg_type
- pg_typeof, System
Information Functions
- pg_type_is_visible, System
Information Functions
- pg_upgrade, pg_upgrade
- pg_user, pg_user
- pg_user_mapping, pg_user_mapping
- pg_user_mappings, pg_user_mappings
- pg_views, pg_views
- pg_xlogfile_name, System
Administration Functions
- pg_xlogfile_name_offset, System Administration
Functions
- pg_xlog_replay_pause, System Administration
Functions
- pg_xlog_replay_resume, System Administration
Functions
- phantom read, Transaction
Isolation
- pi, Mathematical Functions
and Operators
- PIC, Compiling and Linking
Dynamically-loaded Functions
- PID
-
- determining PID of server process
-
- in libpq, Connection
Status Functions
- PITR, Backup and Restore
- PITR standby, High
Availability, Load Balancing, and Replication
- PL/Perl, PL/Perl - Perl Procedural
Language
- PL/PerlU, Trusted and
Untrusted PL/Perl
- PL/pgSQL, PL/pgSQL - SQL
Procedural Language
- PL/Python, PL/Python - Python
Procedural Language
- PL/SQL (Oracle)
-
- porting to PL/pgSQL, Porting from Oracle
PL/SQL
- PL/Tcl, PL/Tcl - Tcl Procedural
Language
- plainto_tsquery, Text
Search Functions and Operators, Parsing
Queries
- plperl.on_init configuration parameter, Configuration
- plperl.on_plperlu_init configuration parameter, Configuration
- plperl.on_plperl_init configuration parameter, Configuration
- plperl.use_strict configuration parameter, Configuration
- plpgsql.variable_conflict configuration parameter,
Variable
Substitution
- point, Points, Geometric Functions and
Operators
- point-in-time recovery, Backup and
Restore
- polygon, Polygons, Geometric Functions and
Operators
- polymorphic function, Polymorphic
Types
- polymorphic type, Polymorphic
Types
- popen, Geometric
Functions and Operators
- port, Database Connection
Control Functions
- port configuration parameter,
Connection Settings
- position, String
Functions and Operators, Binary String Functions and
Operators
- POSTGRES, The
Berkeley POSTGRES Project, Architectural Fundamentals, Starting the Database Server,
Creating a Database,
postgres
- postgres user, The
PostgreSQL User Account
- Postgres95, Postgres95
- postgresql.conf, Setting
Parameters
- postmaster, postmaster
- post_auth_delay configuration parameter, Developer Options
- power, Mathematical
Functions and Operators
- PQbackendPID, Connection
Status Functions
- PQbinaryTuples, Retrieving Query
Result Information
-
- with COPY, Functions
Associated with the COPY Command
- PQcancel, Canceling Queries
in Progress
- PQclear, Main
Functions
- PQclientEncoding, Control
Functions
- PQcmdStatus, Retrieving Other
Result Information
- PQcmdTuples, Retrieving Other
Result Information
- PQconndefaults, Database
Connection Control Functions
- PQconnectdb, Database
Connection Control Functions
- PQconnectdbParams, Database
Connection Control Functions
- PQconnectionNeedsPassword, Connection Status Functions
- PQconnectionUsedPassword, Connection Status Functions
- PQconnectPoll, Database
Connection Control Functions
- PQconnectStart, Database
Connection Control Functions
- PQconnectStartParams, Database Connection Control
Functions
- PQconninfoFree, Miscellaneous
Functions
- PQconninfoParse, Database
Connection Control Functions
- PQconsumeInput, Asynchronous
Command Processing
- PQcopyResult, Miscellaneous
Functions
- PQdb, Connection Status
Functions
- PQdescribePortal, Main Functions
- PQdescribePrepared, Main Functions
- PQencryptPassword, Miscellaneous Functions
- PQendcopy, Obsolete Functions
for COPY
- PQerrorMessage, Connection
Status Functions
- PQescapeBytea, Escaping Strings
for Inclusion in SQL Commands
- PQescapeByteaConn, Escaping Strings
for Inclusion in SQL Commands
- PQescapeIdentifier, Escaping Strings
for Inclusion in SQL Commands
- PQescapeLiteral, Escaping Strings
for Inclusion in SQL Commands
- PQescapeString, Escaping Strings
for Inclusion in SQL Commands
- PQescapeStringConn, Escaping Strings
for Inclusion in SQL Commands
- PQexec, Main
Functions
- PQexecParams, Main Functions
- PQexecPrepared, Main Functions
- PQfformat, Retrieving Query
Result Information
-
- with COPY, Functions
Associated with the COPY Command
- PQfinish, Database
Connection Control Functions
- PQfireResultCreateEvents, Miscellaneous Functions
- PQflush, Asynchronous Command
Processing
- PQfmod, Retrieving Query
Result Information
- PQfn, The Fast-Path
Interface
- PQfname, Retrieving Query
Result Information
- PQfnumber, Retrieving Query
Result Information
- PQfreeCancel, Canceling
Queries in Progress
- PQfreemem, Miscellaneous
Functions
- PQfsize, Retrieving Query
Result Information
- PQftable, Retrieving Query
Result Information
- PQftablecol, Retrieving Query
Result Information
- PQftype, Retrieving Query
Result Information
- PQgetCancel, Canceling
Queries in Progress
- PQgetCopyData, Functions for Receiving
COPY Data
- PQgetisnull, Retrieving Query
Result Information
- PQgetlength, Retrieving Query
Result Information
- PQgetline, Obsolete Functions
for COPY
- PQgetlineAsync, Obsolete Functions
for COPY
- PQgetResult, Asynchronous
Command Processing
- PQgetssl, Connection Status
Functions
- PQgetvalue, Retrieving Query
Result Information
- PQhost, Connection Status
Functions
- PQinitOpenSSL, SSL Library
Initialization
- PQinitSSL, SSL Library
Initialization
- PQinstanceData, Event Support
Functions
- PQisBusy, Asynchronous Command
Processing
- PQisnonblocking, Asynchronous
Command Processing
- PQisthreadsafe, Behavior
in Threaded Programs
- PQlibVersion, Miscellaneous
Functions
-
- see also PQserverVersion
- PQmakeEmptyPGresult, Miscellaneous Functions
- PQnfields, Retrieving Query
Result Information
-
- with COPY, Functions
Associated with the COPY Command
- PQnotifies, Asynchronous
Notification
- PQnparams, Retrieving Query
Result Information
- PQntuples, Retrieving Query
Result Information
- PQoidStatus, Retrieving Other
Result Information
- PQoidValue, Retrieving Other
Result Information
- PQoptions, Connection Status
Functions
- PQparameterStatus, Connection
Status Functions
- PQparamtype, Retrieving Query
Result Information
- PQpass, Connection Status
Functions
- PQping, Database Connection
Control Functions
- PQpingParams, Database
Connection Control Functions
- PQport, Connection Status
Functions
- PQprepare, Main
Functions
- PQprint, Retrieving Query
Result Information
- PQprotocolVersion, Connection
Status Functions
- PQputCopyData, Functions for Sending COPY
Data
- PQputCopyEnd, Functions for Sending COPY
Data
- PQputline, Obsolete Functions
for COPY
- PQputnbytes, Obsolete Functions
for COPY
- PQregisterEventProc, Event Support
Functions
- PQrequestCancel, Canceling
Queries in Progress
- PQreset, Database Connection
Control Functions
- PQresetPoll, Database
Connection Control Functions
- PQresetStart, Database
Connection Control Functions
- PQresStatus, Main Functions
- PQresultAlloc, Miscellaneous
Functions
- PQresultErrorField, Main Functions
- PQresultErrorMessage, Main Functions
- PQresultInstanceData, Event Support
Functions
- PQresultSetInstanceData, Event Support
Functions
- PQresultStatus, Main Functions
- PQsendDescribePortal, Asynchronous Command Processing
- PQsendDescribePrepared, Asynchronous Command Processing
- PQsendPrepare, Asynchronous
Command Processing
- PQsendQuery, Asynchronous
Command Processing
- PQsendQueryParams, Asynchronous Command Processing
- PQsendQueryPrepared, Asynchronous Command Processing
- PQserverVersion, Connection
Status Functions
- PQsetClientEncoding, Control
Functions
- PQsetdb, Database Connection
Control Functions
- PQsetdbLogin, Database
Connection Control Functions
- PQsetErrorVerbosity, Control
Functions
- PQsetInstanceData, Event Support
Functions
- PQsetnonblocking, Asynchronous
Command Processing
- PQsetNoticeProcessor, Notice Processing
- PQsetNoticeReceiver, Notice Processing
- PQsetResultAttrs, Miscellaneous
Functions
- PQsetvalue, Miscellaneous
Functions
- PQsocket, Connection Status
Functions
- PQstatus, Connection Status
Functions
- PQtrace, Control
Functions
- PQtransactionStatus, Connection Status Functions
- PQtty, Connection Status
Functions
- PQunescapeBytea, Escaping Strings
for Inclusion in SQL Commands
- PQuntrace, Control
Functions
- PQuser, Connection Status
Functions
- predicate locking, Serializable
Isolation Level
- PREPARE, PREPARE
- PREPARE TRANSACTION, PREPARE TRANSACTION
- prepared statements
-
- creating, PREPARE
- executing, EXECUTE
- removing, DEALLOCATE
- showing the query plan, EXPLAIN
- preparing a query
-
- in PL/pgSQL, Plan
Caching
- in PL/Python, Database Access
Functions
- in PL/Tcl, Database
Access from PL/Tcl
- pre_auth_delay configuration parameter, Developer Options
- primary key, Primary Keys
- primary_conninfo recovery parameter, Standby Server Settings
- privilege, Privileges
-
- querying, System
Information Functions
- with rules, Rules and
Privileges
- for schemas, Schemas and
Privileges
- with views, Rules and
Privileges
- procedural language, Procedural
Languages
-
- externally maintained, Procedural Languages
- handler for, Writing A
Procedural Language Handler
- protocol
-
- frontend-backend, Frontend/Backend Protocol
- ps
-
- to monitor activity, Standard Unix Tools
- psql, Accessing a
Database, psql
- Python, PL/Python - Python
Procedural Language
- qualified name, Creating a
Schema
- query, Querying a
Table, Queries
- query plan, Using
EXPLAIN
- query tree, The Query
Tree
- querytree, Text
Search Functions and Operators, Manipulating
Queries
- quotation marks
-
- and identifiers, Identifiers
and Key Words
- escaping, String
Constants
- quote_all_identifiers configuration parameter,
Previous PostgreSQL Versions
- quote_ident, String
Functions and Operators
-
- in PL/Perl, Utility
Functions in PL/Perl
- use in PL/pgSQL,
Executing Dynamic Commands
- quote_literal, String
Functions and Operators
-
- in PL/Perl, Utility
Functions in PL/Perl
- use in PL/pgSQL,
Executing Dynamic Commands
- quote_nullable, String
Functions and Operators
-
- in PL/Perl, Utility
Functions in PL/Perl
- use in PL/pgSQL,
Executing Dynamic Commands
- radians, Mathematical
Functions and Operators
- radius, Geometric
Functions and Operators, RADIUS
Authentication
- RAISE, Errors
and Messages
- random, Mathematical
Functions and Operators
- random_page_cost configuration parameter, Planner
Cost Constants
- range table, The Query
Tree
- rank, Window
Functions
- read committed, Read Committed
Isolation Level
- read-only transaction
-
- setting, SET
TRANSACTION
- setting default,
Statement Behavior
- readline, Requirements
- real, Floating-Point
Types
- REASSIGN OWNED, REASSIGN OWNED
- record, Pseudo-Types
- recovery.conf, Recovery
Configuration
- recovery_end_command recovery parameter, Archive Recovery
Settings
- recovery_target_inclusive recovery parameter, Recovery Target
Settings
- recovery_target_name recovery parameter, Recovery Target
Settings
- recovery_target_time recovery parameter, Recovery Target
Settings
- recovery_target_timeline recovery parameter, Recovery Target
Settings
- recovery_target_xid recovery parameter, Recovery Target
Settings
- rectangle, Boxes
- referential integrity, Foreign
Keys, Foreign
Keys
- regclass, Object Identifier
Types
- regconfig, Object Identifier
Types
- regdictionary, Object
Identifier Types
- regexp_matches, String
Functions and Operators, POSIX
Regular Expressions
- regexp_replace, String
Functions and Operators, POSIX
Regular Expressions
- regexp_split_to_array, String Functions and Operators,
POSIX
Regular Expressions
- regexp_split_to_table, String Functions and Operators,
POSIX
Regular Expressions
- regoper, Object Identifier
Types
- regoperator, Object
Identifier Types
- regproc, Object Identifier
Types
- regprocedure, Object
Identifier Types
- regression intercept, Aggregate Functions
- regression slope, Aggregate Functions
- regression test, Installation Procedure
- regression tests, Regression
Tests
- regr_avgx, Aggregate
Functions
- regr_avgy, Aggregate
Functions
- regr_count, Aggregate
Functions
- regr_intercept, Aggregate Functions
- regr_r2, Aggregate
Functions
- regr_slope, Aggregate
Functions
- regr_sxx, Aggregate
Functions
- regr_sxy, Aggregate
Functions
- regr_syy, Aggregate
Functions
- regtype, Object Identifier
Types
- regular expression, SIMILAR
TO Regular Expressions, POSIX
Regular Expressions
-
- see also pattern matching
- regular expressions
-
- and locales, Behavior
- reindex, Routine
Reindexing, REINDEX
- reindexdb, reindexdb
- relation, Concepts
- relational database, Concepts
- RELEASE SAVEPOINT, RELEASE SAVEPOINT
- repeat, String Functions
and Operators
- repeatable read, Repeatable Read
Isolation Level
- replace, String Functions
and Operators
- replication, High
Availability, Load Balancing, and Replication
- replication_timeout configuration parameter,
Master Server
- reporting errors
-
- in PL/pgSQL, Errors and
Messages
- RESET, RESET
- restartpoint, WAL
Configuration
- restart_after_crash configuration parameter, Error Handling
- restore_command recovery parameter, Archive Recovery
Settings
- RESTRICT
-
- with DROP, Dependency
Tracking
- foreign key action, Foreign
Keys
- RETURN NEXT
-
- in PL/pgSQL, RETURN NEXT
and RETURN QUERY
- RETURN QUERY
-
- in PL/pgSQL, RETURN NEXT
and RETURN QUERY
- RETURNING INTO
-
- in PL/pgSQL, Executing
a Query with a Single-row Result
- reverse, String Functions
and Operators
- REVOKE, Privileges, REVOKE
- right, String Functions
and Operators
- right join, Joined
Tables
- role, Database
Roles
-
- applicable, applicable_roles
- enabled, enabled_roles
- membership in, Role
Membership
- privilege to create, Role Attributes
- privilege to initiate replication, Role Attributes
- ROLLBACK, ROLLBACK
-
- psql, Variables
- ROLLBACK PREPARED, ROLLBACK PREPARED
- ROLLBACK TO SAVEPOINT, ROLLBACK TO SAVEPOINT
- round, Mathematical
Functions and Operators
- routine maintenance, Routine
Database Maintenance Tasks
- row, Concepts,
Row
Constructors, Table
Basics
- row estimation
-
- planner, Row
Estimation Examples
- row type, Composite
Types
-
- constructor, Row
Constructors
- row-wise comparison, Row and Array
Comparisons
- row_number, Window
Functions
- rpad, String Functions
and Operators
- rtrim, String Functions
and Operators
- rule, The Rule System
-
- and views, Views and the
Rule System
- for DELETE, Rules on
INSERT, UPDATE, and DELETE
- for INSERT, Rules on
INSERT, UPDATE, and DELETE
- for SELECT, How SELECT Rules
Work
- compared with triggers, Rules Versus Triggers
- for UPDATE, Rules on
INSERT, UPDATE, and DELETE
- SAVEPOINT, SAVEPOINT
- savepoints
-
- defining, SAVEPOINT
- releasing, RELEASE SAVEPOINT
- rolling back, ROLLBACK
TO SAVEPOINT
- scalar
-
- see expression
- schema, Schemas, Overview
-
- creating, Creating a
Schema
- current, The Schema Search
Path, System
Information Functions
- public, The Public
Schema
- removing, Creating a
Schema
- SCO
-
- installation on,
SCO OpenServer and SCO UnixWare
- SCO OpenServer
-
- IPC configuration, Shared Memory and
Semaphores
- search path, The Schema Search
Path
-
- current, System
Information Functions
- search_path, The Schema Search
Path
- search_path configuration parameter, Statement
Behavior
- SECURITY LABEL, SECURITY LABEL
- seg, seg
- segment_size configuration parameter, Preset Options
- SELECT, Querying a
Table, Queries, SELECT
-
- select list, Select Lists
- SELECT INTO, SELECT
INTO
-
- in PL/pgSQL, Executing
a Query with a Single-row Result
- semaphores, Shared Memory and
Semaphores
- sepgsql, sepgsql
- sepgsql.debug_audit configuration parameter, GUC Parameters
- sepgsql.permissive configuration parameter, GUC Parameters
- sequence, Sequence
Manipulation Functions
-
- and serial type, Serial
Types
- sequential scan, Planner
Method Configuration
- seq_page_cost configuration parameter, Planner
Cost Constants
- serial, Serial Types
- serial4, Serial Types
- serial8, Serial Types
- serializable, Serializable
Isolation Level
- Serializable Snapshot Isolation, Introduction
- serialization anomaly, Serializable
Isolation Level
- server log, Error
Reporting and Logging
-
- log file maintenance, Log File Maintenance
- server spoofing, Preventing Server
Spoofing
- server_encoding configuration parameter, Preset Options
- server_version configuration parameter, Preset Options
- server_version_num configuration parameter, Preset Options
- session_replication_role configuration parameter,
Statement Behavior
- session_user, System
Information Functions
- SET, System Administration
Functions, SET
- SET CONSTRAINTS, SET
CONSTRAINTS
- set difference, Combining
Queries
- set intersection, Combining
Queries
- set operation, Combining
Queries
- set returning functions
-
- functions, Set Returning
Functions
- SET ROLE, SET ROLE
- SET SESSION AUTHORIZATION, SET SESSION
AUTHORIZATION
- SET TRANSACTION, SET
TRANSACTION
- set union, Combining
Queries
- SET XML OPTION, Statement
Behavior
- setseed, Mathematical
Functions and Operators
- setval, Sequence
Manipulation Functions
- setweight, Text
Search Functions and Operators, Manipulating
Documents
- set_bit, Binary
String Functions and Operators
- set_byte, Binary
String Functions and Operators
- set_config, System
Administration Functions
- set_masklen, Network Address
Functions and Operators
- shared library, Shared Libraries, Compiling and Linking Dynamically-loaded
Functions
- shared memory, Shared Memory and
Semaphores
- shared_buffers configuration parameter,
Memory
- shared_preload_libraries, Shared Memory and LWLocks
- shared_preload_libraries configuration parameter,
Kernel Resource Usage
- SHMMAX, Shared
Memory and Semaphores
- shobj_description, System
Information Functions
- SHOW, System
Administration Functions, SHOW
- shutdown, Shutting Down
the Server
- SIGHUP, Setting
Parameters, The
pg_hba.conf File, User
Name Maps
- SIGINT, Shutting Down the
Server
- sign, Mathematical
Functions and Operators
- signal
-
- backend processes, System Administration
Functions
- significant digits, Locale
and Formatting
- SIGQUIT, Shutting Down the
Server
- SIGTERM, Shutting Down the
Server
- silent_mode configuration parameter, Where
To Log
- SIMILAR TO, SIMILAR
TO Regular Expressions
- sin, Mathematical Functions
and Operators
- sleep, Delaying
Execution
- sliced bread
-
- see TOAST
- smallint, Integer Types
- Solaris
-
- installation on,
Solaris
- IPC configuration, Shared Memory and
Semaphores
- shared library, Compiling and Linking
Dynamically-loaded Functions
- start script, Starting
the Database Server
- SOME, Aggregate
Functions, Subquery
Expressions, Row and
Array Comparisons
- sorting, Sorting
Rows
- SPI, Server Programming
Interface
-
- examples, spi
- SPI_connect, SPI_connect
- SPI_copytuple, SPI_copytuple
- SPI_cursor_close, SPI_cursor_close
-
- in PL/Perl, Database Access
from PL/Perl
- SPI_cursor_fetch, SPI_cursor_fetch
- SPI_cursor_find, SPI_cursor_find
- SPI_cursor_move, SPI_cursor_move
- SPI_cursor_open, SPI_cursor_open
- SPI_cursor_open_with_args, SPI_cursor_open_with_args
- SPI_cursor_open_with_paramlist, SPI_cursor_open_with_paramlist
- SPI_exec, SPI_exec
- SPI_execp, SPI_execp
- SPI_execute, SPI_execute
- SPI_execute_plan, SPI_execute_plan
- SPI_execute_plan_with_paramlist, SPI_execute_plan_with_paramlist
- SPI_execute_with_args, SPI_execute_with_args
- spi_exec_prepared
-
- in PL/Perl, Database Access
from PL/Perl
- spi_exec_query
-
- in PL/Perl, Database Access
from PL/Perl
- spi_fetchrow
-
- in PL/Perl, Database Access
from PL/Perl
- SPI_finish, SPI_finish
- SPI_fname, SPI_fname
- SPI_fnumber, SPI_fnumber
- SPI_freeplan, SPI_freeplan
-
- in PL/Perl, Database Access
from PL/Perl
- SPI_freetuple, SPI_freetuple
- SPI_freetuptable, SPI_freetuptable
- SPI_getargcount, SPI_getargcount
- SPI_getargtypeid, SPI_getargtypeid
- SPI_getbinval, SPI_getbinval
- SPI_getnspname, SPI_getnspname
- SPI_getrelname, SPI_getrelname
- SPI_gettype, SPI_gettype
- SPI_gettypeid, SPI_gettypeid
- SPI_getvalue, SPI_getvalue
- SPI_is_cursor_plan, SPI_is_cursor_plan
- spi_lastoid, Database
Access from PL/Tcl
- SPI_modifytuple, SPI_modifytuple
- SPI_palloc, SPI_palloc
- SPI_pfree, SPI_pfree
- SPI_pop, SPI_pop
- SPI_prepare, SPI_prepare
-
- in PL/Perl, Database Access
from PL/Perl
- SPI_prepare_cursor, SPI_prepare_cursor
- SPI_prepare_params, SPI_prepare_params
- SPI_push, SPI_push
- spi_query
-
- in PL/Perl, Database Access
from PL/Perl
- spi_query_prepared
-
- in PL/Perl, Database Access
from PL/Perl
- SPI_repalloc, SPI_repalloc
- SPI_returntuple, SPI_returntuple
- SPI_saveplan, SPI_saveplan
- SPI_scroll_cursor_fetch, SPI_scroll_cursor_fetch
- SPI_scroll_cursor_move, SPI_scroll_cursor_move
- split_part, String
Functions and Operators
- SQL/CLI, SQL Conformance
- SQL/Foundation, SQL
Conformance
- SQL/Framework, SQL
Conformance
- SQL/JRT, SQL Conformance
- SQL/MED, SQL Conformance
- SQL/OLB, SQL Conformance
- SQL/PSM, SQL Conformance
- SQL/Schemata, SQL
Conformance
- SQL/XML, SQL Conformance
- sql_inheritance configuration parameter,
Previous PostgreSQL Versions
- sqrt, Mathematical
Functions and Operators
- ssh, Secure TCP/IP Connections
with SSH Tunnels
- SSI, Introduction
- SSL, Secure TCP/IP Connections
with SSL, SSL Support
-
- with libpq, Database
Connection Control Functions, Connection Status Functions
- ssl configuration parameter,
Security and Authentication
- sslinfo, sslinfo
- ssl_ciphers configuration parameter,
Security and Authentication
- ssl_renegotiation_limit configuration parameter,
Security and Authentication
- SSPI, SSPI
Authentication
- STABLE, Function
Volatility Categories
- standard deviation, Aggregate Functions
-
- population, Aggregate Functions
- sample, Aggregate
Functions
- standard_conforming_strings configuration parameter,
Previous PostgreSQL Versions
- standby server, High
Availability, Load Balancing, and Replication
- standby_mode recovery parameter, Standby Server Settings
- START TRANSACTION, START TRANSACTION
- statement_timeout configuration parameter, Statement
Behavior
- statement_timestamp, Date/Time Functions and
Operators
- statistics, Aggregate
Functions, The Statistics
Collector
-
- of the planner, Statistics Used by the Planner,
Updating
Planner Statistics
- stats_temp_directory configuration parameter,
Query and Index Statistics Collector
- stddev, Aggregate
Functions
- stddev_pop, Aggregate
Functions
- stddev_samp, Aggregate
Functions
- STONITH, High
Availability, Load Balancing, and Replication
- storage parameters, Storage
Parameters
- Streaming Replication, High Availability, Load Balancing,
and Replication
- string
-
- see character string
- strings
-
- backslash quotes,
Previous PostgreSQL Versions
- escape warning,
Previous PostgreSQL Versions
- standard conforming,
Previous PostgreSQL Versions
- string_agg, Aggregate
Functions
- string_to_array, Array
Functions and Operators
- strip, Text Search
Functions and Operators, Manipulating
Documents
- strpos, String Functions
and Operators
- subquery, Aggregate
Functions, Scalar
Subqueries, Subqueries,
Subquery
Expressions
- subscript, Subscripts
- substr, String Functions
and Operators
- substring, String
Functions and Operators, Binary String Functions and
Operators, SIMILAR
TO Regular Expressions, POSIX
Regular Expressions
- sum, Aggregate
Functions
- superuser, Accessing a
Database, Role
Attributes
- superuser_reserved_connections configuration parameter,
Connection Settings
- suppress_redundant_updates_trigger, Trigger Functions
- synchronize_seqscans configuration parameter,
Previous PostgreSQL Versions
- synchronous commit, Asynchronous Commit
- Synchronous Replication, High Availability, Load Balancing,
and Replication
- synchronous_commit configuration parameter, Settings
- synchronous_standby_names configuration parameter,
Master Server
- syntax
-
- SQL, SQL Syntax
- syslog_facility configuration parameter, Where
To Log
- syslog_identity configuration parameter, Where
To Log
- system catalog
-
- schema, The System Catalog
Schema
- table, Concepts,
Table Basics
-
- creating, Table
Basics
- inheritance, Inheritance
- modifying, Modifying
Tables
- partitioning, Partitioning
- removing, Table
Basics
- renaming, Renaming a
Table
- TABLE command, SELECT
- table expression, Table Expressions
- table function, Table
Functions
- tablefunc, tablefunc
- tableoid, System
Columns
- tablespace, Tablespaces
-
- default,
Statement Behavior
- temporary,
Statement Behavior
- tan, Mathematical Functions
and Operators
- target list, The Query
Tree
- Tcl, PL/Tcl - Tcl Procedural
Language
- tcp_keepalives_count configuration parameter,
Connection Settings
- tcp_keepalives_idle configuration parameter,
Connection Settings
- tcp_keepalives_interval configuration parameter,
Connection Settings
- template0, Template
Databases
- template1, Creating a
Database, Template
Databases
- temp_buffers configuration parameter,
Memory
- temp_tablespaces configuration parameter, Statement
Behavior
- test, Regression Tests
- test_parser, test_parser
- text, Character
Types, Network Address
Functions and Operators
- text search, Full Text
Search
-
- data types, Text
Search Types
- functions and operators, Text Search Types
- indexes, GiST and
GIN Index Types
- threads
-
- with libpq, Behavior
in Threaded Programs
- tid, Object Identifier
Types
- time, Date/Time
Types, Times
-
- constants, Special Values
- current, Current
Date/Time
- output format, Date/Time
Output
-
- see also formatting
- time span, Date/Time
Types
- time with time zone, Date/Time Types, Times
- time without time zone, Date/Time Types, Times
- time zone, Time Zones,
Locale
and Formatting
-
- conversion, AT
TIME ZONE
- input abbreviations, Date/Time Configuration
Files
- time zone data, Installation Procedure
- time zone names, Locale
and Formatting
- timelines, Backup and
Restore
- timeofday, Date/Time
Functions and Operators
- timeout
-
- client authentication,
Security and Authentication
- deadlock, Lock
Management
- timestamp, Date/Time
Types, Time
Stamps
- timestamp with time zone, Date/Time Types, Time Stamps
- timestamp without time zone, Date/Time Types, Time Stamps
- timestamptz, Date/Time
Types
- timezone configuration parameter, Locale
and Formatting
- timezone_abbreviations configuration parameter, Locale
and Formatting
- TOAST, TOAST
-
- and user-defined types, User-defined Types
- per-column storage settings, Description
- versus large objects, Introduction
- token, Lexical
Structure
- to_ascii, String
Functions and Operators
- to_char, Data Type
Formatting Functions
-
- and locales, Behavior
- to_date, Data Type
Formatting Functions
- to_hex, String Functions
and Operators
- to_number, Data Type
Formatting Functions
- to_timestamp, Data
Type Formatting Functions
- to_tsquery, Text
Search Functions and Operators, Parsing
Queries
- to_tsvector, Text
Search Functions and Operators, Parsing
Documents
- trace_locks configuration parameter, Developer Options
- trace_lock_oidmin configuration parameter, Developer Options
- trace_lock_table configuration parameter, Developer Options
- trace_lwlocks configuration parameter, Developer Options
- trace_notify configuration parameter, Developer Options
- trace_recovery_messages configuration parameter, Developer Options
- trace_sort configuration parameter, Developer Options
- trace_userlocks configuration parameter, Developer Options
- track_activities configuration parameter,
Query and Index Statistics Collector
- track_activity_query_size configuration parameter,
Query and Index Statistics Collector
- track_counts configuration parameter,
Query and Index Statistics Collector
- track_functions configuration parameter,
Query and Index Statistics Collector
- transaction, Transactions
- transaction ID
-
- wraparound, Preventing
Transaction ID Wraparound Failures
- transaction isolation, Transaction Isolation
- transaction isolation level, Transaction Isolation
-
- read committed, Read Committed
Isolation Level
- repeatable read, Repeatable
Read Isolation Level
- serializable, Serializable
Isolation Level
- setting, SET
TRANSACTION
- setting default,
Statement Behavior
- transaction log
-
- see WAL
- transaction_timestamp, Date/Time Functions and
Operators
- transform_null_equals configuration parameter,
Platform and Client Compatibility
- translate, String
Functions and Operators
- trigger, Pseudo-Types,
Triggers
-
- arguments for trigger functions, Overview of Trigger
Behavior
- for updating a derived tsvector column, Triggers
for Automatic Updates
- in C, Writing
Trigger Functions in C
- in PL/pgSQL, Trigger
Procedures
- in PL/Python, Trigger
Functions
- in PL/Tcl, Trigger
Procedures in PL/Tcl
- compared with rules, Rules Versus Triggers
- trigger_file recovery parameter, Standby Server Settings
- trim, String Functions
and Operators, Binary String Functions and
Operators
- Tru64 UNIX
-
- shared library, Compiling and Linking
Dynamically-loaded Functions
- true, Boolean
Type
- trunc, Mathematical
Functions and Operators, Network Address Functions and
Operators
- TRUNCATE, TRUNCATE
- trusted
-
- PL/Perl, Trusted and
Untrusted PL/Perl
- tsearch2, tsearch2
- tsquery (data type), tsquery
- tsvector (data type), tsvector
- tsvector concatenation, Manipulating
Documents
- tsvector_update_trigger, Text Search Functions and
Operators
- tsvector_update_trigger_column, Text Search Functions and
Operators
- ts_debug, Text Search
Functions and Operators, Configuration
Testing
- ts_headline, Text
Search Functions and Operators, Highlighting
Results
- ts_lexize, Text
Search Functions and Operators, Dictionary
Testing
- ts_parse, Text Search
Functions and Operators, Parser
Testing
- ts_rank, Text Search
Functions and Operators, Ranking Search
Results
- ts_rank_cd, Text
Search Functions and Operators, Ranking Search
Results
- ts_rewrite, Text
Search Functions and Operators, Query
Rewriting
- ts_stat, Text Search
Functions and Operators, Gathering
Document Statistics
- ts_token_type, Text
Search Functions and Operators, Parser
Testing
- txid_current, System
Information Functions
- txid_current_snapshot, System Information Functions
- txid_snapshot_xip, System
Information Functions
- txid_snapshot_xmax, System
Information Functions
- txid_snapshot_xmin, System
Information Functions
- txid_visible_in_snapshot, System Information Functions
- type
-
- see data type
- polymorphic, Polymorphic
Types
- type cast, Numeric Constants,
Type
Casts
- UESCAPE, Identifiers
and Key Words, String
Constants with Unicode Escapes
- unaccent, unaccent, Functions
- Unicode escape
-
- in identifiers, Identifiers
and Key Words
- in string constants, String
Constants with Unicode Escapes
- UNION, Combining
Queries
-
- determination of result type, UNION, CASE, and Related
Constructs
- unique constraint, Unique Constraints
- Unix domain socket, Database
Connection Control Functions
- UnixWare
-
- installation on,
SCO OpenServer and SCO UnixWare
- IPC configuration, Shared Memory and
Semaphores
- shared library, Compiling and Linking
Dynamically-loaded Functions
- unix_socket_directory configuration parameter,
Connection Settings
- unix_socket_group configuration parameter,
Connection Settings
- unix_socket_permissions configuration parameter,
Connection Settings
- UNLISTEN, UNLISTEN
- unnest, Array Functions
and Operators
- unqualified name, The Schema Search
Path
- UPDATE, Updates,
Updating Data, UPDATE
- update_process_title configuration parameter,
Query and Index Statistics Collector
- updating, Updating
Data
- upgrading, Upgrading a
PostgreSQL Cluster
- upper, String Functions
and Operators
-
- and locales, Behavior
- user, System Information
Functions, Database
Roles
-
- current, System
Information Functions
- user mapping, Foreign
Data
- User name maps, User
Name Maps
- UUID, UUID Type,
Installation
Procedure
- uuid-ossp, uuid-ossp
- vacuum, Routine
Vacuuming, VACUUM
- vacuumdb, vacuumdb
- vacuumlo, vacuumlo
- vacuum_cost_delay configuration parameter,
Cost-based Vacuum Delay
- vacuum_cost_limit configuration parameter,
Cost-based Vacuum Delay
- vacuum_cost_page_dirty configuration parameter,
Cost-based Vacuum Delay
- vacuum_cost_page_hit configuration parameter,
Cost-based Vacuum Delay
- vacuum_cost_page_miss configuration parameter,
Cost-based Vacuum Delay
- vacuum_defer_cleanup_age configuration parameter,
Master Server
- vacuum_freeze_min_age configuration parameter, Statement
Behavior
- vacuum_freeze_table_age configuration parameter, Statement
Behavior
- value expression, Value
Expressions
- VALUES, VALUES Lists,
VALUES
-
- determination of result type, UNION, CASE, and Related
Constructs
- varchar, Character
Types
- variadic function, SQL Functions
with Variable Numbers of Arguments
- variance, Aggregate
Functions
-
- population, Aggregate Functions
- sample, Aggregate
Functions
- var_pop, Aggregate
Functions
- var_samp, Aggregate
Functions
- version, Accessing a
Database, System
Information Functions
-
- compatibility, Upgrading a
PostgreSQL Cluster
- view, Views
-
- implementation through rules, Views and the Rule System
- updating, Cooperation with
Views
- Visibility Map, Visibility
Map
- VM
-
- see Visibility Map
- void, Pseudo-Types
- VOLATILE, Function
Volatility Categories
- volatility
-
- functions, Function
Volatility Categories
- VPATH, Installation
Procedure
- WAL, Reliability and the Write-Ahead
Log
- wal_block_size configuration parameter, Preset Options
- wal_buffers configuration parameter, Settings
- wal_debug configuration parameter, Developer Options
- wal_keep_segments configuration parameter,
Master Server
- wal_level configuration parameter, Settings
- wal_receiver_status_interval configuration parameter,
Standby Servers
- wal_segment_size configuration parameter, Preset Options
- wal_sender_delay configuration parameter,
Master Server
- wal_sync_method configuration parameter, Settings
- wal_writer_delay configuration parameter, Settings
- warm standby, High
Availability, Load Balancing, and Replication
- WHERE, The WHERE
Clause
- where to log, Where
To Log
- WHILE
-
- in PL/pgSQL, WHILE
- width, Geometric
Functions and Operators
- width_bucket, Mathematical
Functions and Operators
- window function, Window
Functions
-
- built-in, Window
Functions
- invocation, Window
Function Calls
- order of execution, Window
Function Processing
- WITH
-
- in SELECT, WITH Queries
(Common Table Expressions), SELECT
- witness server, High
Availability, Load Balancing, and Replication
- work_mem configuration parameter,
Memory
- xid, Object Identifier
Types
- xmax, System
Columns
- xmin, System
Columns
- XML, XML Type
- XML export, Mapping Tables to
XML
- XML option, Creating
XML Values, Statement
Behavior
- xml2, xml2
- xmlagg, xmlagg,
Aggregate
Functions
- xmlbinary configuration parameter, Statement
Behavior
- xmlcomment, xmlcomment
- xmlconcat, xmlconcat
- xmlelement, xmlelement
- XMLEXISTS, XMLEXISTS
- xmlforest, xmlforest
- xmloption configuration parameter, Statement
Behavior
- xmlparse, Creating
XML Values
- xmlpi, xmlpi
- xmlroot, xmlroot
- xmlserialize, Creating XML Values
- xml_is_well_formed, xml_is_well_formed
- xml_is_well_formed_content, xml_is_well_formed
- xml_is_well_formed_document, xml_is_well_formed
- XPath, Processing
XML
- xpath_exists, Processing
XML