current_logfiles file and the pg_current_logfile function, Session Information Functions
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

configuration parameter, What to Log
storage parameter, Storage Parameters for Not Sharded Tables

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_failures 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_parameter_types 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

looks_like_number

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 Shardman 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

ltrim, String Functions and Operators, Binary String Functions and Operators

lwlock_shared_limit configuration parameter, Lock Management

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

IPC configuration, Shared Memory and Semaphores
shared library, Compiling and Linking Dynamically-Loaded Functions

magic block, Dynamic Loading

maintenance, Routine Database Maintenance Tasks

maintenance_io_concurrency configuration parameter, I/O

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

masklen, Network Address Functions and Operators

materialized view, Materialized Views

implementation through rules, Materialized Views

materialized views, pg_matviews

max, Aggregate Functions

max_active_replication_origins configuration parameter, Subscribers

max_backend_memory configuration parameter, Memory

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_autovacuum_workers

configuration parameter, Automatic Vacuuming

max_parallel_maintenance_workers configuration parameter, Worker Processes

max_parallel_workers configuration parameter, Worker Processes

max_parallel_workers_per_gather configuration parameter, Worker Processes

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, 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_segments_prealloc configuration parameter, Settings

max_wal_senders configuration parameter, Sending Servers

max_wal_size configuration parameter, Checkpoints

max_worker_processes configuration parameter, Worker Processes

md5, String Functions and Operators, Binary String Functions and Operators

MD5, Password Authentication

md5_password_warnings configuration parameter, Authentication

median, Aggregate Expressions

(see also percentile)

MEMMB, Environment variables

memory context

in SPI, Memory Management

memory overcommit, Linux Memory Overcommit

MERGE, Returning Data from Modified Rows, MERGE

RETURNING, Returning Data from Modified Rows, Merge Support Functions

merge_action, Merge Support Functions

min, Aggregate Functions

min_dynamic_shared_memory configuration parameter, Memory

min_parallel_index_scan_size configuration parameter, Planner Cost Constants

min_parallel_table_scan_size configuration parameter, Planner Cost Constants

min_scale, Mathematical Functions and Operators

min_wal_size configuration parameter, Checkpoints

mod, Mathematical Functions and Operators

mode

statistical, Aggregate Functions

monitoring, Monitoring Database Activity

database activity, Monitoring Database Activity

MOVE, MOVE

moving-aggregate mode, Moving-Aggregate Mode

multirange (function), Range/Multirange Functions and Operators

multirange type, Range Types

Multiversion Concurrency Control, Introduction

MultiXactId, Shrinking pg_multixact

multixact_member_buffers configuration parameter, Memory

multixact_offset_buffers configuration parameter, Memory

MVCC, Introduction

MVER, Environment variables

mxid_age, Transaction ID and Snapshot Information Functions

N

name, Identifiers and Key Words

qualified, Creating a Schema
syntax of, Identifiers and Key Words
unqualified, The Schema Search Path

NaN (see not a number)

natural join, Joined Tables

NCPU, Environment variables

negation, Logical Operators

NetBSD

IPC configuration, Shared Memory and Semaphores
shared library, Compiling and Linking Dynamically-Loaded Functions
start script, Starting the Database Server

netmask, Network Address Functions and Operators

network, Network Address Types, Network Address Functions and Operators

data types, Network Address Types

NETWORK EXPLAIN ANALYZE parameter, EXPLAIN Parameters

nextval, Sequence Manipulation Functions

NFS, NFS

nonblocking connection, Database Connection Control Functions, Asynchronous Command Processing

nonrepeatable read, Transaction Isolation

normalize, String Functions and Operators

normalized, String Functions and Operators

NOT (operator), Logical Operators

not a number

floating point, Floating-Point Types
numeric (data type), Arbitrary Precision Numbers

NOT IN, Subquery Expressions, Row and Array Comparisons

not-null constraint, Not-Null Constraints

notation, Calling Functions

functions, Calling Functions

notice processing, Notice Processing

in libpq, Notice Processing

notice processor, Notice Processing

notice receiver, Notice Processing

NOTIFY, Asynchronous Notification, NOTIFY

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

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

NULLIF, NULLIF

nul_byte_replacement_on_import configuration parameter, Previous Postgres Pro Shardman Versions

number

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

num_os_semaphores configuration parameter, Preset Options

num_parts storage parameter, Storage Parameters for Postgres Pro Shardman

num_xloginsert_locks configuration parameter, Lock Management

NVL, COALESCE

O

OAuth Authorization/Authentication, OAuth Authorization/Authentication

OAuth Validators, OAuth Validator Modules

oauth_validator_libraries configuration parameter, Authentication

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

in libpq, Retrieving Other Result Information

oid2name, oid2name

ON CONFLICT, INSERT

ONLY, The FROM Clause

OOM, Linux Memory Overcommit

OpenBSD

IPC configuration, Shared Memory and Semaphores
shared library, Compiling and Linking Dynamically-Loaded Functions
start script, Starting the Database Server

operator, Operators, Operator Precedence, Functions and Operators, Logical Operators, Operators, User-Defined Operators

invocation, Operator Invocations
logical, Logical Operators
precedence, Operator Precedence
syntax, Operators
type resolution in an invocation, Operators
user-defined, User-Defined Operators

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

for functions, Function Optimization Information
for operators, Operator Optimization Information

optimize_row_in_expr configuration parameter, PostgreSQL Settings for a Distributed System

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

order_by_attach

storage parameter, Index Storage Parameters

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

functions, Function Overloading
operators, User-Defined Operators

owner, Privileges

P

packages, Packages

in PL/pgSQL, Packages

pages_per_range storage parameter, Index Storage Parameters

page_repair configuration parameter, Sending Servers

palloc, Writing Code

PAM, PAM Authentication

parallel query, Parallel Query

parallel_autovacuum_workers storage parameter, Storage Parameters for Not Sharded Tables

parallel_leader_participation configuration parameter, Worker Processes

parallel_setup_cost configuration parameter, Planner Cost Constants

parallel_tuple_cost configuration parameter, Planner Cost Constants

parallel_workers storage parameter, Storage Parameters for Not Sharded Tables

parameter

syntax, Positional Parameters

parenthesis, Value Expressions

parse_ident, String Functions and Operators

partition pruning, Partition Pruning

partitioned table, Table Partitioning

partitioning, Table Partitioning

partition_bounds storage parameter, Storage Parameters for Postgres Pro Shardman

partition_by storage parameter, Storage Parameters for Postgres Pro Shardman

password, Role Attributes

authentication, Password Authentication
of the superuser, Creating a Database Cluster

password file, The Password File

password_encryption configuration parameter, Authentication

path, Geometric Functions and Operators

for schemas, Statement Behavior

path (data type), Paths

pattern matching, Pattern Matching

patterns

in psql and pg_dump, Patterns

pclose, Geometric Functions and Operators

peer, Peer Authentication

percentile

continuous, Aggregate Functions
discrete, Aggregate Functions

percent_rank, Window Functions

hypothetical, Aggregate Functions

performance, Performance Tips

Perl, PL/Perl — Perl Procedural Language

permission (see privilege)

pfree, Writing Code

pg-setup, pg-setup

pg-wrapper, pg-wrapper

PGAPPNAME, Environment Variables

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

pgcrypto.builtin_crypto_enabled configuration parameter, Configuration Parameters

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

PGMAXPROTOCOLVERSION, Environment Variables

PGMINPROTOCOLVERSION, Environment Variables

PGOPTIONS, Environment Variables

PGPASSFILE, Environment Variables

PGPASSWORD, Environment Variables

PGPORT, Environment Variables

pgpro_build configuration parameter, Preset Options

pgpro_controldata, pgpro_controldata

pgpro_datactl, pgpro_datactl — manage Postgres Pro Shardman data files

pgpro_edition configuration parameter, Preset Options

pgpro_pwr, pgpro_pwr — workload reports

pgpro_pwr.max configuration parameter, Setting Extension Parameters

pgpro_pwr.max_query_length configuration parameter, Setting Extension Parameters

pgpro_pwr.max_sample_age configuration parameter, Setting Extension Parameters

pgpro_pwr.relsize_collect_mode 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_stats, pgpro_stats — a means for tracking planning and execution statistics of all SQL statements executed by a server

pgpro_stats.enable_inval_msgs_counters configuration parameter, Related Configuration Parameters

pgpro_stats_create_pg_stat_kcache_compatible_views

function, Functions for Creating Views that Emulate Other Extensions

pgpro_stats_create_pg_stat_statements_compatible_views

function, Functions for Creating Views that Emulate Other Extensions

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_sdm_stats_updated

function, Functions

pgpro_stats_sdm_stats_updated_reset

function, Functions

pgpro_stats_statements

function, Functions

pgpro_stats_statements_filtered

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_tune, pgpro_tune

pgpro_version configuration parameter, Preset Options

pgpro_wrap, pgpro_wrap

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

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

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_aios, pg_aios

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_basetype, System Catalog Information Functions

pg_blocking_pids, Session Information Functions

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_clear_attribute_stats, Database Object Management Functions

pg_clear_relation_stats, Database Object Management Functions

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

with ecpg, Processing Embedded SQL Programs
with libpq, Building libpq Programs
with user-defined C functions, Writing Code

pg_conf_load_time, Session Information Functions

pg_constraint, pg_constraint

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_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_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_function_is_visible, Schema Visibility Inquiry Functions

pg_get_acl, Object Information and Addressing 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_loaded_modules, Session Information Functions

pg_get_multixact_members, Transaction ID and Snapshot Information Functions

pg_get_object_address, Object Information and Addressing Functions

pg_get_partition_constraintdef, System Catalog Information 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_summariesdir, 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_MODULE_MAGIC, Dynamic Loading

pg_my_temp_schema, Session Information Functions

pg_namespace, pg_namespace

pg_notification_queue_usage, Session Information Functions

pg_notify, pg_notify

pg_numa_available, Session Information Functions

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_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_file_mode 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_rows 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_proc, pg_proc

pg_profile, pg_profile

pg_progress_bar function, Functions

pg_progress_bar_visual function, Functions

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_query_state, pg_query_state — a module for checking the current state of query execution in a working backend process

pg_query_state function, Functions

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_logical_blocks, Database Object Management Functions

pg_relation_size, Database Object Management Functions

pg_reload_conf, Server Signaling Functions

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_restore_attribute_stats, Database Object Management Functions

pg_restore_relation_stats, Database Object Management Functions

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_shmem_allocations_numa, pg_shmem_allocations_numa

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_io, 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_wal, Statistics Functions

pg_stat_get_backend_xact_start, Statistics Functions

pg_stat_get_snapshot_timestamp, Statistics Functions

pg_stat_get_xact_blocks_fetched, Statistics Functions

pg_stat_get_xact_blocks_hit, Statistics Functions

pg_stat_gssapi, Viewing Statistics, pg_stat_gssapi

pg_stat_io, Viewing Statistics, pg_stat_io

pg_stat_progress_analyze, Viewing Statistics, ANALYZE Progress Reporting

pg_stat_progress_cluster, Viewing Statistics, CLUSTER Progress Reporting

pg_stat_progress_copy, Viewing Statistics, COPY Progress Reporting

pg_stat_progress_create_index, Viewing Statistics, CREATE INDEX Progress Reporting

pg_stat_progress_vacuum, Viewing Statistics, VACUUM Progress Reporting

pg_stat_recovery_prefetch, Viewing Statistics, pg_stat_recovery_prefetch

pg_stat_replication, Viewing Statistics, pg_stat_replication

pg_stat_replication_slots, Viewing Statistics, pg_stat_replication_slots

pg_stat_reset, Statistics Functions

pg_stat_reset_backend_stats, Statistics Functions

pg_stat_reset_replication_slot, Statistics Functions

pg_stat_reset_shared, Statistics Functions

pg_stat_reset_single_function_counters, Statistics Functions

pg_stat_reset_single_table_counters, Statistics Functions

pg_stat_reset_slru, Statistics Functions

pg_stat_reset_subscription_stats, Statistics Functions

pg_stat_slru, Viewing Statistics, pg_stat_slru

pg_stat_ssl, Viewing Statistics, pg_stat_ssl

pg_stat_statements, pg_stat_statements — track statistics of SQL planning and execution

function, Functions

pg_stat_statements.max configuration parameter, Configuration Parameters

pg_stat_statements.save configuration parameter, Configuration Parameters

pg_stat_statements.track configuration parameter, Configuration Parameters

pg_stat_statements.track_planning configuration parameter, Configuration Parameters

pg_stat_statements.track_utility configuration parameter, Configuration Parameters

pg_stat_statements_info, The pg_stat_statements_info View

pg_stat_statements_reset, Functions

pg_stat_subscription, Viewing Statistics, pg_stat_subscription

pg_stat_subscription_stats, Viewing Statistics, pg_stat_subscription_stats

pg_stat_sys_indexes, Viewing Statistics

pg_stat_sys_tables, Viewing Statistics

pg_stat_user_functions, Viewing Statistics, pg_stat_user_functions

pg_stat_user_indexes, Viewing Statistics

pg_stat_user_tables, Viewing Statistics

pg_stat_wal, Viewing Statistics, pg_stat_wal

pg_stat_wal_receiver, Viewing Statistics, pg_stat_wal_receiver

pg_stat_xact_all_tables, Viewing Statistics

pg_stat_xact_sys_tables, Viewing Statistics

pg_stat_xact_user_functions, Viewing Statistics

pg_stat_xact_user_tables, Viewing Statistics

pg_subscription, pg_subscription

pg_subscription_rel, pg_subscription_rel

pg_switch_wal, Backup Control Functions

pg_sync_replication_slots, Replication Management Functions

pg_tables, pg_tables

pg_tablespace, pg_tablespace

pg_tablespace_databases, System Catalog Information Functions

pg_tablespace_location, System Catalog Information Functions

pg_tablespace_size, Database Object Management Functions

pg_table_is_visible, Schema Visibility Inquiry Functions

pg_table_size, Database Object Management Functions

pg_temp, Statement Behavior

securing functions, Writing SECURITY DEFINER Functions Safely

pg_temp_relation_size, Database Object Management Functions

pg_terminate_backend, Server Signaling Functions

pg_test_fsync, pg_test_fsync

pg_test_timing, pg_test_timing

pg_timezone_abbrevs, pg_timezone_abbrevs

pg_timezone_names, pg_timezone_names

pg_total_relation_size, Database Object Management Functions

pg_transform, pg_transform

pg_trigger, pg_trigger

pg_trigger_depth, Session Information Functions

pg_try_advisory_lock, Advisory Lock Functions

pg_try_advisory_lock_shared, Advisory Lock Functions

pg_try_advisory_xact_lock, Advisory Lock Functions

pg_try_advisory_xact_lock_shared, Advisory Lock Functions

pg_ts_config, pg_ts_config

pg_ts_config_is_visible, Schema Visibility Inquiry Functions

pg_ts_config_map, pg_ts_config_map

pg_ts_dict, pg_ts_dict

pg_ts_dict_is_visible, Schema Visibility Inquiry Functions

pg_ts_parser, pg_ts_parser

pg_ts_parser_is_visible, Schema Visibility Inquiry Functions

pg_ts_template, pg_ts_template

pg_ts_template_is_visible, Schema Visibility Inquiry Functions

pg_type, pg_type

pg_typeof, System Catalog Information Functions

pg_type_is_visible, Schema Visibility Inquiry Functions

pg_upgrade, pg_upgrade

pg_user, pg_user

pg_user_mapping, pg_user_mapping

pg_user_mappings, pg_user_mappings

pg_verifybackup, pg_verifybackup

pg_views, pg_views

pg_visible_in_snapshot, Transaction ID and Snapshot Information Functions

pg_wait_events, pg_wait_events

pg_wait_sampling.history_period variable, GUC Variables

pg_wait_sampling.history_size variable, GUC Variables

pg_wait_sampling.profile_period variable, GUC Variables

pg_wait_sampling.profile_pid variable, GUC Variables

pg_wait_sampling.profile_queries variable, GUC Variables

pg_wait_sampling.sample_cpu variable, GUC Variables

pg_wait_sampling_get_current, Functions

pg_wait_sampling_reset_profile, Functions

pg_waldump, pg_waldump

pg_walfile_name, Backup Control Functions

pg_walfile_name_offset, Backup Control Functions

pg_walsummary, pg_walsummary

pg_wal_lsn_diff, Backup Control Functions

pg_wal_replay_pause, Recovery Control Functions

pg_wal_replay_resume, Recovery Control Functions

pg_wal_summary_contents, WAL Summarization Information Functions

pg_xact_commit_timestamp, Committed Transaction Information Functions

pg_xact_commit_timestamp_origin, Committed Transaction Information Functions

pg_xact_status, Transaction ID and Snapshot Information Functions

pg_xlogdump, pg_xlogdump renamed to pg_waldump (see pg_waldump)

phantom read, Transaction Isolation

phraseto_tsquery, Text Search Functions and Operators, Parsing Queries

pi, Mathematical Functions and Operators

PIC, Compiling and Linking Dynamically-Loaded Functions

PID

determining PID of server process

in libpq, Connection Status Functions

pipelining, Pipeline Mode, Pipelining

in libpq, Pipeline Mode
protocol specification, Pipelining

PITR, Backup and Restore

PITR standby, High Availability, Load Balancing, and Replication

pkg-config

with ecpg, Processing Embedded SQL Programs
with libpq, Building libpq Programs

PL/Perl, PL/Perl — Perl Procedural Language

PL/PerlU, Trusted and Untrusted PL/Perl

PL/pgSQL, PL/pgSQL — SQL Procedural Language

PL/Python, PL/Python — Python Procedural Language

PL/SQL (Oracle), Porting from Oracle PL/SQL

porting to PL/pgSQL, Porting from Oracle PL/SQL

PL/Tcl, PL/Tcl — Tcl Procedural Language

plainto_tsquery, Text Search Functions and Operators, Parsing Queries

planner_upper_limit_estimation configuration parameter, Planner Method Configuration

plan_cache_lru_memsize configuration parameter, Memory

plan_cache_lru_size configuration parameter, Memory

plan_cache_mode configuration parameter, Other Planner Options

plperl.on_init configuration parameter, Configuration

plperl.on_plperlu_init configuration parameter, Configuration

plperl.on_plperl_init configuration parameter, Configuration

plperl.use_strict configuration parameter, Configuration

plpgsql.check_asserts configuration parameter, Checking Assertions

plpgsql.variable_conflict configuration parameter, Variable Substitution

pltcl.start_proc configuration parameter, PL/Tcl Configuration

pltclu.start_proc configuration parameter, PL/Tcl Configuration

point, Points, Geometric Functions and Operators

point-in-time recovery, Backup and Restore

policy, Row Security Policies

polygon, Polygons, Geometric Functions and Operators

polymorphic function, Polymorphic Types

polymorphic type, Polymorphic Types

popcount (see bit_count)

popen, Geometric Functions and Operators

port, Parameter Key Words

port configuration parameter, PostgreSQL Settings for a Distributed System

portal

DECLARE, DECLARE
in PL/pgSQL, Opening Cursors

position, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators

POSITION_REGEX, Differences from SQL Standard and XQuery

POSTGRES, The Berkeley POSTGRES Project

postgres, Starting the Database Server, postgres

postgres user, The Postgres Pro Shardman User Account

Postgres95, Postgres95

postgresql.auto.conf, Parameter Interaction via the Configuration File

postgresql.conf, Parameter Interaction via the Configuration File

postgres_fdw, postgres_fdw — access data stored in external PostgreSQL servers

postgres_fdw.application_name configuration parameter, Configuration Parameters

postgres_fdw.read_only_transactions configuration parameter, Configuration Parameters

post_auth_delay configuration parameter, Developer Options

power, Mathematical Functions and Operators

PQAUTHDATA_OAUTH_BEARER_TOKEN, Hook Types

PQAUTHDATA_PROMPT_OAUTH_DEVICE, Hook Types

PQbackendPID, Connection Status Functions

PQbinaryTuples, Retrieving Query Result Information

with COPY, Functions Associated with the COPY Command

PQcancel, Obsolete Functions for Sending Cancel Requests

PQcancelBlocking, Functions for Sending Cancel Requests

PQcancelCreate, Functions for Sending Cancel Requests

PQcancelErrorMessage, Functions for Sending Cancel Requests

PQcancelFinish, Functions for Sending Cancel Requests

PQcancelPoll, Functions for Sending Cancel Requests

PQcancelReset, Functions for Sending Cancel Requests

PQcancelSocket, Functions for Sending Cancel Requests

PQcancelStart, Functions for Sending Cancel Requests

PQcancelStatus, Functions for Sending Cancel Requests

PQchangePassword, Miscellaneous Functions

PQclear, Main Functions

PQclientEncoding, Control Functions

PQclosePortal, Main Functions

PQclosePrepared, Main Functions

PQcmdStatus, Retrieving Other Result Information

PQcmdTuples, Retrieving Other Result Information

PQconndefaults, Database Connection Control Functions

PQconnectdb, Database Connection Control Functions

PQconnectdbParams, Database Connection Control Functions

PQconnectionNeedsPassword, Connection Status Functions

PQconnectionUsedGSSAPI, Connection Status Functions

PQconnectionUsedPassword, Connection Status Functions

PQconnectPoll, Database Connection Control Functions

PQconnectStart, Database Connection Control Functions

PQconnectStartParams, Database Connection Control Functions

PQconninfo, Database Connection Control Functions

PQconninfoFree, Miscellaneous Functions

PQconninfoParse, Database Connection Control Functions

PQconsumeInput, Asynchronous Command Processing

PQcopyResult, Miscellaneous Functions

PQdb, Connection Status Functions

PQdescribePortal, Main Functions

PQdescribePrepared, Main Functions

PQencryptPassword, Miscellaneous Functions

PQencryptPasswordConn, Miscellaneous Functions

PQendcopy, Obsolete Functions for COPY

PQenterPipelineMode, Functions Associated with Pipeline Mode

PQerrorMessage, Connection Status Functions

PQescapeBytea, Escaping Strings for Inclusion in SQL Commands

PQescapeByteaConn, Escaping Strings for Inclusion in SQL Commands

PQescapeIdentifier, Escaping Strings for Inclusion in SQL Commands

PQescapeLiteral, Escaping Strings for Inclusion in SQL Commands

PQescapeString, Escaping Strings for Inclusion in SQL Commands

PQescapeStringConn, Escaping Strings for Inclusion in SQL Commands

PQexec, Main Functions

PQexecParams, Main Functions

PQexecPrepared, Main Functions

PQexitPipelineMode, Functions Associated with Pipeline Mode

PQfformat, Retrieving Query Result Information

with COPY, Functions Associated with the COPY Command

PQfinish, Database Connection Control Functions

PQfireResultCreateEvents, Miscellaneous Functions

PQflush, Asynchronous Command Processing

PQfmod, Retrieving Query Result Information

PQfn, The Fast-Path Interface

PQfname, Retrieving Query Result Information

PQfnumber, Retrieving Query Result Information

PQfreeCancel, Obsolete Functions for Sending Cancel Requests

PQfreemem, Miscellaneous Functions

PQfsize, Retrieving Query Result Information

PQftable, Retrieving Query Result Information

PQftablecol, Retrieving Query Result Information

PQftype, Retrieving Query Result Information

PQfullProtocolVersion, Connection Status Functions

PQgetAuthDataHook, Authdata Hooks

PQgetCancel, Obsolete Functions for Sending Cancel Requests

PQgetCopyData, Functions for Receiving COPY Data

PQgetCurrentTimeUSec, Miscellaneous Functions

PQgetisnull, Retrieving Query Result Information

PQgetlength, Retrieving Query Result Information

PQgetline, Obsolete Functions for COPY

PQgetlineAsync, Obsolete Functions for COPY

PQgetResult, Asynchronous Command Processing

PQgetssl, Connection Status Functions

PQgetSSLKeyPassHook_OpenSSL, Database Connection Control Functions

PQgetvalue, Retrieving Query Result Information

PQhost, Connection Status Functions

PQhostaddr, Connection Status Functions

PQinitOpenSSL, SSL Library Initialization

PQinitSSL, SSL Library Initialization

PQinstanceData, Event Support Functions

PQisBusy, Asynchronous Command Processing

PQisnonblocking, Asynchronous Command Processing

PQisthreadsafe, Behavior in Threaded Programs

PQlibVersion, Miscellaneous Functions

(see also PQserverVersion)

PQmakeEmptyPGresult, Miscellaneous Functions

PQnfields, Retrieving Query Result Information

with COPY, Functions Associated with the COPY Command

PQnotifies, Asynchronous Notification

PQnparams, Retrieving Query Result Information

PQntuples, Retrieving Query Result Information

PQoidStatus, Retrieving Other Result Information

PQoidValue, Retrieving Other Result Information

PQoptions, Connection Status Functions

PQparameterStatus, Connection Status Functions

PQparamtype, Retrieving Query Result Information

PQpass, Connection Status Functions

PQping, Database Connection Control Functions

PQpingParams, Database Connection Control Functions

PQpipelineStatus, Functions Associated with Pipeline Mode

PQpipelineSync, Functions Associated with Pipeline Mode

PQport, Connection Status Functions

PQprepare, Main Functions

PQprint, Retrieving Query Result Information

PQprotocolVersion, Connection Status Functions

PQputCopyData, Functions for Sending COPY Data

PQputCopyEnd, Functions for Sending COPY Data

PQputline, Obsolete Functions for COPY

PQputnbytes, Obsolete Functions for COPY

PQregisterEventProc, Event Support Functions

PQrequestCancel, Obsolete Functions for Sending Cancel Requests

PQreset, Database Connection Control Functions

PQresetPoll, Database Connection Control Functions

PQresetStart, Database Connection Control Functions

PQresStatus, Main Functions

PQresultAlloc, Miscellaneous Functions

PQresultErrorField, Main Functions

PQresultErrorMessage, Main Functions

PQresultInstanceData, Event Support Functions

PQresultMemorySize, Miscellaneous Functions

PQresultSetInstanceData, Event Support Functions

PQresultStatus, Main Functions

PQresultVerboseErrorMessage, Main Functions

PQsendClosePortal, Asynchronous Command Processing

PQsendClosePrepared, Asynchronous Command Processing

PQsendDescribePortal, Asynchronous Command Processing

PQsendDescribePrepared, Asynchronous Command Processing

PQsendFlushRequest, Functions Associated with Pipeline Mode

PQsendPipelineSync, Functions Associated with Pipeline Mode

PQsendPrepare, Asynchronous Command Processing

PQsendQuery, Asynchronous Command Processing

PQsendQueryParams, Asynchronous Command Processing

PQsendQueryPrepared, Asynchronous Command Processing

PQserverVersion, Connection Status Functions

PQsetAuthDataHook, Authdata Hooks

PQsetChunkedRowsMode, Retrieving Query Results in Chunks

PQsetClientEncoding, Control Functions

PQsetdb, Database Connection Control Functions

PQsetdbLogin, Database Connection Control Functions

PQsetErrorContextVisibility, Control Functions

PQsetErrorVerbosity, Control Functions

PQsetInstanceData, Event Support Functions

PQsetnonblocking, Asynchronous Command Processing

PQsetNoticeProcessor, Notice Processing

PQsetNoticeReceiver, Notice Processing

PQsetResultAttrs, Miscellaneous Functions

PQsetSingleRowMode, Retrieving Query Results in Chunks

PQsetSSLKeyPassHook_OpenSSL, Database Connection Control Functions

PQsetTraceFlags, Control Functions

PQsetvalue, Miscellaneous Functions

PQsocket, Connection Status Functions

PQsocketPoll, Database Connection Control Functions

PQsslAttribute, Connection Status Functions

PQsslAttributeNames, Connection Status Functions

PQsslInUse, Connection Status Functions

PQsslStruct, Connection Status Functions

PQstatus, Connection Status Functions

PQtrace, Control Functions

PQtransactionStatus, Connection Status Functions

PQtty, Connection Status Functions

PQunescapeBytea, Escaping Strings for Inclusion in SQL Commands

PQuntrace, Control Functions

PQuser, Connection Status Functions

predicate locking, Serializable Isolation Level

PREPARE, PREPARE

PREPARE TRANSACTION, PREPARE TRANSACTION

prepared statements, DEALLOCATE, EXECUTE, EXPLAIN, PREPARE

creating, PREPARE
executing, EXECUTE
removing, DEALLOCATE
showing the query plan, EXPLAIN

preparing a query

in PL/pgSQL, Plan Caching
in PL/Python, Database Access Functions
in PL/Tcl, Database Access from PL/Tcl

pre_auth_delay configuration parameter, Developer Options

primary key, Primary Keys

primary_conninfo configuration parameter, Standby Servers

primary_slot_name configuration parameter, Standby Servers

privilege, Privileges, Privileges, Schemas and Privileges, Rules and Privileges, Rules and Privileges

default, Privileges
querying, Access Privilege Inquiry Functions
with rules, Rules and Privileges
for schemas, Schemas and Privileges
with views, Rules and Privileges

procedural language, Procedural Languages, Writing a Procedural Language Handler

externally maintained, Procedural Languages
handler for, Writing a Procedural Language Handler

procedure, User-Defined Procedures

user-defined, User-Defined Procedures

procedures

output parameter, SQL Procedures with Output Parameters

protocol, Frontend/Backend Protocol

frontend-backend, Frontend/Backend Protocol

ps, Standard Unix Tools

to monitor activity, Standard Unix Tools

psql, Accessing a Database, psql

ptrack.map_size configuration parameter, PTRACK Configuration Parameters

ptrack_get_change_stat, PTRACK Functions

ptrack_get_pagemapset, PTRACK Functions

ptrack_version, PTRACK Functions

Python, PL/Python — Python Procedural Language

Q

qualified name, Creating a Schema

query, Querying a Table, Queries

query cancellation, Canceling Queries in Progress

query plan, Using EXPLAIN

query tree, The Query Tree

querytree, Text Search Functions and Operators, Manipulating Queries

quotation marks

and identifiers, Identifiers and Key Words
escaping, String Constants

quote_all_identifiers configuration parameter, Previous Postgres Pro Shardman Versions

quote_ident, String Functions and Operators

in PL/Perl, Utility Functions in PL/Perl
use in PL/pgSQL, Executing Dynamic Commands

quote_literal, String Functions and Operators

in PL/Perl, Utility Functions in PL/Perl
use in PL/pgSQL, Executing Dynamic Commands

quote_nullable, String Functions and Operators

in PL/Perl, Utility Functions in PL/Perl
use in PL/pgSQL, Executing Dynamic Commands

R

radians, Mathematical Functions and Operators

radius, Geometric Functions and Operators

RADIUS, RADIUS Authentication

RAISE

in PL/pgSQL, Reporting Errors and Messages

random, Mathematical Functions and Operators

random_normal, Mathematical Functions and Operators

random_page_cost configuration parameter, Planner Cost Constants

range table, The Query Tree

range type, Range Types

exclude, Constraints on Ranges
indexes on, Indexing

range_agg, Aggregate Functions

range_intersect_agg, Aggregate Functions

range_merge, Range/Multirange Functions and Operators

rank, Window Functions

hypothetical, Aggregate Functions

read committed, Read Committed Isolation Level

read-only transaction, Statement Behavior

setting, SET TRANSACTION
setting default, Statement Behavior

Readline

in psql, Command-Line Editing

READ_REPLICATION_SLOT, Streaming Replication Protocol

real, Floating-Point Types

REASSIGN OWNED, REASSIGN OWNED

rebalancing, Cluster Configuration for Distributed System

record, Pseudo-Types

recovery.conf, recovery.conf file merged into postgresql.conf

recovery.signal, Archive Recovery

recovery_end_command configuration parameter, Archive Recovery

recovery_init_sync_method configuration parameter, Error Handling

recovery_min_apply_delay configuration parameter, Standby Servers

recovery_prefetch configuration parameter, Recovery

recovery_target configuration parameter, Recovery Target

recovery_target_action configuration parameter, Recovery Target

recovery_target_db configuration parameter, Recovery Target

recovery_target_inclusive configuration parameter, Recovery Target

recovery_target_lsn configuration parameter, Recovery Target

recovery_target_name configuration parameter, Recovery Target

recovery_target_time configuration parameter, Recovery Target

recovery_target_timeline configuration parameter, Recovery Target

recovery_target_xid configuration parameter, Recovery Target

rectangle, Boxes

RECURSIVE, CREATE VIEW

in common table expressions, Recursive Queries
in views, CREATE VIEW

recursive_worktable_factor configuration parameter, Other Planner Options

referential integrity, Foreign Keys, Foreign Keys

REFRESH MATERIALIZED VIEW, REFRESH MATERIALIZED VIEW

regclass, Object Identifier Types

regcollation, Object Identifier Types

regconfig, Object Identifier Types

regdictionary, Object Identifier Types

regexp_count, String Functions and Operators, POSIX Regular Expressions

regexp_instr, String Functions and Operators, POSIX Regular Expressions

regexp_like, String Functions and Operators, POSIX Regular Expressions

regexp_match, String Functions and Operators, POSIX Regular Expressions

regexp_matches, String Functions and Operators, POSIX Regular Expressions

regexp_replace, String Functions and Operators, POSIX Regular Expressions

regexp_split_to_array, String Functions and Operators, POSIX Regular Expressions

regexp_split_to_table, String Functions and Operators, POSIX Regular Expressions

regexp_substr, String Functions and Operators, POSIX Regular Expressions

regnamespace, Object Identifier Types

regoper, Object Identifier Types

regoperator, Object Identifier Types

regproc, Object Identifier Types

regprocedure, Object Identifier Types

regprofile, Object Identifier Types

regression intercept, Aggregate Functions

regression slope, Aggregate Functions

regrole, Object Identifier Types

regr_avgx, Aggregate Functions

regr_avgy, Aggregate Functions

regr_count, Aggregate Functions

regr_intercept, Aggregate Functions

regr_r2, Aggregate Functions

regr_slope, Aggregate Functions

regr_sxx, Aggregate Functions

regr_sxy, Aggregate Functions

regr_syy, Aggregate Functions

regtype, Object Identifier Types

regular expression, SIMILAR TO Regular Expressions, POSIX Regular Expressions

(see also pattern matching)

regular expressions

and locales, Behavior

reindex, Routine Reindexing

REINDEX, REINDEX

reindexdb, reindexdb

relation, Concepts

relational database, Concepts

RELEASE SAVEPOINT, RELEASE SAVEPOINT

REMOTE EXPLAIN parameter, EXPLAIN Parameters

remove_temp_files_after_crash configuration parameter, Developer Options

rename_server, Server Management Functions

repeat, String Functions and Operators

repeatable read, Repeatable Read Isolation Level

replace, String Functions and Operators

replicated, Storage Parameters for Postgres Pro Shardman

replicated storage parameter, Storage Parameters

replication, High Availability, Load Balancing, and Replication

Replication Origins, Replication Progress Tracking

Replication Progress Tracking, Replication Progress Tracking

replication slot

logical replication, Replication Slots
streaming replication, Replication Slots

reporting errors

in PL/pgSQL, Reporting Errors and Messages

reserved_connections configuration parameter, Connection Settings

RESET, RESET

restartpoint, WAL Configuration

restart_after_crash configuration parameter, Error Handling

restore_command configuration parameter, Archive Recovery

RESTRICT, Dependency Tracking

with DROP, Dependency Tracking
foreign key action, Foreign Keys

restrict_nonsystem_relation_kind

configuration parameter, Statement Behavior

retryable error, Serialization Failure Handling

RETURN NEXT

in PL/pgSQL, RETURN NEXT and RETURN QUERY

RETURN QUERY

in PL/pgSQL, RETURN NEXT and RETURN QUERY

RETURNING, Returning Data from Modified Rows

RETURNING INTO, Executing a Command with a Single-Row Result

in PL/pgSQL, Executing a Command with a Single-Row Result

reverse, String Functions and Operators, Binary String Functions and Operators

REVOKE, Privileges, REVOKE

right, String Functions and Operators

right join, Joined Tables

role, Database Roles, Role Membership, Predefined Roles

applicable, applicable_roles
enabled, enabled_roles
membership in, Role Membership
privilege to bypass, Role Attributes
privilege to create, Role Attributes
privilege to inherit, Role Attributes
privilege to initiate replication, Role Attributes
privilege to limit connection, Role Attributes

ROLLBACK, ROLLBACK

rollback

psql, Variables

ROLLBACK PREPARED, ROLLBACK PREPARED

ROLLBACK TO SAVEPOINT, ROLLBACK TO SAVEPOINT

ROLLUP, GROUPING SETS, CUBE, and ROLLUP

round, Mathematical Functions and Operators

routine, User-Defined Procedures

routine maintenance, Routine Database Maintenance Tasks

row, Concepts, Table Basics

ROW, Row Constructors

row estimation, Row Estimation Examples

multivariate, Multivariate Statistics Examples
planner, Row Estimation Examples

row type, Composite Types

constructor, Row Constructors

row-level security, Row Security Policies

row-wise comparison, Row and Array Comparisons

row_number, Window Functions

row_security configuration parameter, Statement Behavior

row_security_active, Access Privilege Inquiry Functions

row_to_json, Processing and Creating JSON Data

rpad, String Functions and Operators

rtrim, String Functions and Operators, Binary String Functions and Operators

rule, The Rule System, Views and the Rule System, How SELECT Rules Work, Materialized Views, Rules on INSERT, UPDATE, and DELETE, Rules on INSERT, UPDATE, and DELETE, Rules on INSERT, UPDATE, and DELETE, Rules Versus Triggers

and materialized views, Materialized Views
and views, Views and the Rule System
for DELETE, Rules on INSERT, UPDATE, and DELETE
for INSERT, Rules on INSERT, UPDATE, and DELETE
for SELECT, How SELECT Rules Work
compared with triggers, Rules Versus Triggers
for UPDATE, Rules on INSERT, UPDATE, and DELETE

S

SAVEPOINT, SAVEPOINT

savepoints, RELEASE SAVEPOINT, ROLLBACK TO SAVEPOINT, SAVEPOINT

defining, SAVEPOINT
releasing, RELEASE SAVEPOINT
rolling back, ROLLBACK TO SAVEPOINT

scalar (see expression)

scale, Mathematical Functions and Operators

scaling, Cluster Configuration for Distributed System

schema, Unmanaged Schemas, Creating a Schema, The Public Schema, The vault Schema

creating, Creating a Schema
current, The Schema Search Path, Session Information Functions
public, The Public Schema
removing, Creating a Schema
vault, The vault Schema

SCRAM, Password Authentication

scram_iterations configuration parameter, Authentication

search path, The Schema Search Path

current, Session Information Functions
object visibility, Schema Visibility Inquiry Functions

search_path configuration parameter, The Schema Search Path, Statement Behavior

use in securing functions, Writing SECURITY DEFINER Functions Safely

secure communication, Cluster Configuration for Distributed System

SECURITY LABEL, SECURITY LABEL

segment_size configuration parameter, Preset Options

SELECT, Querying a Table, Queries, SELECT Output Columns, SELECT

determination of result type, SELECT Output Columns
select list, Select Lists

SELECT INTO, Executing a Command with a Single-Row Result, SELECT INTO

in PL/pgSQL, Executing a Command with a Single-Row Result

semaphores, Shared Memory and Semaphores

send_abort_for_crash configuration parameter, Developer Options

send_abort_for_kill configuration parameter, Developer Options

sequence, Sequence Manipulation Functions

and serial type, Serial Types

sequential scan, Planner Method Configuration

seq_page_cost configuration parameter, Planner Cost Constants

seq_scan_startup_cost_first_row configuration parameter, Other Planner Options

serial, Serial Types

serial2, Serial Types

serial4, Serial Types

serial8, Serial Types

serializable, Serializable Isolation Level

Serializable Snapshot Isolation, Introduction

serializable_buffers configuration parameter, Memory

serialization anomaly, Transaction Isolation, Serializable Isolation Level

serialization failure, Serialization Failure Handling

server log, Error Reporting and Logging, Log File Maintenance

log file maintenance, Log File Maintenance

Server Name Indication, Parameter Key Words

server spoofing, Preventing Server Spoofing

server_encoding configuration parameter, Preset Options

server_version configuration parameter, Preset Options

server_version_num configuration parameter, Preset Options

session_cpu_weight configuration parameter, Prioritization

session_ioread_weight configuration parameter, Prioritization

session_iowrite_weight configuration parameter, Prioritization

session_preload_libraries configuration parameter, Shared Library Preloading

session_replication_role configuration parameter, Statement Behavior

session_user, Session Information Functions

SET, Configuration Settings Functions, SET

SET CONSTRAINTS, SET CONSTRAINTS

set difference, Combining Queries (UNION, INTERSECT, EXCEPT)

set intersection, Combining Queries (UNION, INTERSECT, EXCEPT)

set operation, Combining Queries (UNION, INTERSECT, EXCEPT)

set returning functions, Set Returning Functions

functions, Set Returning Functions

SET ROLE, SET ROLE

SET SESSION AUTHORIZATION, SET SESSION AUTHORIZATION

SET TRANSACTION, SET TRANSACTION

set union, Combining Queries (UNION, INTERSECT, EXCEPT)

SET XML OPTION, Statement Behavior

setseed, Mathematical Functions and Operators

setval, Sequence Manipulation Functions

setweight, Text Search Functions and Operators, Manipulating Documents

setweight for specific lexeme(s), Text Search Functions and Operators

set_bit, Binary String Functions and Operators, Bit String Functions and Operators

set_byte, Binary String Functions and Operators

set_config, Configuration Settings Functions

set_masklen, Network Address Functions and Operators

set_server_connstr, Server Management Functions

set_server_db_exclude, Server Management Functions

set_server_description, Server Management Functions

set_server_max_sample_age, Server Management Functions

set_server_setting, Server Management Functions

set_server_size_sampling, Managing the Collection of Relation Sizes

set_server_subsampling, Server Management Functions

sha224, Binary String Functions and Operators

sha256, Binary String Functions and Operators

sha384, Binary String Functions and Operators

sha512, Binary String Functions and Operators

shard, Concepts

shardman.advisory_xact_lock, Advisory Lock Functions for Distributed System

shardman.advisory_xact_lock_shared, Advisory Lock Functions for Distributed System

shardman.am_coordinator() , Functions for Distributed System

shardman.attach_subpart , Functions for Distributed System

shardman.broadcast_all_sql , Functions for Distributed System

shardman.broadcast_ddl configuration parameter, PostgreSQL Settings for a Distributed System

shardman.broadcast_query , Functions for Distributed System

shardman.broadcast_sql , Functions for Distributed System

shardman.context_log configuration parameter, What to Log

shardman.create_subpart , Functions for Distributed System

shardman.ddl_disable configuration parameter, PostgreSQL Settings for a Distributed System

shardman.detach_subpart , Functions for Distributed System

shardman.drop_subpart , Functions for Distributed System

shardman.enable_limit_pushdown configuration parameter, PostgreSQL Settings for a Distributed System

shardman.extended_password_policies configuration parameter, PostgreSQL Settings for a Distributed System

shardman.extended_password_policies_skip_users configuration parameter, PostgreSQL Settings for a Distributed System

shardman.foreign_explain configuration parameter, PostgreSQL Settings for a Distributed System

shardman.get_partition_for_value , Functions for Distributed System

shardman.get_topology() , Functions for Distributed System

shardman.global_analyze , Functions for Distributed System

shardman.global_analyze_async , Functions for Distributed System

shardman.gt_batch_size configuration parameter, PostgreSQL Settings for a Distributed System

shardman.hide_shards configuration parameter, PostgreSQL Settings for a Distributed System

shardman.maintenance_user configuration parameter, PostgreSQL Settings for a Distributed System

shardman.monitor_deadlock_interval configuration parameter, PostgreSQL Settings for a Distributed System

shardman.monitor_dxact_interval configuration parameter, PostgreSQL Settings for a Distributed System

shardman.monitor_dxact_timeout configuration parameter, PostgreSQL Settings for a Distributed System

shardman.monitor_interval configuration parameter, PostgreSQL Settings for a Distributed System

shardman.monitor_trim_csnxid_map_interval configuration parameter, PostgreSQL Settings for a Distributed System

shardman.num_parts configuration parameter, PostgreSQL Settings for a Distributed System

shardman.oldest_csn, shardman.oldest_csn

shardman.pg_indoubt_xacts, shardman.pg_indoubt_xacts

shardman.pg_stat_csn, shardman.pg_stat_csn

shardman.pg_stat_fast_path, shardman.pg_stat_fast_path

shardman.pg_stat_monitor, shardman.pg_stat_monitor

shardman.pg_stat_netusage, shardman.pg_stat_netusage

shardman.pg_stat_reset, Statistics Functions

shardman.pg_stat_silk_msg_components, shardman.pg_stat_silk_msg_components

shardman.pg_stat_xact_time, shardman.pg_stat_xact_time

shardman.plan_cache_mem configuration parameter, PostgreSQL Settings for a Distributed System

shardman.query_engine_mode configuration parameter, PostgreSQL Settings for a Distributed System

shardman.remote_plan_cache configuration parameter, PostgreSQL Settings for a Distributed System

shardman.rgid configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silkroad_sched_priority configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silkworm_fetch_size configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silkworm_sched_priority configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_backends, shardman.silk_backends

shardman.silk_connects, shardman.silk_connects

shardman.silk_flow_control configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_hello_timeout configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_listen_ip configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_long_job_time configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_max_message configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_max_workers configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_num_workers configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_pending_jobs, shardman.silk_pending_jobs

shardman.silk_rbc_snap() , Functions

shardman.silk_routes, shardman.silk_routes

shardman.silk_routing, shardman.silk_routing

shardman.silk_routing() , Functions

shardman.silk_scheduler_mode configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_set_affinity configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_state, shardman.silk_state

shardman.silk_statinfo, shardman.silk_statinfo

shardman.silk_statinfo_reset() , Functions

shardman.silk_stream_work_mem configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_tracelog configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_tracelog_category configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_tracepoints configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_track_time configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_unassigned_job_queue_size configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_use_ip configuration parameter, PostgreSQL Settings for a Distributed System

shardman.silk_use_port configuration parameter, PostgreSQL Settings for a Distributed System

shardman.sync_cluster_settings configuration parameter, PostgreSQL Settings for a Distributed System

shardman.sync_cluster_settings_blacklist configuration parameter, PostgreSQL Settings for a Distributed System

shardman.sync_schema configuration parameter, PostgreSQL Settings for a Distributed System

shardman.topology, shardman.topology

shardman.trim_csnxid_map_naptime configuration parameter, PostgreSQL Settings for a Distributed System

shardman.try_advisory_xact_lock, Advisory Lock Functions for Distributed System

shardman.try_advisory_xact_lock_shared, Advisory Lock Functions for Distributed System

shardmanctl, shardmanctl

shardmand, shardmand

shared library, Compiling and Linking Dynamically-Loaded Functions

shared memory, Shared Memory and Semaphores

shared_buffers configuration parameter, Memory

shared_memory_size configuration parameter, Preset Options

shared_memory_size_in_huge_pages configuration parameter, Preset Options

shared_memory_type configuration parameter, Memory

shared_preload_libraries, Requesting Shared Memory at Startup, Requesting LWLocks at Startup

shared_preload_libraries configuration parameter, Shared Library Preloading

share_lock_fk storage parameter, Storage Parameters for Not Sharded Tables

shobj_description, Comment Information Functions

SHOW, Configuration Settings Functions, SHOW, Streaming Replication Protocol

show_baselines, Baseline Management Functions

show_samples, Sampling Functions

show_servers, Server Management Functions

show_server_settings, Server Management Functions

shutdown, Shutting Down the Server

SIGHUP, Parameter Interaction via the Configuration File, The pg_hba.conf File, User Name Maps

SIGINT, Shutting Down the Server

sign, Mathematical Functions and Operators

signal

backend processes, Server Signaling Functions

significant digits, Locale and Formatting

SIGQUIT, Shutting Down the Server

SIGTERM, Shutting Down the Server

sin, Mathematical Functions and Operators

sind, Mathematical Functions and Operators

single-user mode, Options for Single-User Mode

sinh, Mathematical Functions and Operators

sleep, Delaying Execution

sliced bread (see TOAST)

slope, Geometric Functions and Operators

SLRU, pg_stat_slru

smallint, Integer Types

smallserial, Serial Types

Solaris

shared library, Compiling and Linking Dynamically-Loaded Functions
start script, Starting the Database Server

SOME, Aggregate Functions, Subquery Expressions, Row and Array Comparisons

sorting, Sorting Rows (ORDER BY)

SP-GiST (see index)

SPI, Server Programming Interface

spi_commit

in PL/Perl, Database Access from PL/Perl

SPI_commit, SPI_commit

SPI_commit_and_chain, SPI_commit

SPI_connect, SPI_connect

SPI_connect_ext, SPI_connect

SPI_copytuple, SPI_copytuple

spi_cursor_close

in PL/Perl, Database Access from PL/Perl

SPI_cursor_close, SPI_cursor_close

SPI_cursor_fetch, SPI_cursor_fetch

SPI_cursor_find, SPI_cursor_find

SPI_cursor_move, SPI_cursor_move

SPI_cursor_open, SPI_cursor_open

SPI_cursor_open_with_args, SPI_cursor_open_with_args

SPI_cursor_open_with_paramlist, SPI_cursor_open_with_paramlist

SPI_cursor_parse_open, SPI_cursor_parse_open

SPI_exec, SPI_exec

SPI_execp, SPI_execp

SPI_execute, SPI_execute

SPI_execute_extended, SPI_execute_extended

SPI_execute_plan, SPI_execute_plan

SPI_execute_plan_extended, SPI_execute_plan_extended

SPI_execute_plan_with_paramlist, SPI_execute_plan_with_paramlist

SPI_execute_with_args, SPI_execute_with_args

spi_exec_prepared

in PL/Perl, Database Access from PL/Perl

spi_exec_query

in PL/Perl, Database Access from PL/Perl

spi_fetchrow

in PL/Perl, Database Access from PL/Perl

SPI_finish, SPI_finish

SPI_fname, SPI_fname

SPI_fnumber, SPI_fnumber

spi_freeplan

in PL/Perl, Database Access from PL/Perl

SPI_freeplan, SPI_freeplan

SPI_freetuple, SPI_freetuple

SPI_freetuptable, SPI_freetuptable

SPI_getargcount, SPI_getargcount

SPI_getargtypeid, SPI_getargtypeid

SPI_getbinval, SPI_getbinval

SPI_getnspname, SPI_getnspname

SPI_getrelname, SPI_getrelname

SPI_gettype, SPI_gettype

SPI_gettypeid, SPI_gettypeid

SPI_getvalue, SPI_getvalue

SPI_is_cursor_plan, SPI_is_cursor_plan

SPI_keepplan, SPI_keepplan

SPI_modifytuple, SPI_modifytuple

SPI_palloc, SPI_palloc

SPI_pfree, SPI_pfree

spi_prepare

in PL/Perl, Database Access from PL/Perl

SPI_prepare, SPI_prepare

SPI_prepare_cursor, SPI_prepare_cursor

SPI_prepare_extended, SPI_prepare_extended

SPI_prepare_params, SPI_prepare_params

spi_query

in PL/Perl, Database Access from PL/Perl

spi_query_prepared

in PL/Perl, Database Access from PL/Perl

SPI_register_relation, SPI_register_relation

SPI_register_trigger_data, SPI_register_trigger_data

SPI_repalloc, SPI_repalloc

SPI_result_code_string, SPI_result_code_string

SPI_returntuple, SPI_returntuple

spi_rollback

in PL/Perl, Database Access from PL/Perl

SPI_rollback, SPI_rollback

SPI_rollback_and_chain, SPI_rollback

SPI_saveplan, SPI_saveplan

SPI_scroll_cursor_fetch, SPI_scroll_cursor_fetch

SPI_scroll_cursor_move, SPI_scroll_cursor_move

SPI_start_transaction, SPI_start_transaction

SPI_unregister_relation, SPI_unregister_relation

split_part, String Functions and Operators

SQL/CLI, SQL Conformance

SQL/Foundation, SQL Conformance

SQL/Framework, SQL Conformance

SQL/JRT, SQL Conformance

SQL/JSON, JSON Functions and Operators

functions and expressions, JSON Functions and Operators

SQL/JSON path language, The SQL/JSON Path Language

SQL/MDA, SQL Conformance

SQL/MED, SQL Conformance

SQL/OLB, SQL Conformance

SQL/PGQ, SQL Conformance

SQL/PSM, SQL Conformance

SQL/Schemata, SQL Conformance

SQL/XML, SQL Conformance

limits and conformance, XML Limits and Conformance to SQL/XML

sqrt, Mathematical Functions and Operators

ssh, Secure TCP/IP Connections with SSH Tunnels

SSI, Introduction

SSL, Secure TCP/IP Connections with SSL, SSL Support

in libpq, Connection Status Functions
with libpq, Parameter Key Words
TLS, Secure TCP/IP Connections with SSL, SSL Support

ssl configuration parameter, SSL

ssl_ca_file configuration parameter, SSL

ssl_cert_file configuration parameter, SSL

ssl_ciphers configuration parameter, SSL

ssl_crl_dir configuration parameter, SSL

ssl_crl_file configuration parameter, SSL

ssl_dh_params_file configuration parameter, SSL

ssl_groups configuration parameter, SSL

ssl_key_file configuration parameter, SSL

ssl_library configuration parameter, Preset Options

ssl_max_protocol_version configuration parameter, SSL

ssl_min_protocol_version configuration parameter, SSL

ssl_passphrase_command configuration parameter, SSL

ssl_passphrase_command_supports_reload configuration parameter, SSL

ssl_prefer_server_ciphers configuration parameter, SSL

ssl_tls13_ciphers configuration parameter, SSL

SSPI, SSPI Authentication

STABLE, Function Volatility Categories

standard deviation, Aggregate Functions

population, Aggregate Functions
sample, Aggregate Functions

standard_conforming_strings configuration parameter, Previous Postgres Pro Shardman Versions

standby server, High Availability, Load Balancing, and Replication

standby.signal, Archive Recovery, Standby Server Operation, Setting Up a Standby Server

for hot standby, Administrator's Overview

standby_mode (see standby.signal)

START TRANSACTION, START TRANSACTION

starts_with, String Functions and Operators

START_REPLICATION, Streaming Replication Protocol

statement_timeout configuration parameter, Statement Behavior

statement_timestamp, Date/Time Functions and Operators

statistics, Aggregate Functions, Statistics Used by the Planner, Extended Statistics, Updating Planner Statistics, The Cumulative Statistics System

of the planner, Statistics Used by the Planner, Extended Statistics, Updating Planner Statistics

stats_fetch_consistency configuration parameter, Cumulative Query and Index Statistics

stddev, Aggregate Functions

stddev_pop, Aggregate Functions

stddev_samp, Aggregate Functions

STONITH, High Availability, Load Balancing, and Replication

storage parameters, Storage Parameters, Storage Parameters for Postgres Pro Shardman, Storage Parameters for Not Sharded Tables

Streaming Replication, High Availability, Load Balancing, and Replication

string (see character string)

strings

backslash quotes, Previous Postgres Pro Shardman Versions
escape warning, Previous Postgres Pro Shardman Versions
standard conforming, Previous Postgres Pro Shardman Versions

string_agg, Aggregate Functions

string_to_array, String Functions and Operators

string_to_table, String Functions and Operators

strip, Text Search Functions and Operators, Manipulating Documents

strpos, String Functions and Operators

subplan, EXPLAIN Basics

hashed, EXPLAIN Basics

subquery, Aggregate Functions, Scalar Subqueries, Subqueries, Subquery Expressions

subscript, Subscripts

substr, String Functions and Operators, Binary String Functions and Operators

substring, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators, SIMILAR TO Regular Expressions, POSIX Regular Expressions

SUBSTRING_REGEX, Differences from SQL Standard and XQuery

subtransactions

in PL/Tcl, Explicit Subtransactions in PL/Tcl

subtransaction_buffers configuration parameter, Memory

sum, Aggregate Functions

summarize_wal configuration parameter, WAL Summarization

superuser, Accessing a Database, Role Attributes

superuser_reserved_connections configuration parameter, Connection Settings

support functions

in_range, B-Tree Support Functions

suppress_redundant_updates_trigger, Trigger Functions

synchronized_standby_slots configuration parameter, Primary Server

synchronize_seqscans configuration parameter, Previous Postgres Pro Shardman Versions

synchronous commit, Asynchronous Commit

Synchronous Replication, High Availability, Load Balancing, and Replication

synchronous_commit configuration parameter, Settings

synchronous_standby_gap configuration parameter, Primary Server

synchronous_standby_names configuration parameter, Primary Server

sync_replication_slots configuration parameter, Standby Servers

syntax, SQL Syntax

SQL, SQL Syntax

syslog_facility configuration parameter, Where to Log

syslog_ident configuration parameter, Where to Log

syslog_sequence_numbers configuration parameter, Where to Log

syslog_split_messages configuration parameter, Where to Log

system catalog, The System Catalog Schema

schema, The System Catalog Schema

systemd, Starting the Database Server

RemoveIPC, systemd RemoveIPC

system_user, Session Information Functions

T

table, Concepts, Table Basics, Modifying Tables

creating, Table Basics
inheritance, Inheritance
modifying, Modifying Tables
partitioning, Table Partitioning
removing, Table Basics
renaming, Renaming a Table

Table Access Method, Table Access Method Interface Definition

TABLE command, SELECT

table expression, Table Expressions

table function, Table Functions, xmltable

XMLTABLE, xmltable

table sampling method, Writing a Table Sampling Method

tableam

Table Access Method, Table Access Method Interface Definition

tableoid, System Columns

TABLESAMPLE method, Writing a Table Sampling Method

tablespace, Tablespaces

default, Statement Behavior
temporary, Statement Behavior

table_am_handler, Pseudo-Types

take_sample, Sampling Functions

take_sample_subset, Sampling Functions, Subsampling Functions

take_subsample, Subsampling Functions

tan, Mathematical Functions and Operators

tand, Mathematical Functions and Operators

tanh, Mathematical Functions and Operators

target list, The Query Tree

Tcl, PL/Tcl — Tcl Procedural Language

tcp_keepalives_count configuration parameter, TCP Settings

tcp_keepalives_idle configuration parameter, TCP Settings

tcp_keepalives_interval configuration parameter, TCP Settings

tcp_user_timeout configuration parameter, TCP Settings

template0, Template Databases

template1, Template Databases

temp_buffers configuration parameter, Memory

temp_file_limit configuration parameter, Disk

temp_tablespaces configuration parameter, Statement Behavior

temp_table_max_size configuration parameter, Disk

text, Character Types, Network Address Functions and Operators

text search, Text Search Types, Text Search Types, Full Text Search, Preferred Index Types for Text Search

data types, Text Search Types
functions and operators, Text Search Types
indexes, Preferred Index Types for Text Search

threads, Behavior in Threaded Programs

with libpq, Behavior in Threaded Programs

tid, Object Identifier Types

time, Date/Time Types, Times

constants, Special Values

current, Current Date/Time

output format, Date/Time Output

(see also formatting)

time span, Date/Time Types

time with time zone, Date/Time Types, Times

time without time zone, Date/Time Types, Times

time zone, Time Zones, Locale and Formatting, POSIX Time Zone Specifications

conversion, AT TIME ZONE and AT LOCAL
input abbreviations, Date/Time Configuration Files
POSIX-style specification, POSIX Time Zone Specifications

time zone names, Locale and Formatting

timelines, Backup and Restore

TIMELINE_HISTORY, Streaming Replication Protocol

timeofday, Date/Time Functions and Operators

timeout

client authentication, Authentication
deadlock, Lock Management

timestamp, Date/Time Types, Time Stamps

timestamp with time zone, Date/Time Types, Time Stamps

timestamp without time zone, Date/Time Types, Time Stamps

timestamptz, Date/Time Types

TimeZone configuration parameter, Locale and Formatting

timezone_abbreviations configuration parameter, Locale and Formatting

to

storage parameter, Index Storage Parameters

TOAST, TOAST

and user-defined types, TOAST Considerations
per-column storage settings, Description, Parameters
per-type storage settings, Description
versus large objects, Introduction

toast_tuple_target storage parameter, Storage Parameters for Not Sharded Tables

token, Lexical Structure

to_ascii, String Functions and Operators

to_bin, String Functions and Operators

to_char, Data Type Formatting Functions

and locales, Behavior

to_date, Data Type Formatting Functions

to_hex, String Functions and Operators

to_json, Processing and Creating JSON Data

to_jsonb, Processing and Creating JSON Data

to_number, Data Type Formatting Functions

to_oct, String Functions and Operators

to_regclass, System Catalog Information Functions

to_regcollation, System Catalog Information Functions

to_regnamespace, System Catalog Information Functions

to_regoper, System Catalog Information Functions

to_regoperator, System Catalog Information Functions

to_regproc, System Catalog Information Functions

to_regprocedure, System Catalog Information Functions

to_regprofile, System Catalog Information Functions

to_regrole, System Catalog Information Functions

to_regtype, System Catalog Information Functions

to_regtypemod, System Catalog Information Functions

to_timestamp, Data Type Formatting Functions, Date/Time Functions and Operators

to_tsquery, Text Search Functions and Operators, Parsing Queries

to_tsvector, Text Search Functions and Operators, Parsing Documents

trace_locks configuration parameter, Developer Options

trace_lock_oidmin configuration parameter, Developer Options

trace_lock_table configuration parameter, Developer Options

trace_lwlocks configuration parameter, Developer Options

trace_notify configuration parameter, Developer Options

trace_sort configuration parameter, Developer Options

trace_userlocks configuration parameter, Developer Options

track_activities configuration parameter, Cumulative Query and Index Statistics

track_activity_query_size configuration parameter, Cumulative Query and Index Statistics

track_commit_timestamp configuration parameter, Sending Servers

track_cost_delay_timing configuration parameter, Cumulative Query and Index Statistics

track_counts configuration parameter, Cumulative Query and Index Statistics

track_fdw_wait_timing configuration parameter, PostgreSQL Settings for a Distributed System

track_functions configuration parameter, Cumulative Query and Index Statistics

track_io_timing configuration parameter, Cumulative Query and Index Statistics

track_wal_io_timing configuration parameter, Cumulative Query and Index Statistics

track_xact_time configuration parameter, PostgreSQL Settings for a Distributed System

transaction, Transactions

transaction ID, Forced shrinking pg_xact and pg_multixact

wraparound, Forced shrinking pg_xact and pg_multixact

transaction isolation, Transaction Isolation

transaction isolation level, Transaction Isolation, Statement Behavior

read committed, Read Committed Isolation Level
repeatable read, Repeatable Read Isolation Level
serializable, Serializable Isolation Level
setting, SET TRANSACTION
setting default, Statement Behavior

transaction log (see WAL)

transaction_buffers configuration parameter, Memory

transaction_deferrable configuration parameter, Statement Behavior

transaction_isolation configuration parameter, Statement Behavior

transaction_read_only configuration parameter, Statement Behavior

transaction_timeout configuration parameter, Statement Behavior

transaction_timestamp, Date/Time Functions and Operators

transform_null_equals configuration parameter, Platform and Client Compatibility

transition tables, CREATE TRIGGER

(see also ephemeral named relation)
implementation in PLs, SPI_register_trigger_data
referencing from C trigger, Writing Trigger Functions in C

translate, String Functions and Operators

TRANSLATE_REGEX, Differences from SQL Standard and XQuery

transparent huge pages, Memory

trigger, Pseudo-Types, Triggers, Writing Trigger Functions in C, Rules Versus Triggers, Trigger Functions, Trigger Functions

arguments for trigger functions, Overview of Trigger Behavior
constraint trigger, Description
for updating a derived tsvector column, Triggers for Automatic Updates
in C, Writing Trigger Functions in C
in PL/pgSQL, Trigger Functions
in PL/Python, Trigger Functions
in PL/Tcl, Trigger Functions in PL/Tcl
compared with rules, Rules Versus Triggers

trim, String Functions and Operators, Binary String Functions and Operators

trim_array, Array Functions and Operators

trim_scale, Mathematical Functions and Operators

troubleshooting, Troubleshooting

true, Boolean Type

trunc, Mathematical Functions and Operators, Network Address Functions and Operators

TRUNCATE, TRUNCATE

trusted, Trusted and Untrusted PL/Perl

PL/Perl, Trusted and Untrusted PL/Perl

tsm_handler, Pseudo-Types

tsquery (data type), tsquery

tsquery_phrase, Text Search Functions and Operators, Manipulating Queries

tsvector (data type), tsvector

tsvector concatenation, Manipulating Documents

tsvector_to_array, Text Search Functions and Operators

tsvector_update_trigger, Trigger Functions

tsvector_update_trigger_column, Trigger Functions

ts_debug, Text Search Functions and Operators, Configuration Testing

ts_delete, Text Search Functions and Operators

ts_filter, Text Search Functions and Operators

ts_headline, Text Search Functions and Operators, Highlighting Results

ts_lexize, Text Search Functions and Operators, Dictionary Testing

ts_parse, Text Search Functions and Operators, Parser Testing

ts_rank, Text Search Functions and Operators, Ranking Search Results

ts_rank_cd, Text Search Functions and Operators, Ranking Search Results

ts_rewrite, Text Search Functions and Operators, Query Rewriting

ts_stat, Text Search Functions and Operators, Gathering Document Statistics

ts_token_type, Text Search Functions and Operators, Parser Testing

txid_current, Transaction ID and Snapshot Information Functions

txid_current_if_assigned, Transaction ID and Snapshot Information Functions

txid_current_snapshot, Transaction ID and Snapshot Information Functions

txid_snapshot_xip, Transaction ID and Snapshot Information Functions

txid_snapshot_xmax, Transaction ID and Snapshot Information Functions

txid_snapshot_xmin, Transaction ID and Snapshot Information Functions

txid_status, Transaction ID and Snapshot Information Functions

txid_visible_in_snapshot, Transaction ID and Snapshot Information Functions

type (see data type)

type cast, Numeric Constants, Type Casts

typedef

in ECPG, Typedefs

U

UESCAPE, Identifiers and Key Words, String Constants with Unicode Escapes

Unicode escape, String Constants with Unicode Escapes

in identifiers, Identifiers and Key Words
in string constants, String Constants with Unicode Escapes

Unicode normalization, String Functions and Operators

unicode_assigned, String Functions and Operators

unicode_nul_character_replacement_in_jsonb configuration parameter, Platform and Client Compatibility

unicode_version, Version Information Functions

UNION, Combining Queries (UNION, INTERSECT, EXCEPT), UNION, CASE, and Related Constructs

determination of result type, UNION, CASE, and Related Constructs

unique constraint, Unique Constraints

unistr, String Functions and Operators

Unix domain socket, Parameter Key Words

unix_socket_directories configuration parameter, Connection Settings

unix_socket_group configuration parameter, Connection Settings

unix_socket_permissions configuration parameter, Connection Settings

unknown, Pseudo-Types

UNLISTEN, UNLISTEN

unnest, Array Functions and Operators

for multirange, Range/Multirange Functions and Operators
for tsvector, Text Search Functions and Operators

unqualified name, The Schema Search Path

updatable views, Updatable Views

UPDATE, Updates, Updating Data, Returning Data from Modified Rows, UPDATE

RETURNING, Returning Data from Modified Rows

update_process_title configuration parameter, Process Title

updating, Updating Data

upgrading, Upgrading a Postgres Pro Shardman Cluster

UPLOAD_MANIFEST, Streaming Replication Protocol

upper, String Functions and Operators, Range/Multirange Functions and Operators

and locales, Behavior

upper_inc, Range/Multirange Functions and Operators

upper_inf, Range/Multirange Functions and Operators

UPSERT, INSERT

URI, Connection Strings

usage_tracking_interval configuration parameter, Prioritization

user, Session Information Functions, Database Roles

current, Session Information Functions

user mapping, Foreign Data

User name maps, User Name Maps

user_catalog_table storage parameter, Storage Parameters for Not Sharded Tables

USE_BONJOUR, Environment variables

USE_BSD_AUTH, Environment variables

USE_ICU, Environment variables

USE_LDAP, Environment variables

USE_LIBUNWIND, Environment variables

USE_LIBXML, Environment variables

USE_LIBXSLT, Environment variables

USE_LLVM, Environment variables

USE_LZ4, Environment variables

USE_OPENSSL, Environment variables

USE_PAM, Environment variables

USE_SYSTEMD, Environment variables

USE_ZSTD, Environment variables

UUID, UUID Type, UUID Functions

generating, UUID Functions

uuid-ossp, uuid-ossp — a UUID generator

uuidv4, UUID Functions

uuidv7, UUID Functions

uuid_extract_timestamp, UUID Functions

uuid_extract_version, UUID Functions

uuid_generate_v1, uuid-ossp Functions

uuid_generate_v1mc, uuid-ossp Functions

uuid_generate_v3, uuid-ossp Functions

V

vacuum, Routine Vacuuming

configuration parameters, Vacuuming

VACUUM, VACUUM

vacuumdb, vacuumdb

vacuumlo, vacuumlo

vacuum_buffer_usage_limit configuration parameter, Memory

vacuum_cost_delay configuration parameter, Cost-based Vacuum Delay

vacuum_cost_limit configuration parameter, Cost-based Vacuum Delay

vacuum_cost_page_dirty configuration parameter, Cost-based Vacuum Delay

vacuum_cost_page_hit configuration parameter, Cost-based Vacuum Delay

vacuum_cost_page_miss configuration parameter, Cost-based Vacuum Delay

vacuum_failsafe_age configuration parameter, Freezing

vacuum_freeze_min_age configuration parameter, Freezing

vacuum_freeze_table_age configuration parameter, Freezing

vacuum_index_cleanup storage parameter, Storage Parameters for Not Sharded Tables

vacuum_max_eager_freeze_failure_rate

configuration parameter, Freezing
storage parameter, Storage Parameters for Not Sharded Tables

vacuum_multixact_failsafe_age configuration parameter, Freezing

vacuum_multixact_freeze_min_age configuration parameter, Freezing

vacuum_multixact_freeze_table_age configuration parameter, Freezing

vacuum_truncate

configuration parameter, Default Behavior
storage parameter, Storage Parameters for Not Sharded Tables

vacuum_update_datfrozenxid_only_when_needed configuration parameter, Freezing

value expression, Value Expressions

VALUES, VALUES Lists, UNION, CASE, and Related Constructs, VALUES

determination of result type, UNION, CASE, and Related Constructs

varchar, Character Types

variadic function, SQL Functions with Variable Numbers of Arguments

variance, Aggregate Functions

population, Aggregate Functions
sample, Aggregate Functions

var_pop, Aggregate Functions

var_samp, Aggregate Functions

version, Accessing a Database, Version Information Functions, Upgrading a Postgres Pro Shardman Cluster

compatibility, Upgrading a Postgres Pro Shardman Cluster

view, Views, Views and the Rule System, Materialized Views, Cooperation with Views

implementation through rules, Views and the Rule System
materialized, Materialized Views
updating, Cooperation with Views

Visibility Map, Visibility Map

VM (see Visibility Map)

void, Pseudo-Types

VOLATILE, Function Volatility Categories

volatility, Function Volatility Categories

functions, Function Volatility Categories

VPATH, Extension Building Infrastructure

W

WAL, Reliability and the Write-Ahead Log

wal_block_size configuration parameter, Preset Options

wal_buffers configuration parameter, Settings

wal_compression configuration parameter, Settings

wal_consistency_checking configuration parameter, Developer Options

wal_debug configuration parameter, Developer Options

wal_decode_buffer_size configuration parameter, Recovery

wal_init_zero configuration parameter, Settings

wal_keep_size configuration parameter, Sending Servers

wal_level configuration parameter, Settings

wal_log_hints configuration parameter, Settings

wal_receiver_create_temp_slot configuration parameter, Standby Servers

wal_receiver_status_interval configuration parameter, Standby Servers

wal_receiver_timeout configuration parameter, Standby Servers

wal_recycle configuration parameter, Settings

wal_retrieve_retry_interval configuration parameter, Standby Servers

wal_segment_size configuration parameter, Preset Options

wal_sender_check_crc configuration parameter, Settings

wal_sender_panic_on_crc_error configuration parameter, Settings

wal_sender_timeout configuration parameter, Sending Servers

wal_skip_threshold configuration parameter, Settings

wal_summary_keep_time configuration parameter, WAL Summarization

wal_sync_method configuration parameter, Settings

wal_writer_delay configuration parameter, Settings

wal_writer_flush_after configuration parameter, Settings

warm standby, High Availability, Load Balancing, and Replication

websearch_to_tsquery, Text Search Functions and Operators

WHERE, The WHERE Clause

where to log, Where to Log

WHILE

in PL/pgSQL, WHILE

width, Geometric Functions and Operators

width_bucket, Mathematical Functions and Operators

window function, Window Functions, Window Function Calls, Window Function Processing, Window Functions

built-in, Window Functions
invocation, Window Function Calls
order of execution, Window Function Processing

wipe_file_on_delete configuration parameter, Memory Purge

wipe_heaptuple_on_delete configuration parameter, Memory Purge

wipe_memctx_on_free configuration parameter, Memory Purge

wipe_mem_on_free configuration parameter, Memory Purge

wipe_xlog_on_free configuration parameter, Memory Purge

WITH, WITH Queries (Common Table Expressions), SELECT

in SELECT, WITH Queries (Common Table Expressions), SELECT

WITH CHECK OPTION, CREATE VIEW

WITHIN GROUP, Aggregate Expressions

witness server, High Availability, Load Balancing, and Replication

work_mem configuration parameter, Memory

wraparound

of multixact IDs, Shrinking pg_multixact
of transaction IDs, Forced shrinking pg_xact and pg_multixact

X

xid, Object Identifier Types
xid8, Object Identifier Types
xmax, System Columns
xmin, System Columns
XML, XML Type
XML export, Mapping Tables to XML
XML Functions, XML Functions
XML option, Creating XML Values, Statement Behavior
xmlagg, xmlagg, Aggregate Functions
xmlbinary configuration parameter, Statement Behavior
xmlcomment, xmlcomment
xmlconcat, xmlconcat
xmlelement, xmlelement
XMLEXISTS, XMLEXISTS
xmlforest, xmlforest
xmloption configuration parameter, Statement Behavior
xmlparse, Creating XML Values
xmlpi, xmlpi
xmlroot, xmlroot
xmlserialize, Creating XML Values
xmltable, xmltable
xmltext, xmltext
xml_is_well_formed, xml_is_well_formed
xml_is_well_formed_content, xml_is_well_formed
xml_is_well_formed_document, xml_is_well_formed
xml_parse_huge configuration parameter, Memory
XPath, xpath
xpath_exists, xpath_exists
XQuery regular expressions, Differences from SQL Standard and XQuery

Z

zero_damaged_pages configuration parameter, Developer Options

Prev	Up
Bibliography	Home