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
Symbols
- $,Positional Parameters
- $libdir,Dynamic Loading
- $libdir/plugins,Shared Library Preloading,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
- _PG_output_plugin_init,Logical Decoding
- $libdir,Dynamic Loading
A
- abbrev,Network Address Functions and Operators
- ABORT,ABORT
- abs,Mathematical Functions and Operators
- acos,Mathematical Functions and Operators
- administration tools
- ABORT,ABORT
- externally maintained,Administration Tools
- adminpack,adminpack
- advisory lock,Advisory Locks
- age,Date/Time Functions and Operators
- aggregate function,Aggregate Functions
- advisory lock,Advisory Locks
- built-in,Aggregate Functions
- invocation,Aggregate Expressions
- moving aggregate,Moving-Aggregate Mode
- ordered set,Ordered-Set Aggregates
- polymorphic,Polymorphic and Variadic Aggregates
- support functions for,Support Functions for Aggregates
- user-defined,User-defined Aggregates
- variadic,Polymorphic and Variadic Aggregates
- AIX
- installation on,AIX
- IPC configuration,Shared Memory and Semaphores
- akeys,hstore Operators and Functions
- 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 EVENT TRIGGER,ALTER EVENT TRIGGER
- 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 MATERIALIZED VIEW,ALTER MATERIALIZED VIEW
- ALTER OPERATOR,ALTER OPERATOR
- ALTER OPERATOR CLASS,ALTER OPERATOR CLASS
- ALTER OPERATOR FAMILY,ALTER OPERATOR FAMILY
- ALTER ROLE,Role Attributes,ALTER ROLE
- ALTER RULE,ALTER RULE
- ALTER SCHEMA,ALTER SCHEMA
- ALTER SEQUENCE,ALTER SEQUENCE
- ALTER SERVER,ALTER SERVER
- ALTER SYSTEM,ALTER SYSTEM
- 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
- anyrange,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
- armor,armor(), dearmor()
- ARRAY,Array Constructors,Arrays
- allow_system_table_mods configuration parameter,Developer Options
- 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,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_remove,Array Functions and Operators
- array_replace,Array Functions and Operators
- array_to_json,JSON 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
- array_append,Array Functions and Operators
- 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_multixact_freeze_max_age 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
- autovacuum_work_mem configuration parameter,Memory
- 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_timing configuration parameter,Configuration Parameters
- auto_explain.log_triggers configuration parameter,Configuration Parameters
- auto_explain.log_verbose configuration parameter,Configuration Parameters
- avals,hstore Operators and Functions
- average,Aggregate Functions
- avg,Aggregate Functions
- autovacuum_analyze_scale_factor configuration parameter,Automatic Vacuuming
B
- B-tree
- see index
- Background workers,Background Worker Processes
- backslash escapes,String Constants with C-style Escapes
- backslash_quote configuration parameter,Previous PostgreSQL Versions
- backup,Backup Control Functions,Backup and Restore
- base type,The PostgreSQL Type System
- BASE_BACKUP,Streaming Replication Protocol
- 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
- backslash escapes,String Constants with C-style Escapes
- 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
- bit_and,Aggregate Functions
- see large object
- block_size configuration parameter,Preset Options
- bonjour configuration parameter,Connection Settings
- bonjour_name configuration parameter,Connection Settings
- Boolean
- bonjour configuration parameter,Connection Settings
- data type,Boolean Type
- operators
- see operators, logical
- bool_and,Aggregate Functions
- bool_or,Aggregate Functions
- booting
- bool_or,Aggregate Functions
- starting the server during,Starting the Database Server
- box,Geometric Functions and Operators
- box (data type),Boxes
- broadcast,Network Address Functions and Operators
- btree_gin,btree_gin
- btree_gist,btree_gist
- btrim,String Functions and Operators,Binary String Functions and Operators
- bt_metap,Functions
- bt_page_items,Functions
- bt_page_stats,Functions
- bytea,Binary Data Types
- bytea_output configuration parameter,Statement Behavior
- box (data type),Boxes
C
- C,libpq - C Library,ECPG - Embedded SQL in C
- C++,Using C++ for Extensibility
- canceling
- C++,Using C++ for Extensibility
- SQL command,Canceling Queries in Progress
- cardinality,Array Functions and Operators
- CASCADE
- with DROP,Dependency Tracking
- foreign key action,Foreign Keys
- Cascading Replication,High Availability, Load Balancing, and Replication
- 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
- ceil,Mathematical Functions and Operators
- 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
- CHECK OPTION,CREATE VIEW
- 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
- char_length,String Functions and Operators
- 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
- client_min_messages configuration parameter,When To Log
- 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
- clustering,High Availability, Load Balancing, and Replication
- in PL/pgSQL,Collation of PL/pgSQL Variables
- in SQL functions,SQL Functions with Collations
- collation for,System Information Functions
- 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
- col_description,System Information Functions
- 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
- COMMIT PREPARED,COMMIT PREPARED
- see WITH
- comparison
- composite type,Row and Array Comparisons
- operators,Comparison Operators
- row constructor,Row and Array Comparisons
- subquery result row,Subquery Expressions
- compiling
- libpq applications,Building libpq Programs
- composite type,Composite Types,The PostgreSQL Type System
- comparison,Row and Array Comparisons
- 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
- concat,String Functions and Operators
- of recovery
- of a standby server,Recovery Configuration
- of the server,Server Configuration
- of the server
- functions,Configuration Settings Functions
- configure,Installation Procedure
- config_file configuration parameter,File Locations
- conjunction,Logical Operators
- connectby,Functions Provided,connectby
- connection service file,The Connection Service File
- conninfo,Connection Strings
- constant,Constants
- constraint,Constraints
- config_file configuration parameter,File Locations
- 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
- constraint_exclusion configuration parameter,Other Planner Options
- 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
- control file,Extension Files
- 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
- correlation,Aggregate Functions
- 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 EVENT TRIGGER,CREATE EVENT TRIGGER
- 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 MATERIALIZED VIEW,CREATE MATERIALIZED VIEW
- 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
- CREATE_REPLICATION_SLOT,Streaming Replication Protocol
- cross compilation,Installation Procedure
- cross join,Joined Tables
- crosstab,crosstab(text),crosstabN(text),crosstab(text, text)
- crypt,crypt()
- cstring,Pseudo-Types
- ctid,System Columns,View Rules in Non-SELECT Statements
- cube,cube
- cume_dist,Window Functions
- covar_samp,Aggregate Functions
- hypothetical,Aggregate 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,Configuration Settings 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
- current_database,System Information Functions
- cursor_tuple_fraction configuration parameter,Other Planner Options
- Cygwin
- installation on,Cygwin
D
- data area
- see database cluster
- data partitioning,High Availability, Load Balancing, and Replication
- data type,Data Types
- base,The PostgreSQL Type System
- category,Overview
- composite,The PostgreSQL Type System
- constant,Constants of Other Types
- conversion,Type Conversion
- enumerated (enum),Enumerated Types
- internal organization,Base Types in C-Language Functions
- numeric,Numeric Types
- type cast,Type Casts
- user-defined,User-defined Types
- database,Managing Databases
- creating,Creating a Database
- privilege to create,Role Attributes
- database activity
- monitoring,Monitoring Database Activity
- database cluster,Concepts,Creating a Database Cluster
- data_checksums configuration parameter,Preset Options
- data_directory configuration parameter,File Locations
- date,Date/Time Types,Dates
- data_checksums configuration parameter,Preset Options
- 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,dblink
- dblink_build_sql_delete,dblink_build_sql_delete
- dblink_build_sql_insert,dblink_build_sql_insert
- dblink_build_sql_update,dblink_build_sql_update
- dblink_cancel_query,dblink_cancel_query
- dblink_close,dblink_close
- dblink_connect,dblink_connect
- dblink_connect_u,dblink_connect_u
- dblink_disconnect,dblink_disconnect
- dblink_error_message,dblink_error_message
- dblink_exec,dblink_exec
- dblink_fetch,dblink_fetch
- dblink_get_connections,dblink_get_connections
- dblink_get_notify,dblink_get_notify
- dblink_get_pkey,dblink_get_pkey
- dblink_get_result,dblink_get_result
- dblink_is_busy,dblink_is_busy
- dblink_open,dblink_open
- dblink_send_query,dblink_send_query
- db_user_namespace configuration parameter,Security and Authentication
- deadlock,Deadlocks
- date_part,Date/Time Functions and Operators,EXTRACT, date_part
- timeout during,Lock Management
- deadlock_timeout configuration parameter,Lock Management
- DEALLOCATE,DEALLOCATE
- dearmor,armor(), dearmor()
- 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
- DEALLOCATE,DEALLOCATE
- see numeric
- DECLARE,DECLARE
- decode,String Functions and Operators,Binary String Functions and Operators
- decode_bytea
- decode,String Functions and Operators,Binary String Functions and Operators
- in PL/Perl,Utility Functions in PL/Perl
- decrypt,Raw Encryption Functions
- decrypt_iv,Raw Encryption Functions
- default value,Default Values
- decrypt_iv,Raw Encryption Functions
- 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
- default_tablespace configuration parameter,Statement Behavior
- setting,SET TRANSACTION
- setting default,Statement Behavior
- defined,hstore Operators and Functions
- degrees,Mathematical Functions and Operators
- delay,Delaying Execution
- DELETE,Deletions,Deleting Data,DELETE,hstore Operators and Functions
- deleting,Deleting Data
- dense_rank,Window Functions
- degrees,Mathematical Functions and Operators
- hypothetical,Aggregate Functions
- diameter,Geometric Functions and Operators
- dict_int,dict_int
- dict_xsyn,dict_xsyn
- difference,Soundex
- digest,digest()
- Digital UNIX
- dict_int,dict_int
- 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
- dmetaphone,Double Metaphone
- dmetaphone_alt,Double Metaphone
- DO,DO
- document
- DISCARD,DISCARD
- 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 EVENT TRIGGER,DROP EVENT TRIGGER
- 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 MATERIALIZED VIEW,DROP MATERIALIZED VIEW
- 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
- DROP_REPLICATION_SLOT,Streaming Replication Protocol
- 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
- dynamic_shared_memory_type configuration parameter,Memory
- double precision,Floating-Point Types
E
- each,hstore Operators and Functions
- earth,Cube-based Earth Distances
- earthdistance,earthdistance
- earth_box,Cube-based Earth Distances
- earth_distance,Cube-based Earth Distances
- 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
- earth,Cube-based Earth Distances
- in PL/Perl,Utility Functions in PL/Perl
- in PL/Python,Utility Functions
- in PL/Tcl,Database Access from PL/Tcl
- embedded SQL
- 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_indexonlyscan 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
- enable_bitmapscan configuration parameter,Planner Method Configuration
- 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
- encrypt,Raw Encryption Functions
- encryption,Encryption Options
- for specific columns,pgcrypto
- encrypt_iv,Raw Encryption Functions
- 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
- END,END
- 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
- escape string syntax,String Constants with C-style Escapes
- event log
- event log,Registering Event Log on Windows
- event trigger,Event Triggers
- event_source configuration parameter,Where To Log
- every,Aggregate Functions
- EXCEPT,Combining Queries
- exceptions
- every,Aggregate Functions
- in PL/pgSQL,Trapping Errors
- exclusion constraint,Exclusion Constraints
- EXECUTE,EXECUTE
- exist,hstore Operators and Functions
- EXISTS,Subquery Expressions
- EXIT
- EXECUTE,EXECUTE
- in PL/pgSQL,EXIT
- exit_on_error configuration parameter,Error Handling
- exp,Mathematical Functions and Operators
- EXPLAIN,Using EXPLAIN,EXPLAIN
- expression
- exp,Mathematical Functions and Operators
- 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
- extract,Date/Time Functions and Operators,EXTRACT, date_part
F
- 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
- false,Boolean Type
- computed,SQL Functions on Composite Types
- field selection,Field Selection
- file_fdw,file_fdw
- FILTER,Aggregate Expressions
- first_value,Window Functions
- flex,Requirements
- float4
- file_fdw,file_fdw
- 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
- foreign data,Foreign Data
- handler for,Writing A Foreign Data Wrapper
- foreign key,Foreign Keys,Foreign Keys
- foreign table,Foreign Data
- format,String Functions and Operators,format
- foreign table,Foreign Data
- use in PL/pgSQL,Executing Dynamic Commands
- formatting,Data Type Formatting Functions
- format_type,System Information Functions
- Free Space Map,Free Space Map
- FreeBSD
- format_type,System Information Functions
- 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
- fsm_page_contents,Functions
- fsync configuration parameter,Settings
- full text search,Full Text Search
- fsync configuration parameter,Settings
- 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 argument,Arguments for SQL Functions
- named notation,Using Named Notation
- 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
- variadic,SQL Functions with Variable Numbers of Arguments
- with SETOF,SQL Functions Returning Sets
- functional dependency,The GROUP BY and HAVING Clauses
- fuzzystrmatch,fuzzystrmatch
G
- gc_to_sec,Cube-based Earth Distances
- generate_series,Set Returning Functions
- generate_subscripts,Set Returning Functions
- genetic query optimization,Genetic Query Optimizer
- gen_random_bytes,Random-Data Functions
- gen_random_uuid,Random-Data Functions
- gen_salt,gen_salt()
- GEQO
- generate_series,Set Returning Functions
- 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
- get_raw_page,Functions
- GIN
- geqo_effort configuration parameter,Genetic Query Optimizer
- 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
- Gregorian calendar,History of Units
- GROUP BY,Aggregate Functions,The GROUP BY and HAVING Clauses
- grouping,The GROUP BY and HAVING Clauses
- GSSAPI,GSSAPI Authentication
- GUID,UUID Type
- GROUP BY,Aggregate Functions,The GROUP BY and HAVING Clauses
H
- hash
- see index
- has_any_column_privilege,System Information Functions
- has_column_privilege,System Information Functions
- has_database_privilege,System Information Functions
- has_foreign_data_wrapper_privilege,System Information Functions
- has_function_privilege,System Information Functions
- has_language_privilege,System Information Functions
- has_schema_privilege,System Information Functions
- has_sequence_privilege,System Information Functions
- has_server_privilege,System Information Functions
- has_tablespace_privilege,System Information Functions
- has_table_privilege,System Information Functions
- HAVING,Aggregate Functions,The GROUP BY and HAVING Clauses
- hba_file configuration parameter,File Locations
- heap_page_items,Functions
- height,Geometric Functions and Operators
- hierarchical database,Concepts
- high availability,High Availability, Load Balancing, and Replication
- history
- has_column_privilege,System Information Functions
- of PostgreSQL,A Brief History of PostgreSQL
- hmac,hmac()
- host,Network Address Functions and Operators
- host name,Parameter Key Words
- 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
- host,Network Address Functions and Operators
- installation on,HP-UX
- IPC configuration,Shared Memory and Semaphores
- shared library,Compiling and Linking Dynamically-loaded Functions
- hstore,hstore,hstore Operators and Functions
- hstore_to_array,hstore Operators and Functions
- hstore_to_json,hstore Operators and Functions
- hstore_to_json_loose,hstore Operators and Functions
- hstore_to_matrix,hstore Operators and Functions
- huge_pages configuration parameter,Memory
- hypothetical-set aggregate
- hstore_to_array,hstore Operators and Functions
- built-in,Aggregate Functions
I
- icount,intarray Functions and Operators
- ident,Ident Authentication
- identifier
- ident,Ident Authentication
- length,Identifiers and Key Words
- syntax of,Identifiers and Key Words
- IDENTIFY_SYSTEM,Streaming Replication Protocol
- ident_file configuration parameter,File Locations
- idx,intarray Functions and Operators
- IFNULL,COALESCE
- ignore_checksum_failure configuration parameter,Developer Options
- ignore_system_indexes configuration parameter,Developer Options
- IMMUTABLE,Function Volatility Categories
- IN,Subquery Expressions,Row and Array Comparisons
- include
- ident_file configuration parameter,File Locations
- in configuration file,Managing Configuration File Contents
- include_dir
- in configuration file,Managing Configuration File Contents
- include_if_exists
- in configuration file,Managing Configuration File Contents
- index,Indexes,Operators and Functions
- 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
- SP-GiST,Index Types,SP-GiST Indexes
- unique,Unique Indexes
- index scan,Planner Method Configuration
- index-only 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
- index-only scan,Planner Method Configuration
- 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
- intarray,intarray
- externally maintained,Client Interfaces
- internal,Pseudo-Types
- INTERSECT,Combining Queries
- interval,Date/Time Types,Interval Input
- INTERSECT,Combining Queries
- output format,Interval Output
- see also formatting
- IntervalStyle configuration parameter,Locale and Formatting
- intset,intarray Functions and Operators
- int_array_aggregate,Functions
- int_array_enum,Functions
- inverse distribution,Aggregate 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
- isempty,Range Functions and Operators
- isfinite,Date/Time Functions and Operators
- isn,isn
- ISNULL,Comparison Operators
- isn_weak,Functions and Operators
- isopen,Geometric Functions and Operators
- is_array_ref
- intset,intarray Functions and Operators
- in PL/Perl,Utility Functions in PL/Perl
- is_valid,Functions and Operators
J
- join,Joins Between Tables,Joined Tables
- controlling the order,Controlling the Planner with Explicit JOIN Clauses
- cross,Joined Tables
- left,Joined Tables
- natural,Joined Tables
- outer,Joins Between Tables,Joined Tables
- right,Joined Tables
- self,Joins Between Tables
- join_collapse_limit configuration parameter,Other Planner Options
- JSON,JSON Types
- functions and operators,JSON Functions and Operators
- JSONB,JSON Types
- containment,jsonb Containment and Existence
- existence,jsonb Containment and Existence
- indexes on,jsonb Indexing
- jsonb_array_elements,JSON Functions and Operators
- jsonb_array_elements_text,JSON Functions and Operators
- jsonb_array_length,JSON Functions and Operators
- jsonb_each,JSON Functions and Operators
- jsonb_each_text,JSON Functions and Operators
- jsonb_extract_path,JSON Functions and Operators
- jsonb_extract_path_text,JSON Functions and Operators
- jsonb_object_keys,JSON Functions and Operators
- jsonb_populate_record,JSON Functions and Operators
- jsonb_populate_recordset,JSON Functions and Operators
- jsonb_to_record,JSON Functions and Operators
- jsonb_to_recordset,JSON Functions and Operators
- jsonb_typeof,JSON Functions and Operators
- json_agg,Aggregate Functions
- json_array_elements,JSON Functions and Operators
- json_array_elements_text,JSON Functions and Operators
- json_array_length,JSON Functions and Operators
- json_build_array,JSON Functions and Operators
- json_build_object,JSON Functions and Operators
- json_each,JSON Functions and Operators
- json_each_text,JSON Functions and Operators
- json_extract_path,JSON Functions and Operators
- json_extract_path_text,JSON Functions and Operators
- json_object,JSON Functions and Operators
- json_object_agg,Aggregate Functions
- json_object_keys,JSON Functions and Operators
- json_populate_record,JSON Functions and Operators
- json_populate_recordset,JSON Functions and Operators
- json_to_record,JSON Functions and Operators
- json_to_recordset,JSON Functions and Operators
- json_typeof,JSON Functions and Operators
- Julian date,History of Units
- justify_days,Date/Time Functions and Operators
- justify_hours,Date/Time Functions and Operators
- justify_interval,Date/Time Functions and Operators
- jsonb_array_elements_text,JSON Functions and Operators
K
- key word
- list of,SQL Key Words
- syntax of,Identifiers and Key Words
- krb_caseins_users configuration parameter,Security and Authentication
- krb_server_keyfile configuration parameter,Security and Authentication
L
- label
- see alias
- lag,Window Functions
- language_handler,Pseudo-Types
- large object,Large Objects
- lastval,Sequence Manipulation Functions
- last_value,Window Functions
- LATERAL
- language_handler,Pseudo-Types
- in the FROM clause,LATERAL Subqueries
- latitude,Cube-based Earth Distances
- lca,Operators and 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
- lca,Operators and Functions
- 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
- left join,Joined Tables
- of a binary string
- see binary strings, length
- of a character string
- see character string, length
- length(tsvector),Manipulating Documents
- levenshtein,Levenshtein
- levenshtein_less_equal,Levenshtein
- lex,Requirements
- libedit,Requirements
- libperl,Requirements
- libpq,libpq - C Library
- levenshtein,Levenshtein
- single-row mode,Retrieving Query Results Row-By-Row
- 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
- libpq-int.h,Connection Status Functions
- and locales,Behavior
- LIMIT,LIMIT and OFFSET
- line,Lines
- line segment,Line Segments
- linear regression,Aggregate Functions
- Linux
- line,Lines
- 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
- ll_to_earth,Cube-based Earth Distances
- 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,Shared Library Preloading
- lock,Explicit Locking,Table-level Locks,LOCK
- listen_addresses configuration parameter,Connection Settings
- advisory,Advisory Locks
- monitoring,Viewing Locks
- lock_timeout configuration parameter,Statement Behavior
- log,Mathematical Functions and Operators
- log shipping,High Availability, Load Balancing, and Replication
- logging_collector configuration parameter,Where To Log
- Logical Decoding,Logical Decoding,Logical Decoding
- 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
- longitude,Cube-based Earth Distances
- looks_like_number
- log,Mathematical Functions and Operators
- in PL/Perl,Utility Functions in PL/Perl
- loop
- in PL/pgSQL,Simple Loops
- lower,String Functions and Operators,Range Functions and Operators
- and locales,Behavior
- lower_inc,Range Functions and Operators
- lower_inf,Range Functions and Operators
- 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
- lo_export,Exporting a Large Object,Server-side Functions
- lo_from_bytea,Server-side Functions
- lo_get,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_lseek64,Seeking in a Large Object
- lo_open,Opening an Existing Large Object
- lo_put,Server-side Functions
- lo_read,Reading Data from a Large Object
- lo_tell,Obtaining the Seek Position of a Large Object
- lo_tell64,Obtaining the Seek Position of a Large Object
- lo_truncate,Truncating a Large Object
- lo_truncate64,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
- ltree2text,Operators and Functions
- ltrim,String Functions and Operators
- lower_inf,Range Functions and Operators
M
- MAC address
- see macaddr
- macaddr (data type),macaddr
- magic block,Dynamic Loading
- maintenance,Routine Database Maintenance Tasks
- maintenance_work_mem configuration parameter,Memory
- make,Requirements
- make_date,Date/Time Functions and Operators
- make_interval,Date/Time Functions and Operators
- make_time,Date/Time Functions and Operators
- make_timestamp,Date/Time Functions and Operators
- make_timestamptz,Date/Time Functions and Operators
- make_valid,Functions and Operators
- MANPATH,Environment Variables
- masklen,Network Address Functions and Operators
- materialized view
- magic block,Dynamic Loading
- implementation through rules,Materialized Views
- materialized views,pg_matviews
- 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_replication_slots configuration parameter,Sending Server(s)
- 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,Sending Server(s)
- max_worker_processes configuration parameter,Asynchronous Behavior
- md5,String Functions and Operators,Binary String Functions and Operators,Password Authentication
- median,Aggregate Functions
- memory context
- max,Aggregate Functions
- in SPI,Memory Management
- metaphone,Metaphone
- min,Aggregate Functions
- MinGW
- min,Aggregate Functions
- installation on,MinGW/Native Windows
- mod,Mathematical Functions and Operators
- mode
- statistical,Aggregate Functions
- monitoring
- database activity,Monitoring Database Activity
- MOVE,MOVE
- moving-aggregate mode,Moving-Aggregate Mode
- Multiversion Concurrency Control,Introduction
- MultiXactId,Multixacts and Wraparound
- MVCC,Introduction
- moving-aggregate mode,Moving-Aggregate Mode
N
- 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
- negation,Logical Operators
- 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
- nextval,Sequence Manipulation Functions
- see Network File Systems
- nlevel,Operators and Functions
- non-durable,Non-Durable Settings
- nonblocking connection,Database Connection Control Functions,Asynchronous Command Processing
- nonrepeatable read,Transaction Isolation
- normal_rand,normal_rand
- NOT (operator),Logical Operators
- not a number
- non-durable,Non-Durable Settings
- 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
- not-null constraint,Not-Null Constraints
- functions,Calling Functions
- notice processing
- in libpq,Notice Processing
- notice processor,Notice Processing
- notice receiver,Notice Processing
- NOTIFY,NOTIFY
- notice receiver,Notice Processing
- 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
- now,Date/Time Functions and Operators
- 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
- numeric (data type),Arbitrary Precision Numbers
O
- 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
- obj_description,System Information Functions
- column,System Columns
- in libpq,Retrieving Other Result Information
- oid2name,oid2name
- ONLY,The FROM Clause
- opaque,Pseudo-Types
- OpenBSD
- ONLY,The FROM Clause
- 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
- operator family,Operator Classes and Operator Families,Operator Classes and Operator Families
- porting from PL/SQL to PL/pgSQL,Porting from Oracle PL/SQL
- ORDER BY,Querying a Table,Sorting Rows
- and locales,Behavior
- ordered-set aggregate,Aggregate Expressions
- built-in,Aggregate Functions
- ordering operator,System Dependencies on Operator Classes
- ordinality,Set Returning Functions
- OS X
- ordinality,Set Returning Functions
- IPC configuration,Shared Memory and Semaphores
- shared library,Compiling and Linking Dynamically-loaded Functions
- outer join,Joined Tables
- output function,User-defined Types
- OVER clause,Window Function Calls
- OVERLAPS,Date/Time Functions and Operators
- overlay,String Functions and Operators,Binary String Functions and Operators
- overloading
- output function,User-defined Types
- functions,Function Overloading
- operators,User-defined Operators
- owner,Privileges
P
- pageinspect,pageinspect
- page_header,Functions
- palloc,Writing Code
- PAM,Installation Procedure,PAM Authentication
- parameter
- page_header,Functions
- syntax,Positional Parameters
- parenthesis,Value Expressions
- partitioning,Partitioning
- password,Role Attributes
- partitioning,Partitioning
- 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
- passwordcheck,passwordcheck
- for schemas,Statement Behavior
- path (data type),Paths
- pattern matching,Pattern Matching
- patterns
- pattern matching,Pattern Matching
- in psql and pg_dump,Patterns
- pause_at_recovery_target recovery parameter,Recovery Target Settings
- pclose,Geometric Functions and Operators
- peer,Peer Authentication
- percentile
- pclose,Geometric Functions and Operators
- continuous,Aggregate Functions
- discrete,Aggregate Functions
- percent_rank,Window Functions
- hypothetical,Aggregate Functions
- performance,Performance Tips
- perl,Requirements,PL/Perl - Perl Procedural Language
- permission
- perl,Requirements,PL/Perl - Perl Procedural Language
- 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
- pgp_key_id,pgp_key_id()
- pgp_pub_decrypt,pgp_pub_decrypt()
- pgp_pub_decrypt_bytea,pgp_pub_decrypt()
- pgp_pub_encrypt,pgp_pub_encrypt()
- pgp_pub_encrypt_bytea,pgp_pub_encrypt()
- pgp_sym_decrypt,pgp_sym_decrypt()
- pgp_sym_decrypt_bytea,pgp_sym_decrypt()
- pgp_sym_encrypt,pgp_sym_encrypt()
- pgp_sym_encrypt_bytea,pgp_sym_encrypt()
- PGREALM,Environment Variables
- PGREQUIREPEER,Environment Variables
- PGREQUIRESSL,Environment Variables
- PGresult,Main Functions
- pgrowlocks,pgrowlocks,Overview
- PGSERVICE,Environment Variables
- PGSERVICEFILE,Environment Variables
- PGSSLCERT,Environment Variables
- PGSSLCOMPRESSION,Environment Variables
- PGSSLCRL,Environment Variables
- PGSSLKEY,Environment Variables
- PGSSLMODE,Environment Variables
- PGSSLROOTCERT,Environment Variables
- pgstatginindex,Functions
- pgstatindex,Functions
- pgstattuple,pgstattuple,Functions
- PGSYSCONFDIR,Environment Variables
- PGTZ,Environment Variables
- PGUSER,Environment Variables
- pgxs,Extension Building Infrastructure
- pg_advisory_lock,Advisory Lock Functions
- pg_advisory_lock_shared,Advisory Lock Functions
- pg_advisory_unlock,Advisory Lock Functions
- pg_advisory_unlock_all,Advisory Lock Functions
- pg_advisory_unlock_shared,Advisory Lock Functions
- pg_advisory_xact_lock,Advisory Lock Functions
- pg_advisory_xact_lock_shared,Advisory Lock 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_backup_start_time,Backup Control Functions
- pg_basebackup,pg_basebackup
- pg_buffercache,pg_buffercache
- pg_buffercache_pages,pg_buffercache
- pg_cancel_backend,Server Signaling 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,Database Object Management Functions
- pg_config,pg_config
- PGAPPNAME,Environment Variables
- with ecpg,Processing Embedded SQL Programs
- 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_logical_replication_slot,Replication Functions
- pg_create_physical_replication_slot,Replication Functions
- pg_create_restore_point,Backup Control Functions
- pg_ctl,Creating a Database Cluster,Starting the Database Server,pg_ctl
- pg_current_xlog_insert_location,Backup Control Functions
- pg_current_xlog_location,Backup Control Functions
- pg_cursors,pg_cursors
- pg_database,Template Databases,pg_database
- pg_database_size,Database Object Management 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_drop_replication_slot,Replication Functions
- pg_dump,pg_dump
- pg_dumpall,pg_dumpall
- pg_constraint,pg_constraint
- use during upgrade,Upgrading Data via pg_dumpall
- pg_enum,pg_enum
- pg_event_trigger,pg_event_trigger
- pg_event_trigger_dropped_objects,Event Trigger Functions
- pg_export_snapshot,Snapshot Synchronization Functions
- pg_extension,pg_extension
- pg_extension_config_dump,Extension Configuration Tables
- pg_filenode_relation,Database Object Management Functions
- pg_foreign_data_wrapper,pg_foreign_data_wrapper
- pg_foreign_server,pg_foreign_server
- pg_foreign_table,pg_foreign_table
- pg_freespace,Functions
- 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_identify_object,System Information Functions
- pg_index,pg_index
- pg_indexes,pg_indexes
- pg_indexes_size,Database Object Management Functions
- pg_inherits,pg_inherits
- pg_isready,pg_isready
- pg_is_in_backup,Backup Control Functions
- pg_is_in_recovery,Recovery Control Functions
- pg_is_other_temp_schema,System Information Functions
- pg_is_xlog_replay_paused,Recovery Control Functions
- pg_language,pg_language
- pg_largeobject,pg_largeobject
- pg_largeobject_metadata,pg_largeobject_metadata
- pg_last_xact_replay_timestamp,Recovery Control Functions
- pg_last_xlog_receive_location,Recovery Control Functions
- pg_last_xlog_replay_location,Recovery Control Functions
- pg_listening_channels,System Information Functions
- pg_locks,pg_locks
- pg_logical_slot_get_binary_changes,Replication Functions
- pg_logical_slot_get_changes,Replication Functions
- pg_logical_slot_peek_binary_changes,Replication Functions
- pg_logical_slot_peek_changes,Replication Functions
- pg_lsn,pg_lsn Type
- pg_ls_dir,Generic File Access Functions
- pg_matviews,pg_matviews
- 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_opfamily_is_visible,System Information Functions
- 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_prewarm,pg_prewarm
- pg_proc,pg_proc
- pg_range,pg_range
- pg_read_binary_file,Generic File Access Functions
- pg_read_file,Generic File Access Functions
- pg_receivexlog,pg_receivexlog
- pg_recvlogical,pg_recvlogical
- pg_relation_filenode,Database Object Management Functions
- pg_relation_filepath,Database Object Management Functions
- pg_relation_size,Database Object Management Functions
- pg_reload_conf,Server Signaling Functions
- pg_relpages,Functions
- pg_replication_slots,pg_replication_slots
- pg_resetxlog,pg_resetxlog
- pg_restore,pg_restore
- pg_rewrite,pg_rewrite
- pg_roles,pg_roles
- pg_rotate_logfile,Server Signaling 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_shseclabel,pg_shseclabel
- pg_size_pretty,Database Object Management Functions
- pg_sleep,Delaying Execution
- pg_sleep_for,Delaying Execution
- pg_sleep_until,Delaying Execution
- pg_standby,pg_standby
- pg_start_backup,Backup Control 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_archiver,Viewing Collected Statistics
- pg_stat_bgwriter,Viewing Collected Statistics
- pg_stat_clear_snapshot,Statistics Functions
- pg_stat_database,Viewing Collected Statistics
- pg_stat_database_conflicts,Viewing Collected Statistics
- pg_stat_file,Generic File Access Functions
- pg_stat_get_activity,Statistics Functions
- pg_stat_replication,Viewing Collected Statistics
- pg_stat_reset,Statistics Functions
- pg_stat_reset_shared,Statistics Functions
- pg_stat_reset_single_function_counters,Statistics Functions
- pg_stat_reset_single_table_counters,Statistics Functions
- pg_stat_statements,pg_stat_statements
- pg_event_trigger,pg_event_trigger
- function,Functions
- pg_stat_statements_reset,Functions
- 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,Backup Control Functions
- pg_switch_xlog,Backup Control Functions
- pg_tables,pg_tables
- pg_tablespace,pg_tablespace
- pg_tablespace_databases,System Information Functions
- pg_tablespace_location,System Information Functions
- pg_tablespace_size,Database Object Management Functions
- pg_table_is_visible,System Information Functions
- pg_table_size,Database Object Management Functions
- pg_temp,Statement Behavior
- pg_stat_sys_indexes,Viewing Collected Statistics
- securing functions,Writing SECURITY DEFINER Functions Safely
- pg_terminate_backend,Server Signaling Functions
- pg_test_fsync,pg_test_fsync
- pg_test_timing,pg_test_timing
- pg_timezone_abbrevs,pg_timezone_abbrevs
- pg_timezone_names,pg_timezone_names
- pg_total_relation_size,Database Object Management Functions
- pg_trgm,pg_trgm
- pg_trigger,pg_trigger
- pg_try_advisory_lock,Advisory Lock Functions
- pg_try_advisory_lock_shared,Advisory Lock Functions
- pg_try_advisory_xact_lock,Advisory Lock Functions
- pg_try_advisory_xact_lock_shared,Advisory Lock 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_xlogdump,pg_xlogdump
- pg_xlogfile_name,Backup Control Functions
- pg_xlogfile_name_offset,Backup Control Functions
- pg_xlog_location_diff,Backup Control Functions
- pg_xlog_replay_pause,Recovery Control Functions
- pg_xlog_replay_resume,Recovery Control Functions
- phantom read,Transaction Isolation
- pi,Mathematical Functions and Operators
- PIC,Compiling and Linking Dynamically-loaded Functions
- PID
- pg_test_fsync,pg_test_fsync
- determining PID of server process
- in libpq,Connection Status Functions
- PITR,Backup and Restore
- PITR standby,High Availability, Load Balancing, and Replication
- pkg-config
- PITR standby,High Availability, Load Balancing, and Replication
- with ecpg,Processing Embedded SQL Programs
- with libpq,Building libpq Programs
- 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)
- PL/PerlU,Trusted and Untrusted PL/Perl
- 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
- populate_record,hstore Operators and Functions
- port,Parameter Key Words
- 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.auto.conf,Parameter Interaction via the Configuration File
- postgresql.conf,Parameter Interaction via the Configuration File
- postgres_fdw,postgres_fdw
- postmaster,postmaster
- post_auth_delay configuration parameter,Developer Options
- power,Mathematical Functions and Operators
- PQbackendPID,Connection Status Functions
- PQbinaryTuples,Retrieving Query Result Information
- plainto_tsquery,Text Search Functions and Operators,Parsing Queries
- 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
- PQconninfo,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
- PQclear,Main Functions
- 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
- PQfireResultCreateEvents,Miscellaneous Functions
- see also PQserverVersion
- PQmakeEmptyPGresult,Miscellaneous Functions
- PQnfields,Retrieving Query Result Information
- 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
- PQsetSingleRowMode,Retrieving Query Results Row-By-Row
- 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
- PQnparams,Retrieving Query Result Information
- 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
- primary_slot_name recovery parameter,Standby Server Settings
- privilege,Privileges
- primary key,Primary Keys
- 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
Q
- 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
- query,Querying a Table,Queries
- 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
R
- 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
- range type,Range Types
- radius,Geometric Functions and Operators,RADIUS Authentication
- exclude,Constraints on Ranges
- indexes on,Indexing
- rank,Window Functions
- hypothetical,Aggregate 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_min_apply_delay recovery parameter,Standby Server Settings
- recovery_target recovery parameter,Recovery Target 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
- REFRESH MATERIALIZED VIEW,REFRESH MATERIALIZED VIEW
- 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
- real,Floating-Point Types
- 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 slot
- reindexdb,reindexdb
- logical replication,Replication Slots
- streaming replication,Replication Slots
- 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
- restartpoint,WAL Configuration
- 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
- REVOKE,Privileges,REVOKE
- 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
- ROLLBACK TO SAVEPOINT,ROLLBACK TO SAVEPOINT
- planner,Row Estimation Examples
- row type,Composite Types
- constructor,Row Constructors
- row-wise comparison,Row and Array Comparisons
- row_number,Window Functions
- row_to_json,JSON Functions and Operators
- rpad,String Functions and Operators
- rtrim,String Functions and Operators
- rule,The Rule System
- row_number,Window Functions
- and materialized views,Materialized Views
- 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
S
- 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
- object visibility,System Information Functions
- search_path configuration parameter,The Schema Search Path,Statement Behavior
- use in securing functions,Writing SECURITY DEFINER Functions Safely
- SECURITY LABEL,SECURITY LABEL
- sec_to_gc,Cube-based Earth Distances
- seg,seg
- segment_size configuration parameter,Preset Options
- SELECT,Querying a Table,Queries,SELECT
- sec_to_gc,Cube-based Earth Distances
- 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
- sepgsql,sepgsql
- and serial type,Serial Types
- sequential scan,Planner Method Configuration
- seq_page_cost configuration parameter,Planner Cost Constants
- serial,Serial Types
- serial2,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
- seq_page_cost configuration parameter,Planner Cost Constants
- 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_preload_libraries configuration parameter,Shared Library Preloading
- session_replication_role configuration parameter,Statement Behavior
- session_user,System Information Functions
- SET,Configuration Settings Functions,SET
- SET CONSTRAINTS,SET CONSTRAINTS
- set difference,Combining Queries
- set intersection,Combining Queries
- set operation,Combining Queries
- set returning functions
- server_encoding configuration parameter,Preset Options
- 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,Configuration Settings Functions
- set_limit,Functions and Operators
- 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,Shared Library Preloading
- shobj_description,System Information Functions
- SHOW,Configuration Settings Functions,SHOW
- show_limit,Functions and Operators
- show_trgm,Functions and Operators
- shutdown,Shutting Down the Server
- SIGHUP,Parameter Interaction via the Configuration File,The pg_hba.conf File,User Name Maps
- SIGINT,Shutting Down the Server
- sign,Mathematical Functions and Operators
- signal
- SET SESSION AUTHORIZATION,SET SESSION AUTHORIZATION
- backend processes,Server Signaling Functions
- significant digits,Locale and Formatting
- SIGQUIT,Shutting Down the Server
- SIGTERM,Shutting Down the Server
- SIMILAR TO,SIMILAR TO Regular Expressions
- similarity,Functions and Operators
- sin,Mathematical Functions and Operators
- single-user mode,Options for Single-User Mode
- skeys,hstore Operators and Functions
- sleep,Delaying Execution
- slice,hstore Operators and Functions
- sliced bread
- SIGQUIT,Shutting Down the Server
- see TOAST
- smallint,Integer Types
- smallserial,Serial Types
- Solaris
- smallserial,Serial Types
- 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
- sort,intarray Functions and Operators
- sorting,Sorting Rows
- sort_asc,intarray Functions and Operators
- sort_desc,intarray Functions and Operators
- soundex,Soundex
- SP-GiST
- sort,intarray Functions and Operators
- see index
- SPI,Server Programming Interface
- examples,spi
- SPI_connect,SPI_connect
- SPI_copytuple,SPI_copytuple
- SPI_cursor_close,SPI_cursor_close
- SPI_copytuple,SPI_copytuple
- 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
- SPI_cursor_find,SPI_cursor_find
- 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
- SPI_fname,SPI_fname
- 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_keepplan,SPI_keepplan
- spi_lastoid
- SPI_freetuptable,SPI_freetuptable
- in PL/Tcl,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
- SPI_palloc,SPI_palloc
- 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
- SPI_prepare_params,SPI_prepare_params
- 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
- SPI_returntuple,SPI_returntuple
- with libpq,Parameter Key Words,Connection Status Functions
- ssl configuration parameter,Security and Authentication
- sslinfo,sslinfo
- ssl_ca_file configuration parameter,Security and Authentication
- ssl_cert_file configuration parameter,Security and Authentication
- ssl_cipher,Functions Provided
- ssl_ciphers configuration parameter,Security and Authentication
- ssl_client_cert_present,Functions Provided
- ssl_client_dn,Functions Provided
- ssl_client_dn_field,Functions Provided
- ssl_client_serial,Functions Provided
- ssl_crl_file configuration parameter,Security and Authentication
- ssl_ecdh_curve configuration parameter,Security and Authentication
- ssl_issuer_dn,Functions Provided
- ssl_issuer_field,Functions Provided
- ssl_is_used,Functions Provided
- ssl_key_file configuration parameter,Security and Authentication
- ssl_prefer_server_ciphers configuration parameter,Security and Authentication
- ssl_renegotiation_limit configuration parameter,Security and Authentication
- ssl_version,Functions Provided
- SSPI,SSPI Authentication
- STABLE,Function Volatility Categories
- standard deviation,Aggregate Functions
- sslinfo,sslinfo
- 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
- START_REPLICATION,Streaming Replication Protocol
- statement_timeout configuration parameter,Statement Behavior
- statement_timestamp,Date/Time Functions and Operators
- statistics,Aggregate Functions,The Statistics Collector
- standby server,High Availability, Load Balancing, and Replication
- 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
- stddev,Aggregate Functions
- 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
- subarray,intarray Functions and Operators
- subltree,Operators and Functions
- subpath,Operators and Functions
- 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
- svals,hstore Operators and 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
- string_to_array,Array Functions and Operators
- SQL,SQL Syntax
- syslog_facility configuration parameter,Where To Log
- syslog_ident configuration parameter,Where To Log
- system catalog
- syslog_ident configuration parameter,Where To Log
- schema,The System Catalog Schema
T
- 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
- table expression,Table Expressions
- default,Statement Behavior
- temporary,Statement Behavior
- tan,Mathematical Functions and Operators
- target list,The Query Tree
- Tcl,PL/Tcl - Tcl Procedural Language
- tcn,tcn
- 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_file_limit configuration parameter,Disk
- temp_tablespaces configuration parameter,Statement Behavior
- test,Regression Tests
- test_decoding,test_decoding
- test_parser,test_parser
- test_shm_mq,test_shm_mq
- text,Character Types,Network Address Functions and Operators
- text search,Full Text Search
- target list,The Query Tree
- data types,Text Search Types
- functions and operators,Text Search Types
- indexes,GiST and GIN Index Types
- text2ltree,Operators and Functions
- 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
- time with time zone,Date/Time Types,Times
- 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
- TIMELINE_HISTORY,Streaming Replication Protocol
- timeofday,Date/Time Functions and Operators
- timeout
- time zone names,Locale and Formatting
- 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
- timestamp with time zone,Date/Time Types,Time Stamps
- 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
- to_ascii,String Functions and Operators
- and locales,Behavior
- to_date,Data Type Formatting Functions
- to_hex,String Functions and Operators
- to_json,JSON Functions and Operators
- to_number,Data Type Formatting Functions
- to_regclass,System Information Functions
- to_regoper,System Information Functions
- to_regoperator,System Information Functions
- to_regproc,System Information Functions
- to_regprocedure,System Information Functions
- to_regtype,System Information 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
- track_io_timing configuration parameter,Query and Index Statistics Collector
- transaction,Transactions
- transaction ID
- to_hex,String Functions and Operators
- 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
- transform_null_equals configuration parameter,Platform and Client Compatibility
- 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
- triggered_change_notification,tcn
- trigger_file recovery parameter,Standby Server Settings
- trim,String Functions and Operators,Binary String Functions and Operators
- Tru64 UNIX
- trigger_file recovery parameter,Standby Server Settings
- shared library,Compiling and Linking Dynamically-loaded Functions
- true,Boolean Type
- trunc,Mathematical Functions and Operators,Network Address Functions and Operators
- TRUNCATE,TRUNCATE
- trusted
- trunc,Mathematical Functions and Operators,Network Address Functions and Operators
- 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
- tsquery (data type),tsquery
- see data type
- polymorphic,Polymorphic Types
- see data type
- type cast,Numeric Constants,Type Casts
U
- UESCAPE,Identifiers and Key Words,String Constants with Unicode Escapes
- unaccent,unaccent,Functions
- Unicode escape
- unaccent,unaccent,Functions
- 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
- uniq,intarray Functions and Operators
- unique constraint,Unique Constraints
- Unix domain socket,Parameter Key Words
- UnixWare
- unique constraint,Unique Constraints
- installation on,SCO OpenServer and SCO UnixWare
- IPC configuration,Shared Memory and Semaphores
- shared library,Compiling and Linking Dynamically-loaded Functions
- unix_socket_directories 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
- updatable views,Updatable Views
- 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,Range Functions and Operators
- unix_socket_group configuration parameter,Connection Settings
- and locales,Behavior
- upper_inc,Range Functions and Operators
- upper_inf,Range Functions and Operators
- URI,Connection Strings
- user,System Information Functions,Database Roles
- upper_inf,Range Functions and Operators
- current,System Information Functions
- user mapping,Foreign Data
- User name maps,User Name Maps
- UUID,UUID Type,Installation Procedure
- uuid-ossp,uuid-ossp
- uuid_generate_v1,uuid-ossp Functions
- uuid_generate_v1mc,uuid-ossp Functions
- uuid_generate_v3,uuid-ossp Functions
- User name maps,User Name Maps
V
- 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
- vacuum_multixact_freeze_min_age configuration parameter,Statement Behavior
- vacuum_multixact_freeze_table_age configuration parameter,Statement Behavior
- value expression,Value Expressions
- VALUES,VALUES Lists,VALUES
- vacuumdb,vacuumdb
- determination of result type,UNION, CASE, and Related Constructs
- varchar,Character Types
- variadic function,SQL Functions with Variable Numbers of Arguments
- variance,Aggregate Functions
- variadic function,SQL Functions with Variable Numbers of Arguments
- population,Aggregate Functions
- sample,Aggregate Functions
- var_pop,Aggregate Functions
- var_samp,Aggregate Functions
- version,Accessing a Database,System Information Functions
- var_samp,Aggregate Functions
- compatibility,Upgrading a PostgreSQL Cluster
- view,Views
- implementation through rules,Views and the Rule System
- materialized,Materialized Views
- updating,Cooperation with Views
- Visibility Map,Visibility Map
- VM
- see Visibility Map
- void,Pseudo-Types
- VOLATILE,Function Volatility Categories
- volatility
- VOLATILE,Function Volatility Categories
- functions,Function Volatility Categories
- VPATH,Installation Procedure,Extension Building Infrastructure
W
- 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,Sending Server(s)
- wal_level configuration parameter,Settings
- wal_log_hints configuration parameter,Settings
- wal_receiver_status_interval configuration parameter,Standby Servers
- wal_receiver_timeout configuration parameter,Standby Servers
- wal_segment_size configuration parameter,Preset Options
- wal_sender_timeout configuration parameter,Sending Server(s)
- 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
- wal_block_size configuration parameter,Preset Options
- in PL/pgSQL,WHILE
- width,Geometric Functions and Operators
- width_bucket,Mathematical Functions and Operators
- window function,Window Functions
- width_bucket,Mathematical Functions and Operators
- built-in,Window Functions
- invocation,Window Function Calls
- order of execution,Window Function Processing
- WITH
- WITH CHECK OPTION,CREATE VIEW
- WITHIN GROUP,Aggregate Expressions
- witness server,High Availability, Load Balancing, and Replication
- work_mem configuration parameter,Memory
- wraparound
- WITHIN GROUP,Aggregate Expressions
- of multixact IDs,Multixacts and Wraparound
- of transaction IDs,Preventing Transaction ID Wraparound Failures
X
- 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
- xpath_table,xpath_table
- xslt_process,xslt_process
- xmax,System Columns
Y
- yacc,Requirements
Z
- zero_damaged_pages configuration parameter,Developer Options
- zlib,Requirements,Installation Procedure