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 | 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_archive_module_init, Initialization Functions
- _PG_init, Dynamic Loading
- _PG_output_plugin_init, Initialization Function
- $libdir, Dynamic Loading
A
- abbrev, Network Address Functions and Operators
- ABORT, ABORT
- abs, Mathematical Functions and Operators
- ACL, Privileges
- aclcontains, Access Privilege Inquiry Functions
- acldefault, Access Privilege Inquiry Functions
- aclexplode, Access Privilege Inquiry Functions
- aclitem, Privileges
- aclitemeq, Access Privilege Inquiry Functions
- acos, Mathematical Functions and Operators
- acosd, Mathematical Functions and Operators
- acosh, Mathematical Functions and Operators
- administration tools
- ABORT, ABORT
- externally maintained, Administration Tools
- adminpack, adminpack — pgAdmin support toolpack
- advisory lock, Advisory Locks
- age, Date/Time Functions and Operators, Control Data Functions
- aggregate function, Aggregate Functions, Aggregate Expressions, Aggregate Functions, User-Defined Aggregates
- advisory lock, Advisory Locks
- built-in, Aggregate Functions
- invocation, Aggregate Expressions
- moving aggregate, Moving-Aggregate Mode
- ordered set, Ordered-Set Aggregates
- partial aggregation, Partial Aggregation
- polymorphic, Polymorphic and Variadic Aggregates
- support functions for, Support Functions for Aggregates
- user-defined, User-Defined Aggregates
- variadic, Polymorphic and Variadic Aggregates
- invocation, Aggregate Expressions
- built-in, Aggregate Functions
- AIX
- IPC configuration, Shared Memory and Semaphores
- akeys, hstore Operators and Functions
- alias, Table and Column Aliases, Column Labels
- for table name in query, Joins Between Tables
- in the FROM clause, Table and Column Aliases
- in the select list, Column Labels
- in the FROM clause, Table and Column Aliases
- for table name in query, Joins Between Tables
- ALL, GROUPING SETS, CUBE, and ROLLUP, DISTINCT, Subquery Expressions, Row and Array Comparisons
- GROUP BY ALL, GROUPING SETS, CUBE, and ROLLUP
- SELECT ALL, DISTINCT
- GROUP BY ALL, GROUPING SETS, CUBE, and ROLLUP
- allow_in_place_tablespaces configuration parameter, Developer Options
- 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 POLICY, ALTER POLICY
- ALTER PROCEDURE, ALTER PROCEDURE
- ALTER PROFILE, ALTER PROFILE
- ALTER PUBLICATION, ALTER PUBLICATION
- ALTER ROLE, Role Attributes, ALTER ROLE
- ALTER ROUTINE, ALTER ROUTINE
- ALTER RULE, ALTER RULE
- ALTER SCHEMA, ALTER SCHEMA
- ALTER SEQUENCE, ALTER SEQUENCE
- ALTER SERVER, ALTER SERVER
- ALTER STATISTICS, ALTER STATISTICS
- ALTER SUBSCRIPTION, ALTER SUBSCRIPTION
- 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
- amcheck, amcheck — tools to verify table and index consistency
- ANALYZE, Updating Planner Statistics, ANALYZE
- AND (operator), Logical Operators
- anonymous code blocks, DO
- any, Pseudo-Types
- ANY, Aggregate Functions, Subquery Expressions, Row and Array Comparisons
- anyarray, Pseudo-Types
- anyarray_elemtype, Functions
- anyarray_to_text, Functions
- anycompatible, Pseudo-Types
- anycompatiblearray, Pseudo-Types
- anycompatiblemultirange, Pseudo-Types
- anycompatiblenonarray, Pseudo-Types
- anycompatiblerange, Pseudo-Types
- anyelement, Pseudo-Types
- anyenum, Pseudo-Types
- anymultirange, Pseudo-Types
- anynonarray, Pseudo-Types
- anyrange, Pseudo-Types
- any_value, Aggregate Functions
- applicable role, applicable_roles
- application_name configuration parameter, What to Log
- aqo, aqo — cost-based query optimization
- arbitrary precision numbers, Arbitrary Precision Numbers
- Archive Modules, Archive Modules
- archive_cleanup_command configuration parameter, Archive Recovery
- archive_command configuration parameter, Archiving
- archive_library configuration parameter, Archiving
- archive_mode configuration parameter, Archiving
- archive_timeout configuration parameter, Archiving
- area, Geometric Functions and Operators
- armor, armor(), dearmor()
- array, Arrays
- allow_system_table_mods configuration parameter, Developer Options
- accessing, Accessing Arrays
- constant, Array Value Input
- constructor, Array Constructors
- declaration, Declaration of Array Types
- I/O, Array Input and Output Syntax
- modifying, Modifying Arrays
- of user-defined type, User-Defined Types
- searching, Searching in Arrays
- constant, Array Value Input
- accessing, Accessing Arrays
- ARRAY, Array Constructors, UNION, CASE, and Related Constructs
- determination of result type, UNION, CASE, and Related Constructs
- 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 Postgres Pro Versions
- array_position, Array Functions and Operators
- array_positions, Array Functions and Operators
- array_prepend, Array Functions and Operators
- array_remove, Array Functions and Operators
- array_replace, Array Functions and Operators
- array_sample, Array Functions and Operators
- array_shuffle, Array Functions and Operators
- array_to_json, Processing and Creating JSON Data
- array_to_string, Array Functions and Operators
- array_to_tsvector, Text Search Functions and Operators
- array_upper, Array Functions and Operators
- ascii, String Functions and Operators
- asin, Mathematical Functions and Operators
- asind, Mathematical Functions and Operators
- asinh, Mathematical Functions and Operators
- ASSERT
- array_append, Array Functions and Operators
- in PL/pgSQL, Checking Assertions
- assertions
- in PL/pgSQL, Checking Assertions
- asynchronous commit, Asynchronous Commit
- AT TIME ZONE, AT TIME ZONE
- atan, Mathematical Functions and Operators
- atan2, Mathematical Functions and Operators
- atan2d, Mathematical Functions and Operators
- atand, Mathematical Functions and Operators
- atanh, Mathematical Functions and Operators
- authentication_timeout configuration parameter, Authentication
- auth_delay, auth_delay — pause on authentication failure
- auth_delay.milliseconds configuration parameter, Configuration Parameters
- auto-increment (see serial)
- autocommit
- AT TIME ZONE, AT TIME ZONE
- bulk-loading data, Disable Autocommit
- psql, Variables
- bulk-loading data, Disable Autocommit
- autosummarize storage parameter, Index Storage Parameters
- autovacuum
- configuration parameters, Automatic Vacuuming
- general information, The Autovacuum Daemon
- configuration parameters, Automatic Vacuuming
- autovacuum configuration parameter, Automatic Vacuuming
- autovacuum_analyze_scale_factor
- configuration parameter, Automatic Vacuuming
- storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- autovacuum_analyze_threshold
- configuration parameter, Automatic Vacuuming
- storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- autovacuum_enabled storage parameter, Storage Parameters
- autovacuum_freeze_max_age
- configuration parameter, Automatic Vacuuming
- storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- autovacuum_freeze_min_age storage parameter, Storage Parameters
- autovacuum_freeze_table_age storage parameter, Storage Parameters
- autovacuum_max_workers configuration parameter, Automatic Vacuuming
- autovacuum_multixact_freeze_max_age
- autovacuum_freeze_table_age storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- autovacuum_multixact_freeze_min_age storage parameter, Storage Parameters
- autovacuum_multixact_freeze_table_age storage parameter, Storage Parameters
- autovacuum_naptime configuration parameter, Automatic Vacuuming
- autovacuum_vacuum_cost_delay
- autovacuum_multixact_freeze_table_age storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- autovacuum_vacuum_cost_limit
- configuration parameter, Automatic Vacuuming
- storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- autovacuum_vacuum_insert_scale_factor
- configuration parameter, Automatic Vacuuming
- storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- autovacuum_vacuum_insert_threshold
- configuration parameter, Automatic Vacuuming
- storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- autovacuum_vacuum_scale_factor
- configuration parameter, Automatic Vacuuming
- storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- autovacuum_vacuum_threshold
- configuration parameter, Automatic Vacuuming
- storage parameter, Storage Parameters
- configuration parameter, Automatic Vacuuming
- autovacuum_work_mem configuration parameter, Memory
- auto_explain, auto_explain — log execution plans of slow queries
- 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_level 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_parameter_max_length configuration parameter, Configuration Parameters
- auto_explain.log_settings 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
- auto_explain.log_wal configuration parameter, Configuration Parameters
- auto_explain.sample_rate configuration parameter, Configuration Parameters
- avals, hstore Operators and Functions
- average, Aggregate Functions
- avg, Aggregate Functions
- auto_explain, auto_explain — log execution plans of slow queries
B
- B-Tree (see index)
- backend_flush_after configuration parameter, Asynchronous Behavior
- Background workers, Background Worker Processes
- backslash escapes, String Constants with C-Style Escapes
- backslash_quote configuration parameter, Previous Postgres Pro Versions
- backtrace_functions configuration parameter, Developer Options
- backup, Backup Control Functions, Backup and Restore
- Backup Manifest, Backup Manifest Format
- base type, The Postgres Pro Type System
- base64 format, Binary String Functions and Operators
- basebackup_to_shell, basebackup_to_shell — example "shell" pg_basebackup module
- basebackup_to_shell.command configuration parameter, Configuration Parameters
- basebackup_to_shell.required_role configuration parameter, Configuration Parameters
- BASE_BACKUP, Streaming Replication Protocol
- basic_archive, basic_archive — an example WAL archive module
- basic_archive.archive_directory configuration parameter, Configuration Parameters
- batch mode, Pipeline Mode
- backend_flush_after configuration parameter, Asynchronous Behavior
- in libpq, Pipeline Mode
- BEGIN, BEGIN
- BETWEEN, Comparison Functions and Operators
- BETWEEN SYMMETRIC, Comparison Functions and Operators
- BGWORKER_BACKEND_DATABASE_CONNECTION, Background Worker Processes
- BGWORKER_SHMEM_ACCESS, Background Worker Processes
- bgwriter_delay configuration parameter, Background Writer
- bgwriter_flush_after 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, Binary String Functions and Operators
- BETWEEN, Comparison Functions and Operators
- functions, Binary String Functions and Operators
- binary string
- concatenation, Binary String Functions and Operators
- converting to character string, Binary String Functions and Operators
- length, Binary String Functions and Operators
- converting to character string, Binary String Functions and Operators
- concatenation, Binary String Functions and Operators
- bit string, Bit-String Constants, Bit String Types
- constant, Bit-String Constants
- data type, Bit String Types
- length, Bit String Functions and Operators
- data type, Bit String Types
- constant, Bit-String Constants
- bit strings, Bit String Functions and Operators
- functions, Bit String Functions and Operators
- bitmap scan, Combining Multiple Indexes, Planner Method Configuration
- bit_and, Aggregate Functions
- bit_count, Binary String Functions and Operators, Bit String Functions and Operators
- bit_length, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators
- bit_or, Aggregate Functions
- bit_xor, Aggregate Functions
- BLOB (see large object)
- block_size configuration parameter, Preset Options
- bloom, bloom — bloom filter index access method
- bonjour configuration parameter, Connection Settings
- bonjour_name configuration parameter, Connection Settings
- Boolean, Boolean Type
- bit_and, Aggregate Functions
- data type, Boolean Type
- operators (see operators, logical)
- data type, Boolean Type
- bool_and, Aggregate Functions
- bool_or, Aggregate Functions
- booting
- bool_or, Aggregate Functions
- starting the server during, Starting the Database Server
- bound_box, Geometric Functions and Operators
- box, Geometric Functions and Operators
- box (data type), Boxes
- bpchar, Character Types
- BRIN (see index)
- brin_desummarize_range, Index Maintenance Functions
- brin_metapage_info, BRIN Functions
- brin_page_items, BRIN Functions
- brin_page_type, BRIN Functions
- brin_revmap_data, BRIN Functions
- brin_summarize_new_values, Index Maintenance Functions
- brin_summarize_range, Index Maintenance Functions
- broadcast, Network Address Functions and Operators
- BSD Authentication, BSD Authentication
- btree_gin, btree_gin — GIN operator classes with B-tree behavior
- btree_gist, btree_gist — GiST operator classes with B-tree behavior
- btrim, String Functions and Operators, Binary String Functions and Operators
- bt_index_check, Functions
- bt_index_parent_check, Functions
- bt_metap, B-Tree Functions
- bt_multi_page_stats, B-Tree Functions
- bt_page_items, B-Tree Functions
- bt_page_stats, B-Tree Functions
- buffering storage parameter, Index Storage Parameters
- bytea, Binary Data Types
- bytea_output configuration parameter, Statement Behavior
- box, Geometric Functions and Operators
C
- C, libpq — C Library, ECPG — Embedded SQL in C
- C++, Using C++ for Extensibility
- CALL, CALL
- canceling, Canceling Queries in Progress
- C++, Using C++ for Extensibility
- SQL command, Canceling Queries in Progress
- cardinality, Array Functions and Operators
- CASCADE, Dependency Tracking
- with DROP, Dependency Tracking
- foreign key action, Foreign Keys
- with DROP, Dependency Tracking
- Cascading Replication, High Availability, Load Balancing, and Replication
- CASE, Conditional Expressions, UNION, CASE, and Related Constructs
- determination of result type, UNION, CASE, and Related Constructs
- case sensitivity
- of SQL commands, Identifiers and Key Words
- cast, CREATE 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
- chained transactions, Transaction Management, Parameters, Parameters
- ceil, Mathematical Functions and Operators
- in PL/pgSQL, Transaction Management
- char, Character Types
- character, Character Types
- character set, Locale and Formatting, Preset Options, Character Set Support
- character string, String Constants, Character Types
- character, Character Types
- concatenation, String Functions and Operators
- constant, String Constants
- converting to binary string, Binary String Functions and Operators
- data types, Character Types
- length, String Functions and Operators
- prefix test, String Functions and Operators
- constant, String Constants
- concatenation, String Functions and Operators
- character varying, Character Types
- character_length, String Functions and Operators
- char_length, String Functions and Operators
- check constraint, Check Constraints
- CHECK OPTION, CREATE VIEW
- checkpoint, WAL Configuration
- CHECKPOINT, CHECKPOINT
- checkpoint_completion_target configuration parameter, Checkpoints
- checkpoint_flush_after configuration parameter, Checkpoints
- checkpoint_timeout configuration parameter, Checkpoints
- checkpoint_warning configuration parameter, Checkpoints
- checksums, Data Checksums
- check_function_bodies configuration parameter, Statement Behavior
- chr, String Functions and Operators
- cid, Object Identifier Types
- cidr, cidr
- circle, Circles, Geometric Functions and Operators
- citext, citext — a case-insensitive character string type
- client authentication, Client Authentication
- character_length, String Functions and Operators
- timeout during, Authentication
- client_connection_check_interval configuration parameter, TCP Settings
- client_encoding configuration parameter, Locale and Formatting
- client_min_messages configuration parameter, Statement Behavior
- clock_timestamp, Date/Time Functions and Operators
- CLOSE, CLOSE
- cluster
- client_encoding configuration parameter, Locale and Formatting
- of databases (see database cluster)
- CLUSTER, CLUSTER
- clusterdb, clusterdb
- clustering, High Availability, Load Balancing, and Replication
- cluster_name configuration parameter, Process Title
- cmax, System Columns
- cmin, System Columns
- COALESCE, COALESCE
- COLLATE, Collation Expressions
- collation, Collation Support
- clusterdb, clusterdb
- in PL/pgSQL, Collation of PL/pgSQL Variables
- in SQL functions, SQL Functions with Collations
- in PL/pgSQL, Collation of PL/pgSQL Variables
- COLLATION FOR, System Catalog Information Functions
- color, Color Support
- column, Concepts, Table Basics
- color, Color Support
- adding, Adding a Column
- removing, Removing a Column
- renaming, Renaming a Column
- system column, System Columns
- removing, Removing a Column
- adding, Adding a Column
- column data type
- changing, Changing a Column's Data Type
- column reference, Column References
- col_description, Comment Information Functions
- comment, Comments
- col_description, Comment Information Functions
- about database objects, Comment Information Functions
- in SQL, Comments
- about database objects, Comment Information Functions
- COMMENT, COMMENT
- COMMIT, COMMIT
- COMMIT PREPARED, COMMIT PREPARED
- commit_delay configuration parameter, Settings
- commit_siblings configuration parameter, Settings
- common table expression (see WITH)
- comparison, Comparison Functions and Operators, Subquery Expressions
- COMMIT, COMMIT
- composite type, Row and Array Comparisons
- operators, Comparison Functions and Operators
- row constructor, Row and Array Comparisons
- subquery result row, Subquery Expressions
- operators, Comparison Functions and Operators
- composite type, Row and Array Comparisons
- compiling, Building libpq Programs
- libpq applications, Building libpq Programs
- composite type, Composite Types, The Postgres Pro Type System
- comparison, Row and Array Comparisons
- constant, Constructing Composite Values
- constructor, Row Constructors
- constant, Constructing Composite Values
- comparison, Row and Array Comparisons
- computed field, Using Composite Types in Queries
- compute_query_id configuration parameter, Statistics Monitoring
- concat, String Functions and Operators
- concat_ws, String Functions and Operators
- concurrency, Concurrency Control
- conditional expression, Conditional Expressions
- configuration
- compute_query_id configuration parameter, Statistics Monitoring
- of recovery
- general settings, Recovery
- of a standby server, Archive Recovery
- general settings, Recovery
- of the server, Server Configuration
- of the server
- functions, Configuration Settings Functions
- 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
- conjunction, Logical Operators
- 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
- check, Check Constraints
- adding, Adding a Constraint
- constraint exclusion, Partitioning and Constraint Exclusion, Other Planner Options
- constraint_exclusion configuration parameter, Other Planner Options
- container type, The Postgres Pro Type System
- CONTINUE
- constraint_exclusion configuration parameter, Other Planner Options
- in PL/pgSQL, CONTINUE
- continuous archiving, Backup and Restore
- in standby, Continuous Archiving in Standby
- control file, Extension Files
- convert, Binary String Functions and Operators
- convert_from, Binary String Functions and Operators
- convert_to, Binary String Functions and Operators
- COPY, Populating a Table With Rows, Functions Associated with the COPY Command, COPY
- convert, Binary String Functions and Operators
- with libpq, Functions Associated with the COPY Command
- corr, Aggregate Functions
- correlation, Aggregate Functions
- in the query planner, Extended Statistics
- cos, Mathematical Functions and Operators
- cosd, Mathematical Functions and Operators
- cosh, Mathematical Functions and Operators
- cot, Mathematical Functions and Operators
- cotd, Mathematical Functions and Operators
- count, Aggregate Functions
- covariance
- cosd, Mathematical Functions and Operators
- population, Aggregate Functions
- sample, Aggregate Functions
- population, Aggregate Functions
- covar_pop, Aggregate Functions
- covar_samp, Aggregate Functions
- covering index, Index-Only Scans and Covering Indexes
- 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
- crash_info configuration parameter, Error Handling
- crash_info_dump configuration parameter, Error Handling
- crash_info_location configuration parameter, Error Handling
- CREATE ACCESS METHOD, CREATE ACCESS METHOD
- 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 POLICY, CREATE POLICY
- CREATE PROCEDURE, CREATE PROCEDURE
- CREATE PROFILE, CREATE PROFILE
- CREATE PUBLICATION, CREATE PUBLICATION
- CREATE ROLE, Database Roles, CREATE ROLE
- CREATE RULE, CREATE RULE
- CREATE SCHEMA, CREATE SCHEMA
- CREATE SEQUENCE, CREATE SEQUENCE
- CREATE SERVER, CREATE SERVER
- CREATE STATISTICS, CREATE STATISTICS
- CREATE SUBSCRIPTION, CREATE SUBSCRIPTION
- 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 TRANSFORM, CREATE TRANSFORM
- 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
- createrole_self_grant
- covar_samp, Aggregate Functions
- configuration parameter, Statement Behavior
- createrole_self_grant configuration parameter
- use in securing functions, Writing SECURITY DEFINER Functions Safely
- createuser, Database Roles, createuser
- create_baseline, Baseline Management Functions
- CREATE_REPLICATION_SLOT, Streaming Replication Protocol
- create_server, Server Management Functions
- cross join, Joined Tables
- crosstab, crosstab(text), crosstabN(text), crosstab(text, text)
- crypt, crypt()
- cstring, Pseudo-Types
- CSV (Comma-Separated Values) format
- create_baseline, Baseline Management Functions
- in psql, Meta-Commands
- ctid, System Columns
- CTID, View Rules in Non-SELECT Statements
- CUBE, GROUPING SETS, CUBE, and ROLLUP
- cube (extension), cube — a multi-dimensional cube data type
- cume_dist, Window Functions
- CTID, View Rules in Non-SELECT Statements
- hypothetical, Aggregate Functions
- current_catalog, Session Information Functions
- current_database, Session Information Functions
- current_date, Date/Time Functions and Operators
- current_logfiles
- current_database, Session Information Functions
- and the log_destination configuration parameter, Where to Log
- and the pg_current_logfile function, Session Information Functions
- and the log_destination configuration parameter, Where to Log
- current_query, Session Information Functions
- current_role, Session Information Functions
- current_schema, Session Information Functions
- current_schemas, Session Information Functions
- current_setting, Configuration Settings Functions
- current_time, Date/Time Functions and Operators
- current_timestamp, Date/Time Functions and Operators
- current_user, Session Information Functions
- currval, Sequence Manipulation Functions
- cursor, Cursors, CLOSE, DECLARE, EXPLAIN, FETCH, MOVE
- current_role, Session Information Functions
- cursor_tuple_fraction configuration parameter, Other Planner Options
- custom scan provider, Writing a Custom Scan Provider
- handler for, Writing a Custom Scan Provider
D
- daitch_mokotoff, Daitch-Mokotoff Soundex
- data area (see database cluster)
- data partitioning, High Availability, Load Balancing, and Replication
- data type, Data Types, Numeric Types, Enumerated Types, Domain Types, Type Conversion, The Postgres Pro Type System, The Postgres Pro Type System, The Postgres Pro Type System, Polymorphic Types, Base Types in C-Language Functions, User-Defined Types
- data area (see database cluster)
- base, The Postgres Pro Type System
- category, Overview
- composite, The Postgres Pro Type System
- constant, Constants of Other Types
- container, The Postgres Pro Type System
- conversion, Type Conversion
- domain, Domain Types
- enumerated (enum), Enumerated Types
- internal organization, Base Types in C-Language Functions
- numeric, Numeric Types
- polymorphic, Polymorphic Types
- type cast, Type Casts
- user-defined, User-Defined Types
- category, Overview
- base, The Postgres Pro Type System
- database, Creating a Database, Managing Databases
- creating, Creating a Database
- privilege to create, Role Attributes
- creating, Creating a Database
- database activity, Monitoring 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
- data_directory_mode configuration parameter, Preset Options
- data_sync_retry configuration parameter, Error Handling
- date, Date/Time Types, Dates
- data_checksums configuration parameter, Preset Options
- constants, Special Values
- current, Current Date/Time
- output format, Date/Time Output
- current, Current Date/Time
- (see also formatting)
- constants, Special Values
- DateStyle configuration parameter, Locale and Formatting
- date_add, Date/Time Functions and Operators
- date_bin, date_bin
- date_part, Date/Time Functions and Operators, EXTRACT, date_part
- date_subtract, Date/Time Functions and Operators
- date_trunc, Date/Time Functions and Operators, date_trunc
- dbcopies_decoding, dbcopies_decoding
- dblink, dblink — connect to other Postgres Pro databases, 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, Authentication
- deadlock, Deadlocks
- date_add, Date/Time Functions and Operators
- timeout during, Lock Management
- deadlock_timeout configuration parameter, Lock Management
- DEALLOCATE, DEALLOCATE
- dearmor, armor(), dearmor()
- debug_assertions configuration parameter, Preset Options
- debug_deadlocks configuration parameter, Developer Options
- debug_discard_caches configuration parameter, Developer Options
- debug_io_direct configuration parameter, Developer Options
- debug_logical_replication_streaming configuration parameter, Developer Options
- debug_parallel_query configuration parameter, Developer Options
- debug_pretty_print configuration parameter, What to Log
- debug_print_parse configuration parameter, What to Log
- debug_print_plan configuration parameter, What to Log
- debug_print_rewritten configuration parameter, What to Log
- decimal (see numeric)
- DECLARE, DECLARE
- decode, Binary String Functions and Operators
- decode_bytea
- DEALLOCATE, DEALLOCATE
- in PL/Perl, Utility Functions in PL/Perl
- decrypt, Raw Encryption Functions
- decrypt_iv, Raw Encryption Functions
- deduplicate_items storage parameter, Index Storage Parameters
- default value, Default Values
- decrypt_iv, Raw Encryption Functions
- changing, Changing a Column's Default Value
- default-roles, Default Roles Renamed to Predefined Roles
- default_statistics_target configuration parameter, Other Planner Options
- default_tablespace configuration parameter, Statement Behavior
- default_table_access_method configuration parameter, Statement Behavior
- default_text_search_config configuration parameter, Locale and Formatting
- default_toast_compression configuration parameter, Statement Behavior
- default_transaction_deferrable configuration parameter, Statement Behavior
- default_transaction_isolation configuration parameter, Statement Behavior
- default_transaction_read_only configuration parameter, Statement Behavior
- deferrable transaction, Statement Behavior
- default_statistics_target configuration parameter, Other Planner Options
- setting, SET TRANSACTION
- setting default, Statement Behavior
- setting, SET TRANSACTION
- defined, hstore Operators and Functions
- degrees, Mathematical Functions and Operators
- delay, Delaying Execution
- DELETE, Deletions, Deleting Data, Returning Data from Modified Rows, DELETE
- degrees, Mathematical Functions and Operators
- RETURNING, Returning Data from Modified Rows
- delete, hstore Operators and Functions
- deleting, Deleting Data
- dense_rank, Window Functions
- deleting, Deleting Data
- hypothetical, Aggregate Functions
- diagonal, Geometric Functions and Operators
- diameter, Geometric Functions and Operators
- dict_int, dict_int — example full-text search dictionary for integers
- dict_xsyn, dict_xsyn — example synonym full-text search dictionary
- difference, Soundex
- digest, digest()
- dirty read, Transaction Isolation
- disable_server, Server Management Functions
- DISCARD, DISCARD
- disjunction, Logical Operators
- disk drive, WAL Internals
- disk space, Recovering Disk Space
- disk usage, Determining Disk Usage
- DISTINCT, Querying a Table, GROUPING SETS, CUBE, and ROLLUP, DISTINCT
- diameter, Geometric Functions and Operators
- GROUP BY DISTINCT, GROUPING SETS, CUBE, and ROLLUP
- SELECT DISTINCT, DISTINCT
- GROUP BY DISTINCT, GROUPING SETS, CUBE, and ROLLUP
- div, Mathematical Functions and Operators
- dmetaphone, Double Metaphone
- dmetaphone_alt, Double Metaphone
- DO, DO
- document, What Is a Document?
- dmetaphone, Double Metaphone
- text search, What Is a Document?
- dollar quoting, Dollar-Quoted String Constants
- domain, Domain Types
- double precision, Floating-Point Types
- DROP ACCESS METHOD, DROP ACCESS METHOD
- 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 POLICY, DROP POLICY
- DROP PROCEDURE, DROP PROCEDURE
- DROP PROFILE, DROP PROFILE
- DROP PUBLICATION, DROP PUBLICATION
- DROP ROLE, Database Roles, DROP ROLE
- DROP ROUTINE, DROP ROUTINE
- DROP RULE, DROP RULE
- DROP SCHEMA, DROP SCHEMA
- DROP SEQUENCE, DROP SEQUENCE
- DROP SERVER, DROP SERVER
- DROP STATISTICS, DROP STATISTICS
- DROP SUBSCRIPTION, DROP SUBSCRIPTION
- 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 TRANSFORM, DROP TRANSFORM
- 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
- dropuser, Database Roles, dropuser
- drop_baseline, Baseline Management Functions
- DROP_REPLICATION_SLOT, Streaming Replication Protocol
- drop_server, Server Management Functions
- DTD, Creating XML Values
- dump_stat, dump_stat — functions to backup and recover the pg_statistic table
- dump_statistic, Functions
- 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
- domain, Domain Types
E
- each, hstore Operators and Functions
- earth, Cube-Based Earth Distances
- earthdistance, earthdistance — calculate great-circle distances
- earth_box, Cube-Based Earth Distances
- earth_distance, Cube-Based Earth Distances
- ECPG, ECPG — Embedded SQL in C
- ecpg, ecpg
- effective_cache_size configuration parameter, Planner Cost Constants
- effective_io_concurrency configuration parameter, Asynchronous Behavior
- elog
- 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
- in PL/Python, Utility Functions
- in PL/Perl, Utility Functions in PL/Perl
- embedded SQL, ECPG — Embedded SQL in C
- in C, ECPG — Embedded SQL in C
- enabled role, enabled_roles
- enable_appendorpath configuration parameter, Other Planner Options
- enable_async_append configuration parameter, Planner Method Configuration
- enable_bitmapscan configuration parameter, Planner Method Configuration
- enable_compound_index_stats configuration parameter, Planner Method Configuration
- enable_gathermerge configuration parameter, Planner Method Configuration
- enable_group_by_reordering configuration parameter, Planner Method Configuration
- enable_hashagg configuration parameter, Planner Method Configuration
- enable_hashjoin configuration parameter, Planner Method Configuration
- enable_incremental_sort 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_memoize configuration parameter, Planner Method Configuration
- enable_mergejoin configuration parameter, Planner Method Configuration
- enable_nestloop configuration parameter, Planner Method Configuration
- enable_parallel_append configuration parameter, Planner Method Configuration
- enable_parallel_hash configuration parameter, Planner Method Configuration
- enable_partitionwise_aggregate configuration parameter, Planner Method Configuration
- enable_partitionwise_join configuration parameter, Planner Method Configuration
- enable_partition_pruning configuration parameter, Planner Method Configuration
- enable_presorted_aggregate configuration parameter, Planner Method Configuration
- enable_self_join_removal configuration parameter, Planner Method Configuration
- enable_seqscan configuration parameter, Planner Method Configuration
- enable_server, Server Management Functions
- enable_sort configuration parameter, Planner Method Configuration
- enable_tidscan configuration parameter, Planner Method Configuration
- encode, Binary String Functions and Operators
- encode_array_constructor
- enable_appendorpath configuration parameter, Other Planner Options
- 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, pgcrypto — cryptographic functions
- for specific columns, pgcrypto — cryptographic functions
- 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
- ephemeral named relation
- END, END
- registering with SPI, SPI_register_relation, SPI_register_trigger_data
- unregistering from SPI, SPI_unregister_relation
- registering with SPI, SPI_register_relation, SPI_register_trigger_data
- erf, Mathematical Functions and Operators
- erfc, Mathematical Functions and Operators
- error codes, Postgres Pro Error Codes
- erfc, Mathematical Functions and Operators
- libpq, Main Functions
- list of, Postgres Pro Error Codes
- libpq, Main Functions
- error message, Connection Status Functions
- escape format, Binary String Functions and Operators
- escape string syntax, String Constants with C-Style Escapes
- escape_string_warning configuration parameter, Previous Postgres Pro Versions
- escaping strings, Escaping Strings for Inclusion in SQL Commands
- escape format, Binary String Functions and Operators
- event log, Registering Event Log on Windows
- event log, Registering Event Log on Windows
- event trigger, Event Triggers, Writing Event Trigger Functions in C
- event_source configuration parameter, Where to Log
- event_trigger, Pseudo-Types
- every, Aggregate Functions
- EXCEPT, Combining Queries (UNION, INTERSECT, EXCEPT)
- exceptions
- event_trigger, Pseudo-Types
- in PL/pgSQL, Trapping Errors
- in PL/Tcl, Error Handling in PL/Tcl
- 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
- export_data, Export and Import Functions
- expression, Value Expressions
- exp, Mathematical Functions and Operators
- order of evaluation, Expression Evaluation Rules
- syntax, Value Expressions
- order of evaluation, Expression Evaluation Rules
- 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
- factorial, Mathematical Functions and Operators
- failover, High Availability, Load Balancing, and Replication
- false, Boolean Type
- family, Network Address Functions and Operators
- fast path, The Fast-Path Interface
- fastupdate storage parameter, Index Storage Parameters
- fdw_handler, Pseudo-Types
- FETCH, FETCH
- field
- failover, High Availability, Load Balancing, and Replication
- computed, Using Composite Types in Queries
- field selection, Field Selection
- file system mount points, Use of Secondary File Systems
- file_fdw, file_fdw — access data files in the server's file system
- fillfactor storage parameter, Index Storage Parameters, Storage Parameters
- FILTER, Aggregate Expressions
- first_value, Window Functions
- float4 (see real)
- float8 (see double precision)
- floating point, Floating-Point Types
- floating-point
- file system mount points, Use of Secondary File Systems
- display, Locale and Formatting
- floor, Mathematical Functions and Operators
- foreign data, Foreign Data
- foreign data wrapper, Writing a Foreign Data Wrapper
- foreign data, Foreign Data
- handler for, Writing a Foreign Data Wrapper
- foreign key, Foreign Keys, Foreign Keys
- self-referential, Foreign Keys
- foreign table, Foreign Data
- format, String Functions and Operators, format
- use in PL/pgSQL, Executing Dynamic Commands
- formatting, Data Type Formatting Functions
- format_type, System Catalog Information Functions
- Free Space Map, Free Space Map
- FreeBSD
- format_type, System Catalog Information Functions
- IPC configuration, Shared Memory and Semaphores
- shared library, Compiling and Linking Dynamically-Loaded Functions
- start script, Starting the Database Server
- shared library, Compiling and Linking Dynamically-Loaded Functions
- IPC configuration, Shared Memory and Semaphores
- from_collapse_limit configuration parameter, Other Planner Options
- FSM (see Free Space Map)
- fsm_page_contents, General Functions
- fsync configuration parameter, Settings
- full text search, Text Search Types, Text Search Types, Full Text Search
- FSM (see Free Space Map)
- data types, Text Search Types
- functions and operators, Text Search Types
- data types, Text Search Types
- full_page_writes configuration parameter, Settings
- function, Table Functions, Functions and Operators, Statistics Information Functions, Functions, Polymorphic Types, User-Defined Functions, Query Language (SQL) Functions, Internal Functions, C-Language Functions
- 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
- statistics, Statistics Information Functions
- type resolution in an invocation, Functions
- user-defined, User-Defined Functions, Query Language (SQL) Functions, C-Language Functions
- in the FROM clause, Table Functions
- in C, C-Language Functions
- in SQL, Query Language (SQL) Functions
- in C, C-Language Functions
- variadic, SQL Functions with Variable Numbers of Arguments
- with SETOF, SQL Functions Returning Sets
- default values for arguments, SQL Functions with Default Values for Arguments
- functional dependency, The GROUP BY and HAVING Clauses
- fuzzystrmatch, fuzzystrmatch — determine string similarities and distance
G
- gcd, Mathematical Functions and Operators
- gc_to_sec, Cube-Based Earth Distances
- generated column, Generated Columns, Parameters, Parameters
- gc_to_sec, Cube-Based Earth Distances
- in triggers, Overview of Trigger Behavior
- generate_series, Set Returning Functions
- generate_subscripts, Set Returning Functions
- generic_plan_fuzz_factor configuration parameter, Planner Cost Constants
- genetic query optimization, Genetic Query Optimizer
- gen_random_bytes, Random-Data Functions
- gen_random_uuid, UUID Functions, Random-Data Functions
- gen_salt, gen_salt()
- GEQO (see genetic query optimization)
- geqo configuration parameter, Genetic Query Optimizer
- geqo_effort configuration parameter, Genetic Query Optimizer
- geqo_generations configuration parameter, Genetic Query Optimizer
- geqo_pool_size configuration parameter, Genetic Query Optimizer
- geqo_seed configuration parameter, Genetic Query Optimizer
- geqo_selection_bias configuration parameter, Genetic Query Optimizer
- geqo_threshold configuration parameter, Genetic Query Optimizer
- get_bit, Binary String Functions and Operators, Bit String Functions and Operators
- get_byte, Binary String Functions and Operators
- get_current_ts_config, Text Search Functions and Operators
- get_diffreport, Differential Reports
- get_namespace, Functions
- get_raw_page, General Functions
- get_report, Regular Reports
- GIN (see index)
- gin_clean_pending_list, Index Maintenance Functions
- gin_fuzzy_search_limit configuration parameter, Other Defaults
- gin_leafpage_items, GIN Functions
- gin_metapage_info, GIN Functions
- gin_page_opaque_info, GIN Functions
- gin_pending_list_limit
- generate_subscripts, Set Returning Functions
- configuration parameter, Statement Behavior
- storage parameter, Index Storage Parameters
- configuration parameter, Statement Behavior
- GiST (see index)
- gist_page_items, GiST Functions
- gist_page_items_bytea, GiST Functions
- gist_page_opaque_info, GiST Functions
- global data, Global Data in PL/Tcl
- gist_page_items, GiST Functions
- in PL/Python, Sharing Data
- in PL/Tcl, Global Data in PL/Tcl
- in PL/Python, Sharing Data
- GRANT, Privileges, GRANT
- GREATEST, GREATEST and LEAST, UNION, CASE, and Related Constructs
- 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
- GROUPING, Aggregate Functions
- GROUPING SETS, GROUPING SETS, CUBE, and ROLLUP
- gssapi, Secure TCP/IP Connections with GSSAPI Encryption
- GSSAPI, GSSAPI Authentication
- GROUP BY, Aggregate Functions, The GROUP BY and HAVING Clauses
- with libpq, Parameter Key Words
- gss_accept_delegation configuration parameter, Authentication
- GUID, UUID Type
H
- hash (see index)
- hash_bitmap_info, Hash Functions
- hash_mem_multiplier configuration parameter, Memory
- hash_metapage_info, Hash Functions
- hash_page_items, Hash Functions
- hash_page_stats, Hash Functions
- hash_page_type, Hash Functions
- has_any_column_privilege, Access Privilege Inquiry Functions
- has_column_privilege, Access Privilege Inquiry Functions
- has_database_privilege, Access Privilege Inquiry Functions
- has_foreign_data_wrapper_privilege, Access Privilege Inquiry Functions
- has_function_privilege, Access Privilege Inquiry Functions
- has_language_privilege, Access Privilege Inquiry Functions
- has_parameter_privilege, Access Privilege Inquiry Functions
- has_schema_privilege, Access Privilege Inquiry Functions
- has_sequence_privilege, Access Privilege Inquiry Functions
- has_server_privilege, Access Privilege Inquiry Functions
- has_tablespace_privilege, Access Privilege Inquiry Functions
- has_table_privilege, Access Privilege Inquiry Functions
- has_type_privilege, Access Privilege Inquiry Functions
- HAVING, Aggregate Functions, The GROUP BY and HAVING Clauses
- hba_file configuration parameter, File Locations
- heap_page_items, Heap Functions
- heap_page_item_attrs, Heap Functions
- heap_tuple_infomask_flags, Heap Functions
- height, Geometric Functions and Operators
- hex format, Binary String Functions and Operators
- hierarchical database, Concepts
- high availability, High Availability, Load Balancing, and Replication
- history, A Brief History of PostgreSQL
- hash_bitmap_info, Hash 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
- hstore, hstore — hstore key/value datatype, hstore Operators and Functions
- hstore_to_array, hstore Operators and Functions
- hstore_to_json, hstore Operators and Functions
- hstore_to_jsonb, hstore Operators and Functions
- hstore_to_jsonb_loose, hstore Operators and Functions
- hstore_to_json_loose, hstore Operators and Functions
- hstore_to_matrix, hstore Operators and Functions
- huge_pages configuration parameter, Memory
- huge_page_size configuration parameter, Memory
- Hunspell Dictionaries, Hunspell Dictionaries Modules
- hypothetical-set aggregate
- host, Network Address Functions and Operators
- built-in, Aggregate Functions
I
- icount, intarray Functions and Operators
- ICU, Locale Providers, Managing Collations, Parameters, Parameters
- icu_validation_level configuration parameter, Locale and Formatting
- ident, Ident Authentication
- identifier, Identifiers and Key Words
- ICU, Locale Providers, Managing Collations, Parameters, Parameters
- length, Identifiers and Key Words
- syntax of, Identifiers and Key Words
- length, Identifiers and Key Words
- IDENTIFY_SYSTEM, Streaming Replication Protocol
- ident_file configuration parameter, File Locations
- idle_in_transaction_session_timeout configuration parameter, Statement Behavior
- idle_session_timeout configuration parameter, Statement Behavior
- idx, intarray Functions and Operators
- IFNULL, COALESCE
- ignore_checksum_failure configuration parameter, Developer Options
- ignore_invalid_pages configuration parameter, Developer Options
- ignore_system_indexes configuration parameter, Developer Options
- IMMUTABLE, Function Volatility Categories
- IMPORT FOREIGN SCHEMA, IMPORT FOREIGN SCHEMA
- import_data, Export and Import Functions
- IN, Subquery Expressions, Row and Array Comparisons
- INCLUDE
- ident_file configuration parameter, File Locations
- in index definitions, Index-Only Scans and Covering Indexes
- include
- 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, Multicolumn Indexes, Indexes and ORDER BY, Combining Multiple Indexes, Unique Indexes, Indexes on Expressions, Partial Indexes, Index-Only Scans and Covering Indexes, Index-Only Scans and Covering Indexes, Examining Index Usage, Preferred Index Types for Text Search, Preferred Index Types for Text Search, Locking and Indexes, Interfacing Extensions to Indexes, Building Indexes Concurrently, Rebuilding Indexes Concurrently, Operators and Functions
- and ORDER BY, Indexes and ORDER BY
- B-Tree, B-Tree, B-Tree Indexes
- BRIN, BRIN, BRIN Indexes
- building concurrently, Building Indexes Concurrently
- combining multiple indexes, Combining Multiple Indexes
- covering, Index-Only Scans and Covering Indexes
- examining usage, Examining Index Usage
- on expressions, Indexes on Expressions
- for user-defined data type, Interfacing Extensions to Indexes
- GIN, GIN, Preferred Index Types for Text Search, GIN Indexes
- B-Tree, B-Tree, B-Tree Indexes
- text search, Preferred Index Types for Text Search
- GiST, GiST, Preferred Index Types for Text Search, GiST Indexes
- text search, Preferred Index Types for Text Search
- hash, Hash
- Hash, Hash Indexes
- index-only scans, Index-Only Scans and Covering Indexes
- locks, Locking and Indexes
- multicolumn, Multicolumn Indexes
- partial, Partial Indexes
- rebuilding concurrently, Rebuilding Indexes Concurrently
- SP-GiST, SP-GiST, SP-GiST Indexes
- unique, Unique Indexes
- Hash, Hash Indexes
- and ORDER BY, Indexes and ORDER BY
- Index Access Method, Index Access Method Interface Definition
- index scan, Planner Method Configuration
- index-only scan, Index-Only Scans and Covering Indexes
- indexam
- index scan, Planner Method Configuration
- Index Access Method, Index Access Method Interface Definition
- index_am_handler, Pseudo-Types
- inet (data type), inet
- inet_client_addr, Session Information Functions
- inet_client_port, Session Information Functions
- inet_merge, Network Address Functions and Operators
- inet_same_family, Network Address Functions and Operators
- inet_server_addr, Session Information Functions
- inet_server_port, Session Information Functions
- infinity
- inet (data type), inet
- floating point, Floating-Point Types
- numeric (data type), Arbitrary Precision Numbers
- floating point, Floating-Point Types
- information schema, The Information Schema
- inheritance, Inheritance, Inheritance
- 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, Returning Data from Modified Rows, INSERT
- inheritance, Inheritance, Inheritance
- RETURNING, Returning Data from Modified Rows
- inserting, Inserting Data
- instr function, Appendix
- int2 (see smallint)
- int4 (see integer)
- int8 (see bigint)
- intagg, intagg — integer aggregator and enumerator
- intarray, intarray — manipulate arrays of integers
- integer, Numeric Constants, Integer Types
- integer_datetimes configuration parameter, Preset Options
- interfaces
- instr function, Appendix
- externally maintained, Client Interfaces
- internal, Pseudo-Types
- INTERSECT, Combining Queries (UNION, INTERSECT, EXCEPT)
- interval, Date/Time Types, Interval Input
- INTERSECT, Combining Queries (UNION, INTERSECT, EXCEPT)
- 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
- in_hot_standby configuration parameter, Preset Options
- in_range support functions, B-Tree Support Functions
- IS DISTINCT FROM, Comparison Functions and Operators, Row and Array Comparisons
- IS DOCUMENT, IS DOCUMENT
- IS FALSE, Comparison Functions and Operators
- IS JSON, Processing and Creating JSON Data
- IS NOT DISTINCT FROM, Comparison Functions and Operators, Row and Array Comparisons
- IS NOT DOCUMENT, IS NOT DOCUMENT
- IS NOT FALSE, Comparison Functions and Operators
- IS NOT NULL, Comparison Functions and Operators
- IS NOT TRUE, Comparison Functions and Operators
- IS NOT UNKNOWN, Comparison Functions and Operators
- IS NULL, Comparison Functions and Operators, Platform and Client Compatibility
- IS TRUE, Comparison Functions and Operators
- IS UNKNOWN, Comparison Functions and Operators
- isclosed, Geometric Functions and Operators
- isempty, Range/Multirange Functions and Operators
- isfinite, Date/Time Functions and Operators
- isn, isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)
- ISNULL, Comparison Functions and 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
- JIT, Just-in-Time Compilation (JIT)
- jit configuration parameter, Other Planner Options
- jit_above_cost configuration parameter, Planner Cost Constants
- jit_debugging_support configuration parameter, Developer Options
- jit_dump_bitcode configuration parameter, Developer Options
- jit_expressions configuration parameter, Developer Options
- jit_inline_above_cost configuration parameter, Planner Cost Constants
- jit_optimize_above_cost configuration parameter, Planner Cost Constants
- jit_profiling_support configuration parameter, Developer Options
- jit_provider configuration parameter, Shared Library Preloading
- jit_tuple_deforming configuration parameter, Developer Options
- join, Joins Between Tables, Joined Tables, Controlling the Planner with Explicit JOIN Clauses
- jit configuration parameter, Other Planner Options
- 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
- cross, Joined Tables
- controlling the order, Controlling the Planner with Explicit JOIN Clauses
- join_collapse_limit configuration parameter, Other Planner Options
- JSON, JSON Types, JSON Functions and Operators
- functions and operators, JSON Functions and Operators
- json constructor, Processing and Creating JSON Data
- JSONB, JSON Types
- jsonb
- JSONB, JSON Types
- containment, jsonb Containment and Existence
- existence, jsonb Containment and Existence
- indexes on, jsonb Indexing
- existence, jsonb Containment and Existence
- containment, jsonb Containment and Existence
- jsonb_agg, Aggregate Functions
- jsonb_agg_strict, Aggregate Functions
- jsonb_array_elements, Processing and Creating JSON Data
- jsonb_array_elements_text, Processing and Creating JSON Data
- jsonb_array_length, Processing and Creating JSON Data
- jsonb_build_array, Processing and Creating JSON Data
- jsonb_build_object, Processing and Creating JSON Data
- jsonb_each, Processing and Creating JSON Data
- jsonb_each_text, Processing and Creating JSON Data
- jsonb_extract_path, Processing and Creating JSON Data
- jsonb_extract_path_text, Processing and Creating JSON Data
- jsonb_insert, Processing and Creating JSON Data
- jsonb_object, Processing and Creating JSON Data
- jsonb_object_agg, Aggregate Functions
- jsonb_object_agg_strict, Aggregate Functions
- jsonb_object_agg_unique, Aggregate Functions
- jsonb_object_agg_unique_strict, Aggregate Functions
- jsonb_object_keys, Processing and Creating JSON Data
- jsonb_path_exists, Processing and Creating JSON Data
- jsonb_path_exists_tz, Processing and Creating JSON Data
- jsonb_path_match, Processing and Creating JSON Data
- jsonb_path_match_tz, Processing and Creating JSON Data
- jsonb_path_query, Processing and Creating JSON Data
- jsonb_path_query_array, Processing and Creating JSON Data
- jsonb_path_query_array_tz, Processing and Creating JSON Data
- jsonb_path_query_first, Processing and Creating JSON Data
- jsonb_path_query_first_tz, Processing and Creating JSON Data
- jsonb_path_query_tz, Processing and Creating JSON Data
- jsonb_populate_record, Processing and Creating JSON Data
- jsonb_populate_recordset, Processing and Creating JSON Data
- jsonb_pretty, Processing and Creating JSON Data
- jsonb_set, Processing and Creating JSON Data
- jsonb_set_lax, Processing and Creating JSON Data
- jsonb_strip_nulls, Processing and Creating JSON Data
- jsonb_to_record, Processing and Creating JSON Data
- jsonb_to_recordset, Processing and Creating JSON Data
- jsonb_to_tsvector, Text Search Functions and Operators
- jsonb_typeof, Processing and Creating JSON Data
- jsonpath, jsonpath Type
- json_agg, Aggregate Functions
- json_agg_strict, Aggregate Functions
- json_array, Processing and Creating JSON Data
- json_arrayagg, Aggregate Functions
- json_array_elements, Processing and Creating JSON Data
- json_array_elements_text, Processing and Creating JSON Data
- json_array_length, Processing and Creating JSON Data
- json_build_array, Processing and Creating JSON Data
- json_build_object, Processing and Creating JSON Data
- json_each, Processing and Creating JSON Data
- json_each_text, Processing and Creating JSON Data
- json_exists, Processing and Creating JSON Data
- json_extract_path, Processing and Creating JSON Data
- json_extract_path_text, Processing and Creating JSON Data
- json_object, Processing and Creating JSON Data
- json_objectagg, Aggregate Functions
- json_object_agg, Aggregate Functions
- json_object_agg_strict, Aggregate Functions
- json_object_agg_unique, Aggregate Functions
- json_object_agg_unique_strict, Aggregate Functions
- json_object_keys, Processing and Creating JSON Data
- json_populate_record, Processing and Creating JSON Data
- json_populate_recordset, Processing and Creating JSON Data
- json_query, Processing and Creating JSON Data
- json_scalar, Processing and Creating JSON Data
- json_strip_nulls, Processing and Creating JSON Data
- json_table, JSON_TABLE
- json_to_record, Processing and Creating JSON Data
- json_to_recordset, Processing and Creating JSON Data
- json_to_tsvector, Text Search Functions and Operators
- json_typeof, Processing and Creating JSON Data
- json_value, Processing and Creating JSON Data
- Julian date, Julian Dates
- Just-In-Time compilation (see JIT)
- justify_days, Date/Time Functions and Operators
- justify_hours, Date/Time Functions and Operators
- justify_interval, Date/Time Functions and Operators
- jsonb_agg_strict, Aggregate Functions
K
- keep_baseline, Baseline Management Functions
- key word, Identifiers and Key Words, SQL Key Words
- list of, SQL Key Words
- syntax of, Identifiers and Key Words
- list of, SQL Key Words
- krb_caseins_users configuration parameter, Authentication
- krb_server_keyfile configuration parameter, 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, LATERAL Subqueries
- lag, Window Functions
- in the FROM clause, LATERAL Subqueries
- latitude, Cube-Based Earth Distances
- lca, Operators and Functions
- lcm, Mathematical Functions and Operators
- 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, LDAP Authentication
- LDAP connection parameter lookup, LDAP Lookup of Connection Parameters
- lead, Window Functions
- LEAST, GREATEST and LEAST, UNION, CASE, and Related Constructs
- 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, Bit 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)
- of a binary string (see binary strings, length)
- length(tsvector), Manipulating Documents
- levenshtein, Levenshtein
- levenshtein_less_equal, Levenshtein
- libedit
- levenshtein, Levenshtein
- in psql, Command-Line Editing
- libpq, libpq — C Library, Pipeline Mode, Retrieving Query Results Row-by-Row
- pipeline mode, Pipeline Mode
- single-row mode, Retrieving Query Results Row-by-Row
- pipeline mode, Pipeline Mode
- libpq-fe.h, libpq — C Library, Connection Status Functions
- libpq-int.h, Connection Status Functions
- library initialization function, Dynamic Loading
- LIKE, LIKE
- libpq-int.h, Connection Status Functions
- and locales, Behavior
- LIKE_REGEX, Differences from SQL Standard and XQuery, SQL/JSON Regular Expressions
- in SQL/JSON, SQL/JSON Regular Expressions
- LIMIT, LIMIT and OFFSET
- line, Lines, Geometric Functions and Operators
- line segment, Line Segments
- linear regression, Aggregate Functions
- Linux
- line, Lines, Geometric Functions and Operators
- IPC configuration, Shared Memory and Semaphores
- shared library, Compiling and Linking Dynamically-Loaded Functions
- start script, Starting the Database Server
- shared library, Compiling and Linking Dynamically-Loaded Functions
- IPC configuration, Shared Memory and Semaphores
- LISTEN, LISTEN
- listen_addresses configuration parameter, Connection Settings
- ll_to_earth, Cube-Based Earth Distances
- ln, Mathematical Functions and Operators
- lo, lo — manage large objects
- 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, Advisory Locks, Viewing Locks
- listen_addresses configuration parameter, Connection Settings
- advisory, Advisory Locks
- monitoring, Viewing Locks
- advisory, Advisory Locks
- LOCK, Table-Level Locks, LOCK
- lock_timeout configuration parameter, Statement Behavior
- log, Mathematical Functions and Operators
- log shipping, High Availability, Load Balancing, and Replication
- log10, Mathematical Functions and Operators
- Logging
- lock_timeout configuration parameter, Statement Behavior
- current_logfiles file and the pg_current_logfile function, Session Information Functions
- pg_current_logfile function, Session Information Functions
- current_logfiles file and the pg_current_logfile function, Session Information Functions
- logging_collector configuration parameter, Where to Log
- Logical Decoding, Logical Decoding, Logical Decoding
- logical_decoding_work_mem configuration parameter, Memory
- login privilege, Role Attributes
- log_autovacuum_min_duration
- Logical Decoding, Logical Decoding, Logical Decoding
- configuration parameter, What to Log
- storage parameter, Storage Parameters
- configuration parameter, What to Log
- 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_sample configuration parameter, When 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_parameter_max_length configuration parameter, What to Log
- log_parameter_max_length_on_error configuration parameter, What to Log
- log_parser_stats configuration parameter, Statistics Monitoring
- log_planner_stats configuration parameter, Statistics Monitoring
- log_recovery_conflict_waits configuration parameter, What to Log
- log_replication_commands configuration parameter, What to Log
- log_rotation_age configuration parameter, Where to Log
- log_rotation_size configuration parameter, Where to Log
- log_startup_progress_interval configuration parameter, When to Log
- log_statement configuration parameter, What to Log
- log_statement_sample_rate configuration parameter, When 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_transaction_sample_rate configuration parameter, When to Log
- log_truncate_on_rotation configuration parameter, Where to Log
- longitude, Cube-Based Earth Distances
- looks_like_number
- log_checkpoints configuration parameter, What to Log
- in PL/Perl, Utility Functions in PL/Perl
- loop, Simple Loops
- in PL/pgSQL, Simple Loops
- lower, String Functions and Operators, Range/Multirange Functions and Operators
- and locales, Behavior
- lower_inc, Range/Multirange Functions and Operators
- lower_inf, Range/Multirange Functions and Operators
- lo_close, Closing a Large Object Descriptor
- lo_compat_privileges configuration parameter, Previous Postgres Pro 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
- LSN, WAL Internals
- ltree, ltree — hierarchical tree-like data type
- ltree2text, Operators and Functions
- ltrim, String Functions and Operators, Binary String Functions and Operators
- lower_inf, Range/Multirange Functions and Operators
M
- MAC address (see macaddr)
- MAC address (EUI-64 format) (see macaddr)
- macaddr (data type), macaddr
- macaddr8 (data type), macaddr8
- macaddr8_set7bit, Network Address Functions and Operators
- macOS
- MAC address (EUI-64 format) (see macaddr)
- IPC configuration, Shared Memory and Semaphores
- shared library, Compiling and Linking Dynamically-Loaded Functions
- IPC configuration, Shared Memory and Semaphores
- magic block, Dynamic Loading
- maintenance, Routine Database Maintenance Tasks
- maintenance_io_concurrency configuration parameter, Asynchronous Behavior
- maintenance_work_mem configuration parameter, Memory
- makeaclitem, Access Privilege Inquiry Functions
- 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
- mamonsu, mamonsu
- masklen, Network Address Functions and Operators
- materialized view, Materialized Views
- maintenance, Routine Database Maintenance Tasks
- 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_logical_replication_workers configuration parameter, Subscribers
- max_parallel_apply_workers_per_subscription configuration parameter, Subscribers
- max_parallel_maintenance_workers configuration parameter, Asynchronous Behavior
- max_parallel_workers configuration parameter, Asynchronous Behavior
- max_parallel_workers_per_gather configuration parameter, Asynchronous Behavior
- max_pred_locks_per_page configuration parameter, Lock Management
- max_pred_locks_per_relation configuration parameter, Lock Management
- max_pred_locks_per_transaction configuration parameter, Lock Management
- max_prepared_transactions configuration parameter, Memory
- max_replication_slots configuration parameter
- max, Aggregate Functions
- in a sending server, Sending Servers
- in a subscriber, Subscribers
- in a sending server, Sending Servers
- max_slot_wal_keep_size configuration parameter, Sending Servers
- max_stack_depth configuration parameter, Memory
- max_standby_archive_delay configuration parameter, Standby Servers
- max_standby_streaming_delay configuration parameter, Standby Servers
- max_sync_workers_per_subscription configuration parameter, Subscribers
- max_wal_senders configuration parameter, Sending Servers
- max_wal_size configuration parameter, Checkpoints
- max_worker_processes configuration parameter, Asynchronous Behavior
- md5, String Functions and Operators, Binary String Functions and Operators
- MD5, Password Authentication
- median, Aggregate Expressions
- max_stack_depth configuration parameter, Memory
- (see also percentile)
- memory context
- in SPI, Memory Management
- memory overcommit, Linux Memory Overcommit
- MERGE, MERGE
- metaphone, Metaphone
- min, Aggregate Functions
- min_dynamic_shared_memory configuration parameter, Memory
- min_parallel_index_scan_size configuration parameter, Planner Cost Constants
- min_parallel_table_scan_size configuration parameter, Planner Cost Constants
- min_scale, Mathematical Functions and Operators
- min_wal_size configuration parameter, Checkpoints
- mod, Mathematical Functions and Operators
- mode
- MERGE, MERGE
- statistical, Aggregate Functions
- monitoring, Monitoring Database Activity
- database activity, Monitoring Database Activity
- MOVE, MOVE
- moving-aggregate mode, Moving-Aggregate Mode
- multirange (function), Range/Multirange Functions and Operators
- multirange type, Range Types
- Multiversion Concurrency Control, Introduction
- MultiXactId, Multixacts and Wraparound
- MVCC, Introduction
- mxid_age, Control Data Functions
- moving-aggregate mode, Moving-Aggregate Mode
N
- name, Identifiers and Key Words
- qualified, Creating a Schema
- syntax of, Identifiers and Key Words
- unqualified, The Schema Search Path
- syntax of, Identifiers and Key Words
- qualified, Creating a Schema
- NaN (see not a number)
- natural join, Joined Tables
- negation, Logical Operators
- NetBSD
- natural join, Joined Tables
- IPC configuration, Shared Memory and Semaphores
- shared library, Compiling and Linking Dynamically-Loaded Functions
- start script, Starting the Database Server
- shared library, Compiling and Linking Dynamically-Loaded Functions
- IPC configuration, Shared Memory and Semaphores
- netmask, Network Address Functions and Operators
- network, Network Address Types, Network Address Functions and Operators
- data types, Network Address Types
- nextval, Sequence Manipulation Functions
- NFS, NFS
- nlevel, Operators and Functions
- non-durable, Non-Durable Settings
- nonblocking connection, Database Connection Control Functions, Asynchronous Command Processing
- nonrepeatable read, Transaction Isolation
- normalize, String Functions and Operators
- normalized, String Functions and Operators
- normal_rand, normal_rand
- NOT (operator), Logical Operators
- not a number
- NFS, NFS
- floating point, Floating-Point Types
- numeric (data type), Arbitrary Precision Numbers
- floating point, Floating-Point Types
- NOT IN, Subquery Expressions, Row and Array Comparisons
- not-null constraint, Not-Null Constraints
- notation, Calling Functions
- not-null constraint, Not-Null Constraints
- functions, Calling Functions
- notice processing, Notice Processing
- in libpq, Notice Processing
- notice processor, Notice Processing
- notice receiver, Notice Processing
- NOTIFY, Asynchronous Notification, NOTIFY
- notice receiver, Notice Processing
- in libpq, Asynchronous Notification
- NOTNULL, Comparison Functions and 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 Functions and 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
- comparing, Comparison Functions and Operators
- with check constraints, Check Constraints
- NULLIF, NULLIF
- nul_byte_replacement_on_import configuration parameter, Previous Postgres Pro Versions
- number
- nul_byte_replacement_on_import configuration parameter, Previous Postgres Pro Versions
- constant, Numeric Constants
- numeric, Numeric Constants
- numeric (data type), Arbitrary Precision Numbers
- numnode, Text Search Functions and Operators, Manipulating Queries
- num_nonnulls, Comparison Functions and Operators
- num_nulls, Comparison Functions and Operators
- NVL, COALESCE
- numeric (data type), Arbitrary Precision Numbers
O
- object identifier, Object Identifier Types
- data type, Object Identifier Types
- object-oriented database, Concepts
- obj_description, Comment Information Functions
- OCCURRENCES_REGEX, Differences from SQL Standard and XQuery
- octet_length, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators
- OFFSET, LIMIT and OFFSET
- oid, Object Identifier Types
- OID
- obj_description, Comment Information Functions
- in libpq, Retrieving Other Result Information
- oid2name, oid2name
- old_snapshot, old_snapshot — inspect old_snapshot_threshold state
- old_snapshot_threshold configuration parameter, Asynchronous Behavior
- ON CONFLICT, INSERT
- ONLY, The FROM Clause
- OOM, Linux Memory Overcommit
- OpenBSD
- old_snapshot, old_snapshot — inspect old_snapshot_threshold state
- IPC configuration, Shared Memory and Semaphores
- shared library, Compiling and Linking Dynamically-Loaded Functions
- start script, Starting the Database Server
- shared library, Compiling and Linking Dynamically-Loaded Functions
- IPC configuration, Shared Memory and Semaphores
- operator, Operators, Operator Precedence, Functions and Operators, Logical Operators, Operators, User-Defined Operators
- invocation, Operator Invocations
- logical, Logical Operators
- precedence, Operator Precedence
- syntax, Operators
- type resolution in an invocation, Operators
- user-defined, User-Defined Operators
- logical, Logical Operators
- invocation, Operator Invocations
- operator class, Operator Classes and Operator Families, Index Methods and Operator Classes
- operator family, Operator Classes and Operator Families, Operator Classes and Operator Families
- optimization information, Function Optimization Information, Operator Optimization Information
- operator family, Operator Classes and Operator Families, Operator Classes and Operator Families
- for functions, Function Optimization Information
- for operators, Operator Optimization Information
- for functions, Function Optimization Information
- OR (operator), Logical Operators
- Oracle, Porting from Oracle PL/SQL
- porting from PL/SQL to PL/pgSQL, Porting from Oracle PL/SQL
- ORDER BY, Querying a Table, Sorting Rows (ORDER BY)
- and locales, Behavior
- ordered-set aggregate, Aggregate Expressions
- built-in, Aggregate Functions
- ordering operator, System Dependencies on Operator Classes
- ordinality, Set Returning Functions
- outer join, Joined Tables
- output function, User-Defined Types
- OVER clause, Window Function Calls
- overcommit, Linux Memory Overcommit
- OVERLAPS, Date/Time Functions and Operators
- overlay, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators
- overloading, Function Overloading
- ordinality, Set Returning Functions
- functions, Function Overloading
- operators, User-Defined Operators
- functions, Function Overloading
- owner, Privileges
P
- pageinspect, pageinspect — low-level inspection of database pages
- pages_per_range storage parameter, Index Storage Parameters
- page_checksum, General Functions
- page_header, General Functions
- palloc, Writing Code
- PAM, PAM Authentication
- parallel query, Parallel Query
- parallel_leader_participation configuration parameter, Asynchronous Behavior
- parallel_setup_cost configuration parameter, Planner Cost Constants
- parallel_tuple_cost configuration parameter, Planner Cost Constants
- parallel_workers storage parameter, Storage Parameters
- parameter
- pages_per_range storage parameter, Index Storage Parameters
- syntax, Positional Parameters
- parenthesis, Value Expressions
- parse_ident, String Functions and Operators
- partition pruning, Partition Pruning
- partitioned table, Table Partitioning
- partitioning, Table Partitioning
- password, Role Attributes
- parse_ident, String Functions and Operators
- authentication, Password Authentication
- of the superuser, Creating a Database Cluster
- authentication, Password Authentication
- password file, The Password File
- passwordcheck, passwordcheck — verify password strength
- password_encryption configuration parameter, Authentication
- path, Geometric Functions and Operators
- passwordcheck, passwordcheck — verify password strength
- for schemas, Statement Behavior
- path (data type), Paths
- pattern matching, Pattern Matching
- patterns
- pattern matching, Pattern Matching
- in psql and pg_dump, Patterns
- pclose, Geometric Functions and Operators
- peer, Peer Authentication
- percentile
- peer, Peer Authentication
- continuous, Aggregate Functions
- discrete, Aggregate Functions
- continuous, Aggregate Functions
- percent_rank, Window Functions
- hypothetical, Aggregate Functions
- performance, Performance Tips
- Perl, PL/Perl — Perl Procedural Language
- permission (see privilege)
- pfree, Writing Code
- pg-setup, pg-setup
- pg-wrapper, pg-wrapper
- PGAPPNAME, Environment Variables
- pgbadger, pgbadger
- pgbench, pgbench
- pgbouncer, pgbouncer
- PGcancel, Canceling Queries in Progress
- PGCHANNELBINDING, Environment Variables
- PGCLIENTENCODING, Environment Variables
- PGconn, Database Connection Control Functions
- PGCONNECT_TIMEOUT, Environment Variables
- pgcrypto, pgcrypto — cryptographic functions
- PGDATA, Creating a Database Cluster
- PGDATABASE, Environment Variables
- PGDATESTYLE, Environment Variables
- PGEventProc, Event Callback Procedure
- PGGEQO, Environment Variables
- PGGSSDELEGATION, Environment Variables
- PGGSSENCMODE, Environment Variables
- PGGSSLIB, Environment Variables
- PGHOST, Environment Variables
- PGHOSTADDR, Environment Variables
- PGKRBSRVNAME, Environment Variables
- PGLOADBALANCEHOSTS, Environment Variables
- PGLOCALEDIR, Environment Variables
- PGOPTIONS, Environment Variables
- PGPASSFILE, Environment Variables
- PGPASSWORD, Environment Variables
- PGPORT, Environment Variables
- pgpro_build, Session Information Functions
- pgpro_build configuration parameter, Preset Options
- pgpro_controldata, pgpro_controldata
- pgpro_edition, Session Information Functions
- pgpro_edition configuration parameter, Preset Options
- pgpro_pwr, pgpro_pwr — workload reports
- pgpro_pwr.max configuration parameter, Setting Extension Parameters
- pgpro_pwr.max_query_length configuration parameter, Setting Extension Parameters
- pgpro_pwr.max_sample_age configuration parameter, Setting Extension Parameters
- pgpro_pwr.track_sample_timings configuration parameter, Setting Extension Parameters
- pgpro_stats, pgpro_stats — a means for tracking planning and execution statistics of all SQL statements executed by a server
- pgpro_stats_create_pg_stat_kcache_compatible_views
- Perl, PL/Perl — Perl Procedural Language
- pgpro_stats_create_pg_stat_statements_compatible_views
- pgpro_stats_metrics
- function, Functions
- pgpro_stats_statements
- function, Functions
- pgpro_stats_statements_reset, Functions
- pgpro_stats_totals
- function, Functions
- pgpro_stats_totals_reset, Functions
- pgpro_stats_trace_delete
- function, Session-Tracing Functions
- pgpro_stats_trace_insert
- function, Session-Tracing Functions
- pgpro_stats_trace_reset
- function, Session-Tracing Functions
- pgpro_stats_trace_show
- function, Session-Tracing Functions
- pgpro_stats_trace_update
- function, Session-Tracing Functions
- pgpro_stats_vacuum_indexes
- function, Functions
- pgpro_stats_vacuum_tables
- function, Functions
- pgpro_stats_wal_sender_crc_errors
- function, Functions
- pgpro_version, Session Information Functions
- pgpro_version configuration parameter, Preset Options
- pgp_armor_headers, pgp_armor_headers
- 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()
- PGREQUIREAUTH, Environment Variables
- PGREQUIREPEER, Environment Variables
- PGREQUIRESSL, Environment Variables
- PGresult, Main Functions
- pgrowlocks, pgrowlocks — show a table's row locking information, Overview
- PGSERVICE, Environment Variables
- PGSERVICEFILE, Environment Variables
- PGSSLCERT, Environment Variables
- PGSSLCERTMODE, Environment Variables
- PGSSLCOMPRESSION, Environment Variables
- PGSSLCRL, Environment Variables
- PGSSLCRLDIR, Environment Variables
- PGSSLKEY, Environment Variables
- PGSSLMAXPROTOCOLVERSION, Environment Variables
- PGSSLMINPROTOCOLVERSION, Environment Variables
- PGSSLMODE, Environment Variables
- PGSSLROOTCERT, Environment Variables
- PGSSLSNI, Environment Variables
- pgstatginindex, Functions
- pgstathashindex, Functions
- pgstatindex, Functions
- pgstattuple, pgstattuple — obtain tuple-level statistics, Functions
- pgstattuple_approx, Functions
- PGSYSCONFDIR, Environment Variables
- PGTARGETSESSIONATTRS, 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_amcheck, pg_amcheck
- 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_memory_contexts, pg_backend_memory_contexts
- pg_backend_pid, Session Information Functions
- pg_backup_start, Backup Control Functions
- pg_backup_stop, Backup Control Functions
- pg_basebackup, pg_basebackup
- pg_blocking_pids, Session Information Functions
- pg_buffercache, pg_buffercache — inspect Postgres Pro buffer cache state
- pg_buffercache_pages, pg_buffercache — inspect Postgres Pro buffer cache state
- pg_buffercache_summary, pg_buffercache — inspect Postgres Pro buffer cache state
- pg_cancel_backend, Server Signaling Functions
- pg_cast, pg_cast
- pg_char_to_encoding, System Catalog Information Functions
- pg_checksums, pg_checksums
- pg_class, pg_class
- pg_client_encoding, String Functions and Operators
- pg_collation, pg_collation
- pg_collation_actual_version, Database Object Management Functions
- pg_collation_is_visible, Schema Visibility Inquiry Functions
- PG_COLOR, When Color is Used
- PG_COLORS, Configuring the Colors
- pg_column_compression, Database Object Management Functions
- pg_column_size, Database Object Management Functions
- pg_config, pg_config, pg_config
- pgpro_version configuration parameter, Preset Options
- with ecpg, Processing Embedded SQL Programs
- with libpq, Building libpq Programs
- with user-defined C functions, Writing Code
- with libpq, Building libpq Programs
- with ecpg, Processing Embedded SQL Programs
- pg_conf_load_time, Session Information Functions
- pg_constraint, pg_constraint
- pg_controldata, pg_controldata
- pg_control_checkpoint, Control Data Functions
- pg_control_init, Control Data Functions
- pg_control_recovery, Control Data Functions
- pg_control_system, Control Data Functions
- pg_conversion, pg_conversion
- pg_conversion_is_visible, Schema Visibility Inquiry Functions
- pg_copy_logical_replication_slot, Replication Management Functions
- pg_copy_physical_replication_slot, Replication Management Functions
- pg_create_logical_replication_slot, Replication Management Functions
- pg_create_physical_replication_slot, Replication Management Functions
- pg_create_restore_point, Backup Control Functions
- pg_ctl, Creating a Database Cluster, Starting the Database Server, pg_ctl
- pg_current_logfile, Session Information Functions
- pg_current_snapshot, Transaction ID and Snapshot Information Functions
- pg_current_wal_flush_lsn, Backup Control Functions
- pg_current_wal_insert_lsn, Backup Control Functions
- pg_current_wal_lsn, Backup Control Functions
- pg_current_xact_id, Transaction ID and Snapshot Information Functions
- pg_current_xact_id_if_assigned, Transaction ID and Snapshot Information Functions
- pg_cursors, pg_cursors
- pg_database, Template Databases, pg_database
- pg_database_collation_actual_version, Database Object Management Functions
- pg_database_size, Database Object Management Functions
- pg_db_role_setting, pg_db_role_setting
- pg_ddl_command, Pseudo-Types
- pg_default_acl, pg_default_acl
- pg_depend, pg_depend
- pg_describe_object, Object Information and Addressing Functions
- pg_description, pg_description
- pg_drop_replication_slot, Replication Management Functions
- pg_dump, pg_dump
- pg_dumpall, pg_dumpall
- pg_constraint, pg_constraint
- use during upgrade, Upgrading Data via pg_dumpall
- pg_encoding_to_char, System Catalog Information Functions
- pg_enum, pg_enum
- pg_event_trigger, pg_event_trigger
- pg_event_trigger_ddl_commands, Capturing Changes at Command End
- pg_event_trigger_dropped_objects, Processing Objects Dropped by a DDL Command
- pg_event_trigger_table_rewrite_oid, Handling a Table Rewrite Event
- pg_event_trigger_table_rewrite_reason, Handling a Table Rewrite Event
- pg_export_snapshot, Snapshot Synchronization Functions
- pg_extension, pg_extension
- pg_extension_config_dump, Extension Configuration Tables
- pg_filedump, pg_filedump
- pg_filenode_relation, Database Object Management Functions
- pg_file_rename, adminpack — pgAdmin support toolpack
- pg_file_settings, pg_file_settings
- pg_file_sync, adminpack — pgAdmin support toolpack
- pg_file_unlink, adminpack — pgAdmin support toolpack
- pg_file_write, adminpack — pgAdmin support toolpack
- 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 — examine the free space map
- pg_function_is_visible, Schema Visibility Inquiry Functions
- pg_get_catalog_foreign_keys, System Catalog Information Functions
- pg_get_constraintdef, System Catalog Information Functions
- pg_get_expr, System Catalog Information Functions
- pg_get_functiondef, System Catalog Information Functions
- pg_get_function_arguments, System Catalog Information Functions
- pg_get_function_identity_arguments, System Catalog Information Functions
- pg_get_function_result, System Catalog Information Functions
- pg_get_indexdef, System Catalog Information Functions
- pg_get_keywords, System Catalog Information Functions
- pg_get_object_address, Object Information and Addressing Functions
- pg_get_partkeydef, System Catalog Information Functions
- pg_get_ruledef, System Catalog Information Functions
- pg_get_serial_sequence, System Catalog Information Functions
- pg_get_statisticsobjdef, System Catalog Information Functions
- pg_get_triggerdef, System Catalog Information Functions
- pg_get_userbyid, System Catalog Information Functions
- pg_get_viewdef, System Catalog Information Functions
- pg_get_wal_replay_pause_state, Recovery Control Functions
- pg_get_wal_resource_managers, Recovery Control Functions
- pg_group, pg_group
- pg_has_role, Access Privilege Inquiry Functions
- pg_hba.conf, The pg_hba.conf File
- pg_hba_file_rules, pg_hba_file_rules
- pg_ident.conf, User Name Maps
- pg_identify_object, Object Information and Addressing Functions
- pg_identify_object_as_address, Object Information and Addressing Functions
- pg_ident_file_mappings, pg_ident_file_mappings
- pg_import_system_collations, Database Object Management Functions
- pg_index, pg_index
- pg_indexam_has_property, System Catalog Information Functions
- pg_indexes, pg_indexes
- pg_indexes_size, Database Object Management Functions
- pg_index_column_has_property, System Catalog Information Functions
- pg_index_has_property, System Catalog Information Functions
- pg_inherits, pg_inherits
- pg_init_privs, pg_init_privs
- pg_input_error_info, Data Validity Checking Functions
- pg_input_is_valid, Data Validity Checking Functions
- pg_integrity_check, pg_integrity_check
- pg_isready, pg_isready
- pg_is_in_recovery, Recovery Control Functions
- pg_is_other_temp_schema, Session Information Functions
- pg_is_wal_replay_paused, Recovery Control Functions
- pg_jit_available, Session Information Functions
- pg_language, pg_language
- pg_largeobject, pg_largeobject
- pg_largeobject_metadata, pg_largeobject_metadata
- pg_last_committed_xact, Committed Transaction Information Functions
- pg_last_wal_receive_lsn, Recovery Control Functions
- pg_last_wal_replay_lsn, Recovery Control Functions
- pg_last_xact_replay_timestamp, Recovery Control Functions
- pg_listening_channels, Session Information Functions
- pg_locks, pg_locks
- pg_logdir_ls, adminpack — pgAdmin support toolpack
- pg_logical_emit_message, Replication Management Functions
- pg_logical_slot_get_binary_changes, Replication Management Functions
- pg_logical_slot_get_changes, Replication Management Functions
- pg_logical_slot_peek_binary_changes, Replication Management Functions
- pg_logical_slot_peek_changes, Replication Management Functions
- pg_log_backend_memory_contexts, Server Signaling Functions
- pg_log_standby_snapshot, Snapshot Synchronization Functions
- pg_lsn, pg_lsn Type
- pg_ls_archive_statusdir, Generic File Access Functions
- pg_ls_dir, Generic File Access Functions
- pg_ls_logdir, Generic File Access Functions
- pg_ls_logicalmapdir, Generic File Access Functions
- pg_ls_logicalsnapdir, Generic File Access Functions
- pg_ls_replslotdir, Generic File Access Functions
- pg_ls_tmpdir, Generic File Access Functions
- pg_ls_waldir, Generic File Access Functions
- pg_matviews, pg_matviews
- pg_mcv_list_items, Inspecting MCV Lists
- pg_my_temp_schema, Session Information Functions
- pg_namespace, pg_namespace
- pg_notification_queue_usage, Session Information Functions
- pg_notify, pg_notify
- pg_opclass, pg_opclass
- pg_opclass_is_visible, Schema Visibility Inquiry Functions
- pg_operation_log, Operation Log Support Functions
- pg_operator, pg_operator
- pg_operator_is_visible, Schema Visibility Inquiry Functions
- pg_opfamily, pg_opfamily
- pg_opfamily_is_visible, Schema Visibility Inquiry Functions
- pg_options_to_table, System Catalog Information Functions
- pg_parameter_acl, pg_parameter_acl
- pg_partitioned_table, pg_partitioned_table
- pg_partition_ancestors, Database Object Management Functions
- pg_partition_root, Database Object Management Functions
- pg_partition_tree, Database Object Management Functions
- pg_policies, pg_policies
- pg_policy, pg_policy
- pg_postmaster_start_time, Session Information Functions
- pg_prepared_statements, pg_prepared_statements
- pg_prepared_xacts, pg_prepared_xacts
- pg_prewarm, pg_prewarm — preload relation data into buffer caches
- pg_prewarm.autoprewarm configuration parameter, Configuration Parameters
- pg_prewarm.autoprewarm_interval configuration parameter, Configuration Parameters
- pg_proaudit.log_catalog_access configuration parameter, Security Event Log Configuration Parameters
- pg_proaudit.log_command_text configuration parameter, Security Event Log Configuration Parameters
- pg_proaudit.log_destination configuration parameter, Security Event Log Configuration Parameters
- pg_proaudit.log_directory configuration parameter, Security Event Log Configuration Parameters
- pg_proaudit.log_filename configuration parameter, Security Event Log Configuration Parameters
- pg_proaudit.log_rotation_age configuration parameter, Security Event Log Configuration Parameters
- pg_proaudit.log_rotation_size configuration parameter, Security Event Log Configuration Parameters
- pg_proaudit.log_truncate_on_rotation configuration parameter, Security Event Log Configuration Parameters
- pg_proaudit.max_rules_count configuration parameter, Security Event Log Configuration Parameters
- pg_probackup, pg_probackup
- pg_proc, pg_proc
- pg_profile, pg_profile
- pg_promote, Recovery Control Functions
- pg_publication, pg_publication
- pg_publication_namespace, pg_publication_namespace
- pg_publication_rel, pg_publication_rel
- pg_publication_tables, pg_publication_tables
- pg_range, pg_range
- pg_read_binary_file, Generic File Access Functions
- pg_read_file, Generic File Access Functions
- pg_receivewal, pg_receivewal
- pg_receivexlog, pg_receivexlog renamed to pg_receivewal (see pg_receivewal)
- 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_repack, pg_repack
- pg_replication_origin, pg_replication_origin
- pg_replication_origin_advance, Replication Management Functions
- pg_replication_origin_create, Replication Management Functions
- pg_replication_origin_drop, Replication Management Functions
- pg_replication_origin_oid, Replication Management Functions
- pg_replication_origin_progress, Replication Management Functions
- pg_replication_origin_session_is_setup, Replication Management Functions
- pg_replication_origin_session_progress, Replication Management Functions
- pg_replication_origin_session_reset, Replication Management Functions
- pg_replication_origin_session_setup, Replication Management Functions
- pg_replication_origin_status, pg_replication_origin_status
- pg_replication_origin_xact_reset, Replication Management Functions
- pg_replication_origin_xact_setup, Replication Management Functions
- pg_replication_slots, pg_replication_slots
- pg_replication_slot_advance, Replication Management Functions
- pg_resetwal, pg_resetwal
- pg_resetxlog, pg_resetxlog renamed to pg_resetwal (see pg_resetwal)
- pg_restore, pg_restore
- pg_rewind, pg_rewind
- pg_rewrite, pg_rewrite
- pg_roles, pg_roles
- pg_role_password, pg_role_password
- pg_rotate_logfile, Server Signaling Functions
- pg_rules, pg_rules
- pg_safe_snapshot_blocking_pids, Session Information Functions
- pg_seclabel, pg_seclabel
- pg_seclabels, pg_seclabels
- pg_sequence, pg_sequence
- pg_sequences, pg_sequences
- pg_service.conf, The Connection Service File
- pg_settings, pg_settings
- pg_settings_get_flags, System Catalog Information Functions
- pg_shadow, pg_shadow
- pg_shdepend, pg_shdepend
- pg_shdescription, pg_shdescription
- pg_shmem_allocations, pg_shmem_allocations
- pg_shseclabel, pg_shseclabel
- pg_size_bytes, Database Object Management Functions
- pg_size_pretty, Database Object Management Functions
- pg_sleep, Delaying Execution
- pg_sleep_for, Delaying Execution
- pg_sleep_until, Delaying Execution
- pg_snapshot_any, Debugging Functions
- pg_snapshot_xip, Transaction ID and Snapshot Information Functions
- pg_snapshot_xmax, Transaction ID and Snapshot Information Functions
- pg_snapshot_xmin, Transaction ID and Snapshot Information Functions
- pg_split_walfile_name, Backup Control Functions
- pg_statio_all_indexes, Viewing Statistics, pg_statio_all_indexes
- pg_statio_all_sequences, Viewing Statistics, pg_statio_all_sequences
- pg_statio_all_tables, Viewing Statistics, pg_statio_all_tables
- pg_statio_sys_indexes, Viewing Statistics
- pg_statio_sys_sequences, Viewing Statistics
- pg_statio_sys_tables, Viewing Statistics
- pg_statio_user_indexes, Viewing Statistics
- pg_statio_user_sequences, Viewing Statistics
- pg_statio_user_tables, Viewing Statistics
- pg_statistic, Single-Column Statistics, pg_statistic
- pg_statistics_obj_is_visible, Schema Visibility Inquiry Functions
- pg_statistic_ext, Extended Statistics, pg_statistic_ext
- pg_statistic_ext_data, Extended Statistics, pg_statistic_ext
- pg_stats, Single-Column Statistics, pg_stats
- pg_stats_ext, pg_stats_ext
- pg_stats_ext_exprs, pg_stats_ext_exprs
- pg_stats_vacuum_database, pg_stats_vacuum_database
- pg_stats_vacuum_indexes, pg_stats_vacuum_indexes
- pg_stats_vacuum_tables, pg_stats_vacuum_tables
- pg_stat_activity, Viewing Statistics, pg_stat_activity
- pg_stat_all_indexes, Viewing Statistics, pg_stat_all_indexes
- pg_stat_all_tables, Viewing Statistics, pg_stat_all_tables
- pg_stat_archiver, Viewing Statistics, pg_stat_archiver
- pg_stat_bgwriter, Viewing Statistics, pg_stat_bgwriter
- pg_stat_clear_snapshot, Statistics Functions
- pg_stat_database, Viewing Statistics, pg_stat_database
- pg_stat_database_conflicts, Viewing Statistics, pg_stat_database_conflicts
- pg_stat_file, Generic File Access Functions
- pg_stat_get_activity, Statistics Functions
- pg_stat_get_backend_activity, Statistics Functions
- pg_stat_get_backend_activity_start, Statistics Functions
- pg_stat_get_backend_client_addr, Statistics Functions
- pg_stat_get_backend_client_port, Statistics Functions
- pg_stat_get_backend_dbid, Statistics Functions
- pg_stat_get_backend_idset, Statistics Functions
- pg_stat_get_backend_pid, Statistics Functions
- pg_stat_get_backend_start, Statistics Functions
- pg_stat_get_backend_subxact, Statistics Functions
- pg_stat_get_backend_userid, Statistics Functions
- pg_stat_get_backend_wait_event, Statistics Functions
- pg_stat_get_backend_wait_event_type, Statistics Functions
- pg_stat_get_backend_xact_start, Statistics Functions
- pg_stat_get_snapshot_timestamp, Statistics Functions
- pg_stat_get_xact_blocks_fetched, Statistics Functions
- pg_stat_get_xact_blocks_hit, Statistics Functions
- pg_stat_gssapi, Viewing Statistics, pg_stat_gssapi
- pg_stat_io, Viewing Statistics, pg_stat_io
- pg_stat_progress_analyze,
- pg_enum, pg_enum