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, Numeric Functions
- 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, Trigonometric Functions
- acosd, Mathematical Functions and Operators
- acosh, Mathematical Functions and Operators
- adaptive query execution, Adaptive Query Execution
- add_cookies, HTTP Cookies
- add_rule, Rule Management Functions
- administration tools
- ABORT, ABORT
- externally maintained, Administration Tools
- advisory lock, Advisory Locks
- age, Date/Time Functions and Operators, Transaction ID and Snapshot Information Functions
- aggregate function, Aggregate Functions, Aggregate Expressions, Aggregate Functions, User-Defined Aggregates
- age, Date/Time Functions and Operators, Transaction ID and Snapshot Information Functions
- 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
- 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_alter_system configuration parameter, Platform and Client Compatibility
- 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
- alter_columnar_table_set function, Table and Shard DDL
- alter_distributed_table function, Table and Shard DDL
- alter_old_partitions_set_access_method procedure, Table and Shard DDL
- ALTER_QUEUE, Queue Management Procedures
- ALTER_REPLICATION_SLOT, Streaming Replication Protocol
- alter_table_set_access_method function, Table and Shard DDL
- amcheck, amcheck — tools to verify table and index consistency
- ANALYZE, Updating Planner Statistics, ANALYZE
- AND (operator), Logical Operators
- anon.algorithm, Configuration
- anon.dnoise, Adding Noise
- anon.fake_address, Faking
- anon.fake_city, Faking
- anon.fake_company, Faking
- anon.fake_country, Faking
- anon.fake_email, Faking
- anon.fake_first_name, Faking
- anon.fake_iban, Faking
- anon.fake_last_name, Faking
- anon.fake_postcode, Faking
- anon.lorem_ipsum, Faking
- anon.maskschema, Configuration
- anon.noise, Adding Noise
- anon.random_date, Basic Random values
- anon.random_phone, Basic Random values
- anon.random_string, Basic Random values
- anon.random_zip, Basic Random values
- anon.restrict_to_trusted_schemas, Configuration
- anon.salt, Configuration
- anon.sourceshema, Configuration
- 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
- append, Operations with Multiple LOBs
- applicable role, applicable_roles
- application_name configuration parameter, What to Log
- ap_enable_automatic_partition_creation, Functions
- 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_in_place_tablespaces 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, Trigonometric Functions
- 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 LOCAL, AT TIME ZONE and AT LOCAL
- AT TIME ZONE, AT TIME ZONE and AT LOCAL
- atan, Mathematical Functions and Operators, Trigonometric Functions
- atan2, Mathematical Functions and Operators, Trigonometric Functions
- atan2d, Mathematical Functions and Operators
- atand, Mathematical Functions and Operators
- atanh, Mathematical Functions and Operators
- auth, utl_smtp Functions
- 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 LOCAL, AT TIME ZONE and AT LOCAL
- bulk-loading data, Disable Autocommit
- psql, Variables
- bulk-loading data, Disable Autocommit
- autoprepared statements, Autoprepared Statements
- autoprepare_for_protocol configuration parameter, Other Planner Options
- autoprepare_limit configuration parameter, Other Planner Options
- autoprepare_memory_limit configuration parameter, Other Planner Options
- autoprepare_threshold configuration parameter, Other Planner Options
- autosummarize storage parameter, Index Storage Parameters
- autovacuum
- autoprepare_for_protocol configuration parameter, Other Planner Options
- 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, Aggregation 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
- begin_request, HTTP Requests
- BETWEEN, Comparison Functions and Operators
- BETWEEN SYMMETRIC, Comparison Functions and Operators
- bfilename, Utility Functions
- 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
- biha.autorewind configuration parameter, Cluster Configuration
- biha.BcpTransportDebug_log_level configuration parameter, biha Logging Levels
- biha.BcpTransportDetails_log_level configuration parameter, biha Logging Levels
- biha.BcpTransportLog_log_level configuration parameter, biha Logging Levels
- biha.BcpTransportWarn_log_level configuration parameter, biha Logging Levels
- biha.BihaLog_log_level configuration parameter, biha Logging Levels
- biha.callbacks_timeout configuration parameter, Cluster Configuration
- biha.can_be_leader configuration parameter, Cluster Configuration
- biha.can_vote configuration parameter, Cluster Configuration
- biha.config function, Cluster Configuration
- biha.error_details function, The NODE_ERROR State
- biha.flw_ro configuration parameter, Cluster Configuration
- biha.get_magic_string function, Magic String Generation
- biha.heartbeat_max_lost configuration parameter, Cluster Configuration
- biha.heartbeat_send_period configuration parameter, Cluster Configuration
- biha.host configuration parameter, Cluster Configuration
- biha.id configuration parameter, Cluster Configuration
- biha.minnodes configuration parameter, Cluster Configuration
- biha.NodeControllerDebug_log_level configuration parameter, biha Logging Levels
- biha.NodeControllerDetails_log_level configuration parameter, biha Logging Levels
- biha.NodeControllerLog_log_level configuration parameter, biha Logging Levels
- biha.NodeControllerWarn_log_level configuration parameter, biha Logging Levels
- biha.nodes function, Cluster Monitoring
- biha.node_priority configuration parameter, Cluster Configuration
- biha.no_wal_on_follower configuration parameter, Cluster Configuration
- biha.nquorum configuration parameter, Cluster Configuration
- biha.port configuration parameter, Cluster Configuration
- biha.register_callback function, Callback Management
- biha.remove_node function, Cluster Node Removal
- biha.set_heartbeat_max_lost function, Cluster Configuration
- biha.set_heartbeat_send_period function, Cluster Configuration
- biha.set_leader function, Setting the Leader Manually
- biha.set_minnodes function, Cluster Configuration
- biha.set_no_wal_on_follower function, Cluster Configuration
- biha.set_nquorum function, Cluster Configuration
- biha.set_nquorum_and_minnodes function, Cluster Configuration
- biha.set_sync_standbys_min function, Cluster Configuration
- biha.status function, Cluster Monitoring
- biha.sync_standbys_min configuration parameter, Cluster Configuration
- biha.unregister_callback function, Callback Management
- bihactl, bihactl
- binary data, Binary Data Types, Binary String Functions and Operators
- begin_request, HTTP Requests
- 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 SQL queries, Canceling Queries in Progress
- cardinality, Array Functions and Operators
- CASCADE, Dependency Tracking
- C++, Using C++ for Extensibility
- 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, Numeric Functions
- ceiling, Mathematical Functions and Operators
- center, Geometric Functions and Operators
- Certificate, Certificate Authentication
- cfs_compression_ratio, Compression Control Functions
- cfs_compress_temp_relations configuration parameter, Data Compression
- cfs_enable_gc, Compression Control Functions
- cfs_estimate, Compression Control Functions
- cfs_fragmentation, Compression Control Functions
- cfs_gc configuration parameter, Data Compression
- cfs_gc_activity_processed_bytes, Compression Control Functions
- cfs_gc_activity_processed_files, Compression Control Functions
- cfs_gc_activity_processed_pages, Compression Control Functions
- cfs_gc_activity_scanned_files, Compression Control Functions
- cfs_gc_delay configuration parameter, Data Compression
- cfs_gc_lock_file configuration parameter, Data Compression
- cfs_gc_period configuration parameter, Data Compression
- cfs_gc_relation, Compression Control Functions
- cfs_gc_respond_time configuration parameter, Data Compression
- cfs_gc_threshold configuration parameter, Data Compression
- cfs_gc_time_bloom_false_positive configuration parameter, Data Compression
- cfs_gc_time_bloom_passed configuration parameter, Data Compression
- cfs_gc_time_bloom_query configuration parameter, Data Compression
- cfs_gc_workers configuration parameter, Data Compression
- cfs_level configuration parameter, Data Compression
- cfs_log_verbose configuration parameter, Data Compression
- cfs_start_gc, Compression Control Functions
- cfs_version, Compression Control Functions
- chained transactions, Transaction Management, Parameters, Parameters
- ceil, Mathematical Functions and Operators, Numeric Functions
- 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
- citus.all_modifications_commutative configuration parameter, Executor Configuration
- citus.cluster_name configuration parameter, General Configuration
- citus.count_distinct_error_rate configuration parameter, Planner Configuration
- citus.distributed_deadlock_detection_factor configuration parameter, General Configuration
- citus.enable_binary_protocol configuration parameter, Executor Configuration
- citus.enable_change_data_capture configuration parameter, DDL
- citus.enable_ddl_propagation configuration parameter, DDL
- citus.enable_local_reference_table_foreign_keys configuration parameter, DDL
- citus.enable_non_colocated_router_query_pushdown configuration parameter, Planner Configuration
- citus.enable_repartitioned_insert_select configuration parameter, Executor Configuration
- citus.enable_repartition_joins configuration parameter, Executor Configuration
- citus.enable_schema_based_sharding configuration parameter, DDL
- citus.enable_version_checks configuration parameter, General Configuration
- citus.executor_slow_start_interval configuration parameter, Executor Configuration
- citus.explain_all_tasks configuration parameter, Executor Configuration
- citus.explain_analyze_sort_method configuration parameter, Executor Configuration
- citus.force_max_query_parallelization configuration parameter, Executor Configuration
- citus.limit_clause_row_fetch_count configuration parameter, Planner Configuration
- citus.local_hostname configuration parameter, General Configuration
- citus.local_table_join_policy configuration parameter, Planner Configuration
- citus.log_distributed_deadlock_detection configuration parameter, General Configuration
- citus.max_adaptive_executor_pool_size configuration parameter, Executor Configuration
- citus.max_background_task_executors_per_node configuration parameter, General Configuration
- citus.max_cached_conns_per_worker configuration parameter, Executor Configuration
- citus.max_intermediate_result_size configuration parameter, Intermediate Data Transfer
- citus.max_shared_pool_size configuration parameter, Executor Configuration
- citus.max_worker_nodes_tracked configuration parameter, General Configuration
- citus.metadata_sync_mode configuration parameter, Data Loading
- citus.multi_task_query_log_level configuration parameter, Executor Configuration
- citus.node_connection_timeout configuration parameter, General Configuration
- citus.node_conninfo configuration parameter, General Configuration
- citus.propagate_set_commands configuration parameter, Executor Configuration
- citus.rebalancer_by_disk_size_base_cost configuration parameter, General Configuration
- citus.shard_count configuration parameter, Data Loading
- citus.show_shards_for_app_name_prefixes configuration parameter, General Configuration
- citus.stat_statements_max configuration parameter, Query Statistics
- citus.stat_statements_purge_interval configuration parameter, Query Statistics
- citus.stat_statements_track configuration parameter, Query Statistics
- citus.stat_tenants_untracked_sample_rate configuration parameter, Query Statistics
- citus.task_assignment_policy configuration parameter, Planner Configuration
- citus.use_secondary_nodes configuration parameter, General Configuration
- citus_activate_node function, Metadata / Configuration Information
- citus_add_inactive_node function, Metadata / Configuration Information
- citus_add_local_table_to_metadata function, Table and Shard DDL
- citus_add_node function, Metadata / Configuration Information
- citus_add_rebalance_strategy function, Cluster Management And Repair Functions
- citus_add_secondary_node function, Metadata / Configuration Information
- citus_backend_gpid function, Metadata / Configuration Information
- citus_check_cluster_node_health function, Metadata / Configuration Information
- citus_create_restore_point function, Cluster Management And Repair Functions
- citus_disable_node function, Metadata / Configuration Information
- citus_drain_node function, Cluster Management And Repair Functions
- citus_get_active_worker_nodes function, Metadata / Configuration Information
- citus_move_shard_placement function, Cluster Management And Repair Functions
- citus_rebalance_start function, Cluster Management And Repair Functions
- citus_rebalance_status function, Cluster Management And Repair Functions
- citus_rebalance_stop function, Cluster Management And Repair Functions
- citus_rebalance_wait function, Cluster Management And Repair Functions
- citus_relation_size function, Metadata / Configuration Information
- citus_remote_connection_stats function, Cluster Management And Repair Functions
- citus_remove_node function, Metadata / Configuration Information
- citus_schema_distribute function, Table and Shard DDL
- citus_schema_undistribute function, Table and Shard DDL
- citus_set_coordinator_host function, Metadata / Configuration Information
- citus_set_default_rebalance_strategy function, Cluster Management And Repair Functions
- citus_set_node_property function, Metadata / Configuration Information
- citus_stat_statements_reset function, Metadata / Configuration Information
- citus_table_size function, Metadata / Configuration Information
- citus_total_relation_size function, Metadata / Configuration Information
- citus_update_node function, Metadata / Configuration Information
- clear_cookies, HTTP Cookies
- 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
- close, Opening and Closing LOBs
- close_all_connections, utl_smtp Functions
- close_connection, utl_smtp Functions
- close_data, utl_smtp Functions
- 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
- coalesce, Scalar Functions
- 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
- column_to_column_name function, Metadata / Configuration Information
- col_description, Comment Information Functions
- command, utl_smtp Functions
- comment, Comments
- column_to_column_name function, Metadata / Configuration Information
- 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
- commit_timestamp_buffers configuration parameter, Memory
- common table expression (see WITH)
- compare, Operations with Multiple LOBs
- 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
- converttoblob, Operations with Multiple LOBs
- converttoclob, Operations with Multiple LOBs
- 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
- copy, Operations with Multiple LOBs
- corr, Aggregate Functions
- correlation, Aggregate Functions
- corr, Aggregate Functions
- in the query planner, Extended Statistics
- cos, Mathematical Functions and Operators, Trigonometric Functions
- cosd, Mathematical Functions and Operators
- cosh, Mathematical Functions and Operators
- cot, Mathematical Functions and Operators, Trigonometric Functions
- cotd, Mathematical Functions and Operators
- count, Aggregate Functions, Aggregation 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 PACKAGE, CREATE PACKAGE
- 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
- createtemporary, Opening and Closing LOBs
- createuser, Database Roles, createuser
- create_baseline, Baseline Management Functions
- create_distributed_function function, Table and Shard DDL
- create_distributed_table function, Table and Shard DDL
- create_graph, Create a Graph
- create_projection(), Conversion Functions
- CREATE_QUEUE, Queue Management Procedures
- create_reference_table function, Table and Shard DDL
- CREATE_REPLICATION_SLOT, Streaming Replication Protocol
- create_server, Server Management Functions
- create_time_partitions function, Table and Shard DDL
- cross join, Joined Tables
- crosstab, crosstab(text), crosstabN(text), crosstab(text, text)
- crypt, crypt()
- cstring, Pseudo-Types
- CSV (Comma-Separated Values) format
- createuser, Database Roles, createuser
- 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
- cypher, The apache_age Cypher Query Format
D
- daitch_mokotoff, Daitch-Mokotoff Soundex
- data, utl_smtp Functions
- 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, utl_smtp Functions
- 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 — 1C module for updating database copies
- 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
- 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, Trigonometric Functions
- delay, Delaying Execution
- DELETE, Deletions, Deleting Data, Returning Data from Modified Rows, DELETE
- degrees, Mathematical Functions and Operators, Trigonometric Functions
- 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 PACKAGE, DROP PACKAGE
- 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_graph, Delete a Graph
- drop_old_time_partitions procedure, Table and Shard DDL
- drop_projection(), Conversion Functions
- DROP_QUEUE, Queue Management Procedures
- 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
- e, Logarithmic Functions
- 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
- ehlo, utl_smtp Functions
- elog
- each, hstore Operators and Functions
- 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
- empty_blob, Utility Functions
- 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_extra_transformations 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_large_mem_buffers configuration parameter, Previous Postgres Pro Versions
- 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
- enabled role, enabled_roles
- 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
- endNode, Scalar Functions
- end_id, Scalar Functions
- end_request, HTTP Requests
- end_response, HTTP Responses
- 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
- erase, Updating LOBs
- erf, Mathematical Functions and Operators
- erfc, Mathematical Functions and Operators
- error codes, Postgres Pro Error Codes
- erf, Mathematical Functions and Operators
- libpq, Main Functions
- list of, Postgres Pro Error Codes
- libpq, Main Functions
- error message
- in PGcancelConn, Functions for Sending Cancel Requests
- in PGconn, Connection Status Functions
- in PGcancelConn, Functions for Sending Cancel Requests
- 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 string syntax, String Constants with C-Style Escapes
- 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
- event_triggers
- event_trigger, Pseudo-Types
- configuration parameter, Statement Behavior
- every, Aggregate Functions
- EXCEPT, Combining Queries (UNION, INTERSECT, EXCEPT)
- exceptions
- EXCEPT, Combining Queries (UNION, INTERSECT, EXCEPT)
- 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
- exists, Predicate Functions
- EXIT
- EXECUTE, EXECUTE
- in PL/pgSQL, EXIT
- exit_on_error configuration parameter, Error Handling
- exp, Mathematical Functions and Operators, Logarithmic Functions
- EXPLAIN, Using EXPLAIN, EXPLAIN
- export_data, Export and Import Functions
- expression, Value Expressions
- exp, Mathematical Functions and Operators, Logarithmic Functions
- 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
- fileclose, Legacy API
- filecloseall, Legacy API
- fileexists, Legacy API
- filegetname, Legacy API
- fileisopen, Legacy API
- fileopen, Legacy API
- 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, Numeric Functions
- 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
- freetemporary, Opening and Closing LOBs
- 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
- from_collapse_limit configuration parameter, Other Planner Options
- 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
- getchunksize, Other Operations
- getcontenttype, Other Operations
- getlength, Reading LOBs
- get_authentication, HTTP Responses
- get_bit, Binary String Functions and Operators, Bit String Functions and Operators
- get_byte, Binary String Functions and Operators
- get_cookies, HTTP Cookies
- get_cookie_count, HTTP Cookies
- get_current_ts_config, Text Search Functions and Operators
- get_detailed_excp_support, Session Settings
- get_detailed_sqlcode, Error Conditions
- get_detailed_sqlerrm, Error Conditions
- get_diffreport, Differential Reports
- get_exclude_users, Exclusion-List Management Functions
- get_header, HTTP Responses
- get_header_by_name, HTTP Responses
- get_header_count, HTTP Responses
- get_namespace, Functions
- GET_QUEUE_TABLE, Queue Management Procedures
- get_raw_page, General Functions
- get_rebalance_progress function, Cluster Management And Repair Functions
- get_rebalance_table_shards_plan function, Cluster Management And Repair Functions
- get_report, Regular Reports
- get_report_latest, Regular Reports
- get_response, HTTP Responses
- get_response_error_check, Session Settings
- get_rules, Rule Management Functions
- get_shard_id_for_distribution_column function, Metadata / Configuration Information
- get_storage_limit, Reading LOBs
- get_transfer_timeout, Session Settings
- 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
- head, Scalar Functions
- heap_page_items, Heap Functions
- heap_page_item_attrs, Heap Functions
- heap_tuple_infomask_flags, Heap Functions
- height, Geometric Functions and Operators
- helo, utl_smtp Functions
- help, utl_smtp Functions
- 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_pages_status configuration parameter, Preset Options
- huge_page_size configuration parameter, Memory
- Hunspell Dictionaries, Hunspell Dictionaries Modules
- hypopg, Manipulate Hypothetical Indexes
- hypopg.enabled configuration parameter, GUC Parameters
- hypopg.use_real_oids configuration parameter, GUC Parameters
- hypopg_create_index, Create a Hypothetical Index
- hypopg_drop_index, Manipulate Hypothetical Indexes
- hypopg_get_indexdef, Manipulate Hypothetical Indexes
- hypopg_hidden_indexes, Hypothetically Hide Existing Indexes
- hypopg_hide_index, Hypothetically Hide Existing Indexes
- hypopg_relation_size, Manipulate Hypothetical Indexes
- hypopg_reset, Manipulate Hypothetical Indexes
- hypopg_unhide_all_index, Hypothetically Hide Existing Indexes
- hypopg_unhide_index, Hypothetically Hide Existing Indexes
- 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_unicode_version, Version Information Functions
- icu_validation_level configuration parameter, Locale and Formatting
- id, Scalar Functions
- 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
- identity column, Identity Columns
- 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(), Conversion Functions
- import_data, Export and Import Functions
- IN, Subquery Expressions, Row and Array Comparisons
- INCLUDE
- identity column, Identity Columns
- 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
- initplan, EXPLAIN Basics
- 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
- INSERT_MESSAGE, Procedures for Inserting Messages
- instr, Reading LOBs
- 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
- INSERT_MESSAGE, Procedures for Inserting Messages
- 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_memory.in_memory_page_stats(), Functions
- in_memory.shared_pool_size in-memory parameter, Configuration Variables
- in_memory.undo_size in-memory parameter, Configuration Variables
- in_range support functions, B-Tree Support Functions
- io_combine_limit configuration parameter, Asynchronous Behavior
- 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
- isolate_tenant_to_new_shard function, Cluster Management And Repair Functions
- isopen, Geometric Functions and Operators, Opening and Closing LOBs
- 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_populate_record_valid, 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, SQL/JSON Query Functions
- 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, SQL/JSON Query Functions
- 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, SQL/JSON Query Functions
- 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
- keys, List Functions
- krb_caseins_users configuration parameter, Authentication
- krb_server_keyfile configuration parameter, Authentication
- krb_caseins_users configuration parameter, Authentication
L
- label (see alias)
- labels, List Functions
- lag, Window Functions
- language_handler, Pseudo-Types
- large object, Large Objects
- last, Scalar Functions
- lastval, Sequence Manipulation Functions
- last_reply, utl_smtp Functions
- last_value, Window Functions
- LATERAL, LATERAL Subqueries
- labels, List 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, String Functions
- 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, Scalar Functions
- 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 in Chunks, Retrieving Query Results in Chunks
- chunked mode, Retrieving Query Results in Chunks
- pipeline mode, Pipeline Mode
- single-row mode, Retrieving Query Results in Chunks
- pipeline mode, Pipeline Mode
- chunked mode, Retrieving Query Results in Chunks
- 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
- loadblobfromfile, Other Operations
- loadclobfromfile, Other Operations
- loadfromfile, Legacy API
- 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, Logarithmic Functions
- log shipping, High Availability, Load Balancing, and Replication
- log10, Mathematical Functions and Operators, Logarithmic Functions
- log2_num_lock_partitions configuration parameter, Lock Management
- 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_next_xid_assign_threshold configuration parameter, What 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
- lTrim, String Functions
- lwlock_shared_limit configuration parameter, Lock Management
- 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
- mail, utl_smtp Functions
- 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
- mail, utl_smtp Functions
- implementation through rules, Materialized Views
- materialized views, pg_matviews
- max, Aggregate Functions, Aggregation Functions
- max_autonomous_transactions configuration parameter, Memory
- max_backend_memory configuration parameter, Disk
- 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_notify_queue_pages configuration parameter, Disk
- 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, Aggregation 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, Returning Data from Modified Rows, MERGE
- merge_action, Merge Support Functions
- metaphone, Metaphone
- min, Aggregate Functions, Aggregation 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
- metaphone, Metaphone
- statistical, Aggregate Functions
- monitoring, Monitoring Database Activity
- database activity, Monitoring Database Activity
- MOVE, MOVE
- moving-aggregate mode, Moving-Aggregate Mode
- mtm.add_node, Functions
- mtm.alter_sequences, Functions
- mtm.check_query, Functions
- mtm.drop_node, Functions
- mtm.free_snapshots, Functions
- mtm.get_snapshots, Functions
- mtm.init_cluster, Functions
- mtm.join_node, Functions
- mtm.make_table_local, Functions
- mtm.nodes(), Functions
- mtm.status(), Functions
- multimaster.binary_basetypes, Configuration Parameters
- multimaster.break_connection, Configuration Parameters
- multimaster.catchup_algorithm, Configuration Parameters
- multimaster.connect_timeout, Configuration Parameters
- multimaster.deadlock_prevention, Configuration Parameters
- multimaster.enable_async_3pc_on_catchup, Configuration Parameters
- multimaster.heartbeat_recv_timeout, Configuration Parameters
- multimaster.heartbeat_send_timeout, Configuration Parameters
- multimaster.ignore_tables_without_pk, Configuration Parameters
- multimaster.max_tx_delay_on_slow_catchup, Configuration Parameters
- multimaster.max_workers, Configuration Parameters
- multimaster.monotonic_sequences, Configuration Parameters
- multimaster.parallel_catchup_workers, Configuration Parameters
- multimaster.referee_connstring, Configuration Parameters
- multimaster.remote_functions, Configuration Parameters
- multimaster.syncpoint_interval, Configuration Parameters
- multimaster.trans_spill_threshold, Configuration Parameters
- multimaster.tx_delay_on_slow_catchup, Configuration Parameters
- multimaster.wait_peer_commits, Configuration Parameters
- multirange (function), Range/Multirange Functions and Operators
- multirange type, Range Types
- Multiversion Concurrency Control, Introduction
- MultiXactId, Shrinking pg_multixact
- multixact_member_buffers configuration parameter, Memory
- multixact_offset_buffers configuration parameter, Memory
- MVCC, Introduction
- mxid_age, Transaction ID and Snapshot Information 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
- nodes, List Functions
- non-durable, Non-Durable Settings
- nonblocking connection, Database Connection Control Functions, Asynchronous Command Processing
- nonrepeatable read, Transaction Isolation
- noop, utl_smtp Functions
- 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
- notify_buffers configuration parameter, Memory
- 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
- NOTNULL, Comparison 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
- ON CONFLICT, INSERT
- ONLY, The FROM Clause
- OOM, Linux Memory Overcommit
- open, Opening and Closing LOBs
- OpenBSD
- ON CONFLICT, INSERT
- 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
- open_connection, utl_smtp Functions
- open_data, utl_smtp Functions
- operator, Operators, Operator Precedence, Functions and Operators, Logical Operators, Operators, User-Defined Operators
- open_data, utl_smtp Functions
- 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
- packages, Packages
- in PL/pgSQL, Packages
- pageinspect, pageinspect — low-level inspection of database pages
- pages_per_range storage parameter, Index Storage Parameters
- page_checksum, General Functions
- page_header, General Functions
- page_repair configuration parameter, Sending Servers
- 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
- percentileCont, Aggregation Functions
- percentileDisc, Aggregation Functions
- percent_rank, Window Functions
- percentileDisc, Aggregation 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, Obsolete Functions for Sending Cancel Requests
- PGcancelConn, Functions for Sending Cancel Requests
- 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, Version Information Functions
- pgpro_build configuration parameter, Preset Options
- pgpro_controldata, pgpro_controldata
- pgpro_edition, Version Information Functions
- pgpro_edition configuration parameter, Preset Options
- pgpro_multiplan, pgpro_multiplan — save a specific plan of a parameterized query for future usage
- 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.statements_reset configuration parameter, Setting Extension Parameters
- pgpro_pwr.track_sample_timings configuration parameter, Setting Extension Parameters
- pgpro_queue, pgpro_queue — message queueing management
- pgpro_queue.database_with_managed_retry configuration parameter, Configuration Parameters
- pgpro_queue.launcher_database configuration parameter, Configuration Parameters
- pgpro_queue.shared_retry_list_size configuration parameter, Configuration Parameters
- pgpro_rp_backend_set_plan, Backend Plan Function
- pgpro_rp_cleanup_roles_plans, Plan Assignment Functions
- pgpro_rp_create_group, Plan Assignment Group Functions
- pgpro_rp_create_group_role_plan, Plan Assignment Functions
- pgpro_rp_create_plan, Plan Management Functions
- pgpro_rp_create_role_plan, Plan Assignment Functions
- pgpro_rp_delete_group, Plan Assignment Group Functions
- pgpro_rp_delete_group_role_plan, Plan Assignment Functions
- pgpro_rp_delete_plan, Plan Management Functions
- pgpro_rp_delete_role_plan, Plan Assignment Functions
- pgpro_rp_get_active_group, Plan Assignment Functions
- pgpro_rp_get_plan, Plan Management Functions
- pgpro_rp_get_plan_selection_function, Plan Selection Functions
- pgpro_rp_invalidate_cache, Cache Functions
- pgpro_rp_rename_group, Plan Assignment Group Functions
- pgpro_rp_rename_plan, Plan Management Functions
- pgpro_rp_set_active_group, Plan Assignment Functions
- pgpro_rp_set_plan_selection_function, Plan Selection Functions
- pgpro_rp_update_plan, Plan Management Functions
- pgpro_rp_update_role_plan, Plan Assignment Functions
- pgpro_scheduler, pgpro_scheduler — scheduling, monitoring and managing job execution
- 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_get_archiver
- function, Functions
- pgpro_stats_info, Functions
- pgpro_stats_inval_status
- function, The pgpro_stats_inval_status View
- 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_database
- function, Functions
- pgpro_stats_vacuum_indexes
- function, Functions
- pgpro_stats_vacuum_tables
- function, Functions
- pgpro_stats_wal_sender_crc_errors
- function, Functions
- pgpro_stat_get_wal_activity, Statistics Functions
- pgpro_stat_wal_activity, Viewing Statistics, pgpro_stat_wal_activity
- pgpro_usage.max configuration parameter , Configuration Parameters
- pgpro_usage_get_last_reset_time, Support Functions
- pgpro_usage_reset, Support Functions
- pgpro_version, Version 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
- PGREUSEPASS, Environment Variables
- 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
- PGSSLNEGOTIATION, 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_autoprepared_statements, pg_autoprepared_statements
- pg_available_extensions, pg_available_extensions
- pg_available_extension_versions, pg_available_extension_versions
- pg_available_wal_summaries, WAL Summarization Information Functions
- pg_backend_get_config_value, Configuration Settings Functions
- pg_backend_load_library, Configuration Settings Functions
- pg_backend_memory_contexts, pg_backend_memory_contexts
- pg_backend_pid, Session Information Functions
- pg_backend_set_config, Configuration Settings Functions
- pg_backup_start, Backup Control Functions
- pg_backup_stop, Backup Control Functions
- pg_basebackup, pg_basebackup
- pg_basetype, System Catalog Information Functions
- pg_blocking_pids, Session Information Functions
- pg_buffercache, pg_buffercache — inspect Postgres Pro buffer cache state
- pg_buffercache_evict, 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_column_toast_chunk_id, Database Object Management Functions
- pg_combinebackup, pg_combinebackup
- pg_config, pg_config, pg_config
- pgpro_stat_wal_activity, Viewing Statistics, pgpro_stat_wal_activity
- 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_createsubscriber, pg_createsubscriber
- 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_diagdump, Troubleshooting Functions
- 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_settings, pg_file_settings
- 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_get_wal_summarizer_state, WAL Summarization Information 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_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_checkpointer, Viewing Statistics, pg_stat_checkpointer
- 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_delete_req_per_user, Functions to Collect Per-user Statistics on Relations
- pg_stat_get_func_calls_per_user, Functions to Collect Per-user Statistics on Functions
- pg_stat_get_func_grants_given_per_user, Functions to Collect Per-user Statistics on Functions
- pg_stat_get_grants_given_per_user, Functions to Collect Per-user Statistics on Relations
- pg_stat_get_insert_req_per_user, Functions to Collect Per-user Statistics on Relations
- pg_stat_get_last_delete_per_user, Functions to Collect Per-user Statistics on Relations
- pg_stat_get_last_insert_per_user, Functions to Collect Per-user Statistics on Relations
- pg_stat_get_last_read_per_user,
- pg_enum, pg_enum