Index
Prev	Up	Postgres Pro Standard 13.23.1 Documentation	Home

Index

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Z

Symbols

$, Positional Parameters
$libdir, Dynamic Loading
$libdir/plugins, Shared Library Preloading, Description
*, Select-List Items
.pgpass, The Password File
.pg_service.conf, The Connection Service File
::, Type Casts
_PG_fini, Dynamic Loading
_PG_init, Dynamic Loading
_PG_output_plugin_init, Initialization Function

A

abbrev, Network Address Functions and Operators

ABORT, ABORT

abs, Mathematical Functions and Operators

ACL, Privileges

aclcontains, System Information Functions and Operators

acldefault, System Information Functions and Operators

aclexplode, System Information Functions and Operators

aclitem, Privileges

aclitemeq, System Information Functions and Operators

acos, Mathematical Functions and Operators

acosd, Mathematical Functions and Operators

acosh, Mathematical Functions and Operators

administration tools

externally maintained, Administration Tools

adminpack, adminpack

advisory lock, Advisory Locks

age, Date/Time Functions and Operators, System Information Functions and Operators

aggregate function, Aggregate Functions, Aggregate Expressions, Aggregate Functions, User-Defined Aggregates

built-in, Aggregate Functions
invocation, Aggregate Expressions
moving aggregate, Moving-Aggregate Mode
ordered set, Ordered-Set Aggregates
partial aggregation, Partial Aggregation
polymorphic, Polymorphic and Variadic Aggregates
support functions for, Support Functions for Aggregates
user-defined, User-Defined Aggregates
variadic, Polymorphic and Variadic Aggregates

AIX

IPC configuration, Shared Memory and Semaphores

akeys, hstore Operators and Functions

alias, Table and Column Aliases, Column Labels

for table name in query, Joins Between Tables
in the FROM clause, Table and Column Aliases
in the select list, Column Labels

ALL, Subquery Expressions, Row and Array Comparisons

allow_in_place_tablespaces configuration parameter, Developer Options

allow_system_table_mods configuration parameter, Developer Options

ALTER AGGREGATE, ALTER AGGREGATE

ALTER COLLATION, ALTER COLLATION

ALTER CONVERSION, ALTER CONVERSION

ALTER DATABASE, ALTER DATABASE

ALTER DEFAULT PRIVILEGES, ALTER DEFAULT PRIVILEGES

ALTER DOMAIN, ALTER DOMAIN

ALTER EVENT TRIGGER, ALTER EVENT TRIGGER

ALTER EXTENSION, ALTER EXTENSION

ALTER FOREIGN DATA WRAPPER, ALTER FOREIGN DATA WRAPPER

ALTER FOREIGN TABLE, ALTER FOREIGN TABLE

ALTER FUNCTION, ALTER FUNCTION

ALTER GROUP, ALTER GROUP

ALTER INDEX, ALTER INDEX

ALTER LANGUAGE, ALTER LANGUAGE

ALTER LARGE OBJECT, ALTER LARGE OBJECT

ALTER MATERIALIZED VIEW, ALTER MATERIALIZED VIEW

ALTER OPERATOR, ALTER OPERATOR

ALTER OPERATOR CLASS, ALTER OPERATOR CLASS

ALTER OPERATOR FAMILY, ALTER OPERATOR FAMILY

ALTER POLICY, ALTER POLICY

ALTER PROCEDURE, ALTER PROCEDURE

ALTER PUBLICATION, ALTER PUBLICATION

ALTER ROLE, Role Attributes, ALTER ROLE

ALTER ROUTINE, ALTER ROUTINE

ALTER RULE, ALTER RULE

ALTER SCHEMA, ALTER SCHEMA

ALTER SEQUENCE, ALTER SEQUENCE

ALTER SERVER, ALTER SERVER

ALTER STATISTICS, ALTER STATISTICS

ALTER SUBSCRIPTION, ALTER SUBSCRIPTION

ALTER SYSTEM, ALTER SYSTEM

ALTER TABLE, ALTER TABLE

ALTER TABLESPACE, ALTER TABLESPACE

ALTER TEXT SEARCH CONFIGURATION, ALTER TEXT SEARCH CONFIGURATION

ALTER TEXT SEARCH DICTIONARY, ALTER TEXT SEARCH DICTIONARY

ALTER TEXT SEARCH PARSER, ALTER TEXT SEARCH PARSER

ALTER TEXT SEARCH TEMPLATE, ALTER TEXT SEARCH TEMPLATE

ALTER TRIGGER, ALTER TRIGGER

ALTER TYPE, ALTER TYPE

ALTER USER, ALTER USER

ALTER USER MAPPING, ALTER USER MAPPING

ALTER VIEW, ALTER VIEW

amcheck, amcheck

ANALYZE, Updating Planner Statistics, ANALYZE

AND (operator), Logical Operators

anonymous code blocks, DO

any, Pseudo-Types

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

anyarray, Pseudo-Types

anyarray_elemtype, Functions

anyarray_to_text, Functions

anycompatible, Pseudo-Types

anycompatiblearray, Pseudo-Types

anycompatiblenonarray, Pseudo-Types

anycompatiblerange, Pseudo-Types

anyelement, Pseudo-Types

anyenum, Pseudo-Types

anynonarray, Pseudo-Types

anyrange, Pseudo-Types

applicable role, applicable_roles

application_name configuration parameter, What to Log

aqo, aqo

aqo.mode configuration parameter, Configuration

arbitrary precision numbers, Arbitrary Precision Numbers

archive_cleanup_command configuration parameter, Archive Recovery

archive_command configuration parameter, Archiving

archive_mode configuration parameter, Archiving

archive_timeout configuration parameter, Archiving

area, Geometric Functions and Operators

armor, armor(), dearmor()

array, Arrays

accessing, Accessing Arrays
constant, Array Value Input
constructor, Array Constructors
declaration, Declaration of Array Types
I/O, Array Input and Output Syntax
modifying, Modifying Arrays
of user-defined type, User-Defined Types
searching, Searching in Arrays

ARRAY, Array Constructors, UNION, CASE, and Related Constructs

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

array_agg, Aggregate Functions, Functions

array_append, Array Functions and Operators

array_cat, Array Functions and Operators

array_dims, Array Functions and Operators

array_fill, Array Functions and Operators

array_length, Array Functions and Operators

array_lower, Array Functions and Operators

array_ndims, Array Functions and Operators

array_nulls configuration parameter, Previous Postgres Pro Versions

array_position, Array Functions and Operators

array_positions, Array Functions and Operators

array_prepend, Array Functions and Operators

array_remove, Array Functions and Operators

array_replace, Array Functions and Operators

array_to_json, Processing and Creating JSON Data

array_to_string, Array Functions and Operators

array_to_tsvector, Text Search Functions and Operators

array_upper, Array Functions and Operators

ascii, String Functions and Operators

asin, Mathematical Functions and Operators

asind, Mathematical Functions and Operators

asinh, Mathematical Functions and Operators

ASSERT

in PL/pgSQL, Checking Assertions

assertions

in PL/pgSQL, Checking Assertions

asynchronous commit, Asynchronous Commit

AT TIME ZONE, AT TIME ZONE

atan, Mathematical Functions and Operators

atan2, Mathematical Functions and Operators

atan2d, Mathematical Functions and Operators

atand, Mathematical Functions and Operators

atanh, Mathematical Functions and Operators

attach

storage parameter, Index Storage Parameters

authentication_timeout configuration parameter, Authentication

auth_delay, auth_delay

auth_delay.milliseconds configuration parameter, Configuration Parameters

auto-increment (see serial)

autocommit

bulk-loading data, Disable Autocommit
psql, Variables

autosummarize storage parameter, Index Storage Parameters

autovacuum

configuration parameters, Automatic Vacuuming
general information, The Autovacuum Daemon

autovacuum configuration parameter, Automatic Vacuuming

autovacuum_analyze_scale_factor

configuration parameter, Automatic Vacuuming
storage parameter, Storage Parameters

autovacuum_analyze_threshold

configuration parameter, Automatic Vacuuming
storage parameter, Storage Parameters

autovacuum_enabled storage parameter, Storage Parameters

autovacuum_freeze_max_age

configuration parameter, Automatic Vacuuming
storage parameter, Storage Parameters

autovacuum_freeze_min_age storage parameter, Storage Parameters

autovacuum_freeze_table_age storage parameter, Storage Parameters

autovacuum_max_workers configuration parameter, Automatic Vacuuming

autovacuum_multixact_freeze_max_age

configuration parameter, Automatic Vacuuming
storage parameter, Storage Parameters

autovacuum_multixact_freeze_min_age storage parameter, Storage Parameters

autovacuum_multixact_freeze_table_age storage parameter, Storage Parameters

autovacuum_naptime configuration parameter, Automatic Vacuuming

autovacuum_vacuum_cost_delay

configuration parameter, Automatic Vacuuming
storage parameter, Storage Parameters

autovacuum_vacuum_cost_limit

configuration parameter, Automatic Vacuuming
storage parameter, Storage Parameters

autovacuum_vacuum_insert_scale_factor

configuration parameter, Automatic Vacuuming
storage parameter, Storage Parameters

autovacuum_vacuum_insert_threshold

configuration parameter, Automatic Vacuuming
storage parameter, Storage Parameters

autovacuum_vacuum_scale_factor

configuration parameter, Automatic Vacuuming
storage parameter, Storage Parameters

autovacuum_vacuum_threshold

configuration parameter, Automatic Vacuuming
storage parameter, Storage Parameters

autovacuum_work_mem configuration parameter, Memory

auto_explain, auto_explain

auto_explain.log_analyze configuration parameter, Configuration Parameters

auto_explain.log_buffers configuration parameter, Configuration Parameters

auto_explain.log_format configuration parameter, Configuration Parameters

auto_explain.log_level configuration parameter, Configuration Parameters

auto_explain.log_min_duration configuration parameter, Configuration Parameters

auto_explain.log_nested_statements configuration parameter, Configuration Parameters

auto_explain.log_settings configuration parameter, Configuration Parameters

auto_explain.log_timing configuration parameter, Configuration Parameters

auto_explain.log_triggers configuration parameter, Configuration Parameters

auto_explain.log_verbose configuration parameter, Configuration Parameters

auto_explain.log_wal configuration parameter, Configuration Parameters

auto_explain.sample_rate configuration parameter, Configuration Parameters

avals, hstore Operators and Functions

average, Aggregate Functions

avg, Aggregate Functions

B

B-tree (see index)

backend_flush_after configuration parameter, Asynchronous Behavior

Background workers, Background Worker Processes

backslash escapes, String Constants with C-Style Escapes

backslash_quote configuration parameter, Previous Postgres Pro Versions

backtrace_functions configuration parameter, Developer Options

backup, Backup Control Functions, Backup and Restore

Backup Manifest, Backup Manifest Format

base type, The Postgres Pro Type System

base64 format, Binary String Functions and Operators

BASE_BACKUP, Streaming Replication Protocol

BEGIN, BEGIN

BETWEEN, Comparison Functions and Operators

BETWEEN SYMMETRIC, Comparison Functions and Operators

BGWORKER_BACKEND_DATABASE_CONNECTION, Background Worker Processes

BGWORKER_SHMEM_ACCESS, Background Worker Processes

bgwriter_delay configuration parameter, Background Writer

bgwriter_flush_after configuration parameter, Background Writer

bgwriter_lru_maxpages configuration parameter, Background Writer

bgwriter_lru_multiplier configuration parameter, Background Writer

bigint, Numeric Constants, Integer Types

bigserial, Serial Types

binary data, Binary Data Types, Binary String Functions and Operators

functions, Binary String Functions and Operators

binary string

concatenation, Binary String Functions and Operators
converting to character string, Binary String Functions and Operators
length, Binary String Functions and Operators

bit string, Bit-String Constants, Bit String Types

constant, Bit-String Constants
data type, Bit String Types
length, Bit String Functions and Operators

bit strings, Bit String Functions and Operators

functions, Bit String Functions and Operators

bitmap scan, Combining Multiple Indexes, Planner Method Configuration

bit_and, Aggregate Functions

bit_length, String Functions and Operators, Binary String Functions and Operators, Bit String Functions and Operators

bit_or, Aggregate Functions

BLOB (see large object)

block_size configuration parameter, Preset Options

bloom, bloom

bonjour configuration parameter, Connection Settings

bonjour_name configuration parameter, Connection Settings

Boolean, Boolean Type

data type, Boolean Type
operators (see operators, logical)

bool_and, Aggregate Functions

bool_or, Aggregate Functions

booting

starting the server during, Starting the Database Server

bound_box, Geometric Functions and Operators

box, Geometric Functions and Operators

box (data type), Boxes

BRIN (see index)

brin_desummarize_range, Index Maintenance Functions

brin_metapage_info, BRIN Functions

brin_page_items, BRIN Functions

brin_page_type, BRIN Functions

brin_revmap_data, BRIN Functions

brin_summarize_new_values, Index Maintenance Functions

brin_summarize_range, Index Maintenance Functions

broadcast, Network Address Functions and Operators

BSD Authentication, BSD Authentication

btree_gin, btree_gin

btree_gist, btree_gist

btrim, String Functions and Operators, Binary String Functions and Operators

bt_index_check, Functions

bt_index_parent_check, Functions

bt_metap, B-Tree Functions

bt_page_items, B-Tree Functions

bt_page_stats, B-Tree Functions

buffering storage parameter, Index Storage Parameters

bytea, Binary Data Types

bytea_output configuration parameter, Statement Behavior

C

C, libpq — C Library, ECPG — Embedded SQL in C

C++, Using C++ for Extensibility

CALL, CALL

canceling, Canceling Queries in Progress

SQL command, Canceling Queries in Progress

cardinality, Array Functions and Operators

CASCADE, Dependency Tracking

with DROP, Dependency Tracking
foreign key action, Foreign Keys

Cascading Replication, High Availability, Load Balancing, and Replication

CASE, Conditional Expressions, UNION, CASE, and Related Constructs

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

case sensitivity

of SQL commands, Identifiers and Key Words

cast, CREATE CAST

I/O conversion, CREATE CAST

cbrt, Mathematical Functions and Operators

ceil, Mathematical Functions and Operators

ceiling, Mathematical Functions and Operators

center, Geometric Functions and Operators

Certificate, Certificate Authentication

chained transactions, Transaction Management, Parameters, Parameters

in PL/pgSQL, Transaction Management

char, Character Types

character, Character Types

character set, Locale and Formatting, Preset Options, Character Set Support

character string, String Constants, Character Types

concatenation, String Functions and Operators
constant, String Constants
converting to binary string, Binary String Functions and Operators
data types, Character Types
length, String Functions and Operators

character varying, Character Types

character_length, String Functions and Operators

char_length, String Functions and Operators

check constraint, Check Constraints

CHECK OPTION, CREATE VIEW

checkpoint, WAL Configuration

CHECKPOINT, CHECKPOINT

checkpoint_completion_target configuration parameter, Checkpoints

checkpoint_flush_after configuration parameter, Checkpoints

checkpoint_timeout configuration parameter, Checkpoints

checkpoint_warning configuration parameter, Checkpoints

check_function_bodies configuration parameter, Statement Behavior

chr, String Functions and Operators

cid, Object Identifier Types

cidr, cidr

circle, Circles, Geometric Functions and Operators

citext, citext

client authentication, Client Authentication

timeout during, Authentication

client_encoding configuration parameter, Locale and Formatting

client_min_messages configuration parameter, Statement Behavior

clock_timestamp, Date/Time Functions and Operators

CLOSE, CLOSE

cluster

of databases (see database cluster)

CLUSTER, CLUSTER

clusterdb, clusterdb

clustering, High Availability, Load Balancing, and Replication

cluster_name configuration parameter, Process Title

cmax, System Columns

cmin, System Columns

COALESCE, COALESCE

COLLATE, Collation Expressions

collation, Collation Support

in PL/pgSQL, Collation of PL/pgSQL Variables
in SQL functions, SQL Functions with Collations

COLLATION FOR, System Information Functions and Operators

color, Color Support

column, Concepts, Table Basics

adding, Adding a Column
removing, Removing a Column
renaming, Renaming a Column
system column, System Columns

column data type

changing, Changing a Column's Data Type

column reference, Column References

col_description, System Information Functions and Operators

comment, Comments

about database objects, System Information Functions and Operators
in SQL, Comments

COMMENT, COMMENT

COMMIT, COMMIT

COMMIT PREPARED, COMMIT PREPARED

commit_delay configuration parameter, Settings

commit_siblings configuration parameter, Settings

common table expression (see WITH)

comparison, Comparison Functions and Operators, Subquery Expressions

composite type, Row and Array Comparisons
operators, Comparison Functions and Operators
row constructor, Row and Array Comparisons
subquery result row, Subquery Expressions

compiling, Building libpq Programs

libpq applications, Building libpq Programs

composite type, Composite Types, The Postgres Pro Type System

comparison, Row and Array Comparisons
constant, Constructing Composite Values
constructor, Row Constructors

computed field, Using Composite Types in Queries

concat, String Functions and Operators

concat_ws, String Functions and Operators

concurrency, Concurrency Control

conditional expression, Conditional Expressions

configuration

of recovery

of a standby server, Archive Recovery

of the server, Server Configuration

of the server

functions, Configuration Settings Functions

config_file configuration parameter, File Locations

conjunction, Logical Operators

connectby, Functions Provided, connectby

connection service file, The Connection Service File

conninfo, Connection Strings

constant, Constants

constraint, Constraints

adding, Adding a Constraint
check, Check Constraints
exclusion, Exclusion Constraints
foreign key, Foreign Keys
name, Check Constraints
NOT NULL, Not-Null Constraints
primary key, Primary Keys
removing, Removing a Constraint
unique, Unique Constraints

constraint exclusion, Partitioning and Constraint Exclusion, Other Planner Options

constraint_exclusion configuration parameter, Other Planner Options

container type, The Postgres Pro Type System

CONTINUE

in PL/pgSQL, CONTINUE

continuous archiving, Backup and Restore

in standby, Continuous Archiving in Standby

control file, Extension Files

convert, Binary String Functions and Operators

convert_from, Binary String Functions and Operators

convert_to, Binary String Functions and Operators

COPY, Populating a Table With Rows, Functions Associated with the COPY Command, COPY

with libpq, Functions Associated with the COPY Command

corr, Aggregate Functions

correlation, Aggregate Functions

in the query planner, Extended Statistics

cos, Mathematical Functions and Operators

cosd, Mathematical Functions and Operators