This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
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 system mount points, Use of
Secondary File Systems
- 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, Use of 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_file_rename, adminpack
- pg_file_unlink, adminpack
- pg_file_write, adminpack
- 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_logdir_ls, adminpack
- 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_ident 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