Hubwiz.com
|
Online Course
|
API Manual
PostgreSQL API Manual
Query(429)
Function(1893)
Guide(33)
Setting(319)
Type(197)
View(158)
Procedure(52)
Command(20)
(2)
Environment(29)
Error(241)
Query
Positional Parameters
$
Description
$libdir/plugins
Select-List Items
*
Type Casts
::
ABORT
Aggregate Expressions
aggregate function
Table and Column Aliases
alias
Column Labels
alias
ALL
ALL
ALTER AGGREGATE
ALTER COLLATION
ALTER CONVERSION
ALTER DATABASE
ALTER DEFAULT PRIVILEGES
ALTER DOMAIN
ALTER EVENT TRIGGER
ALTER EXTENSION
ALTER FOREIGN DATA WRAPPER
ALTER FOREIGN TABLE
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER LARGE OBJECT
ALTER MATERIALIZED VIEW
ALTER OPERATOR
ALTER OPERATOR CLASS
ALTER OPERATOR FAMILY
ALTER POLICY
ALTER PROCEDURE
ALTER PUBLICATION
ALTER ROLE
ALTER ROLE
ALTER ROUTINE
ALTER RULE
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER STATISTICS
ALTER SUBSCRIPTION
ALTER SYSTEM
ALTER TABLE
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TEXT SEARCH PARSER
ALTER TEXT SEARCH TEMPLATE
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER USER MAPPING
ALTER VIEW
ANALYZE
ANALYZE
AND
DO
anonymous code blocks
ANY
ANY
ANY
Array Constructors
ARRAY
ARRAY
AT TIME ZONE
String Constants with C-style Escapes
backslash escapes
BEGIN
BETWEEN
BETWEEN SYMMETRIC
Numeric Constants
Bit-string Constants
bit string
CALL
CASCADE
CASE
CASE
CREATE CAST
cast
String Constants
character string
CREATE VIEW
CHECK OPTION
CHECKPOINT
CLOSE
CLUSTER
COALESCE
Collation Expressions
COLLATE
Column References
Comments
COMMENT
COMMIT
COMMIT PREPARED
WITH
Constants
COPY
COPY
COPY
CREATE ACCESS METHOD
CREATE AGGREGATE
CREATE COLLATION
CREATE CONVERSION
CREATE DATABASE
CREATE DATABASE
CREATE DOMAIN
CREATE EVENT TRIGGER
CREATE EXTENSION
CREATE FOREIGN DATA WRAPPER
CREATE FOREIGN TABLE
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE LANGUAGE
CREATE MATERIALIZED VIEW
CREATE OPERATOR
CREATE OPERATOR CLASS
CREATE OPERATOR FAMILY
CREATE POLICY
CREATE PROCEDURE
CREATE PUBLICATION
CREATE ROLE
CREATE ROLE
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE STATISTICS
CREATE SUBSCRIPTION
CREATE TABLE
CREATE TABLE
CREATE TABLE AS
CREATE TABLESPACE
CREATE TABLESPACE
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TEXT SEARCH PARSER
CREATE TEXT SEARCH TEMPLATE
CREATE TRANSFORM
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE USER MAPPING
Joined Tables
cross join
GROUPING SETS, CUBE, and ROLLUP
CUBE
cursor
DECLARE
cursor
EXPLAIN
cursor
FETCH
cursor
MOVE
cursor
Identifiers and Key Words
Row Constructors
CONTINUE
DEALLOCATE
DELETE
DELETE
DELETE
DISCARD
DISTINCT
DISTINCT
Dollar-quoted String Constants
dollar quoting
DROP ACCESS METHOD
DROP AGGREGATE
DROP CAST
DROP COLLATION
DROP CONVERSION
DROP DATABASE
DROP DATABASE
DROP DOMAIN
DROP EVENT TRIGGER
DROP EXTENSION
DROP FOREIGN DATA WRAPPER
DROP FOREIGN TABLE
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MATERIALIZED VIEW
DROP OPERATOR
DROP OPERATOR CLASS
DROP OPERATOR FAMILY
DROP OWNED
DROP POLICY
DROP PROCEDURE
DROP PUBLICATION
DROP ROLE
DROP ROLE
DROP ROUTINE
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP STATISTICS
DROP SUBSCRIPTION
DROP TABLE
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TEXT SEARCH PARSER
DROP TEXT SEARCH TEMPLATE
DROP TRANSFORM
DROP TRIGGER
DROP TYPE
DROP USER
DROP USER MAPPING
DROP VIEW
duplicates
Constants of Other Types
SET TRANSACTION
END
escape string syntax
Combining Queries
EXCEPT
EXECUTE
EXISTS
EXPLAIN
Value Expressions
expression
Expression Evaluation Rules
Field Selection
FILTER
Table Functions
function
The GROUP BY and HAVING Clauses
functional dependency
Function Calls
Using Mixed Notation
Using Named Notation
Using Positional Notation
GRANT
GRANT
GREATEST
GREATEST
GROUP BY
GROUP BY
grouping
GROUPING
GROUPING SETS
HAVING
HAVING
Parameters
ICU
identifier
IMMUTABLE
IMPORT FOREIGN SCHEMA
IN
IN
Building Indexes Concurrently
index
INSERT
INSERT
INSERT
INTERSECT
IS DISTINCT FROM
IS DISTINCT FROM
IS DOCUMENT
IS FALSE
IS NOT DISTINCT FROM
IS NOT DISTINCT FROM
IS NOT DOCUMENT
IS NOT FALSE
IS NOT NULL
IS NOT TRUE
IS NOT UNKNOWN
IS NULL
IS NULL
IS TRUE
IS UNKNOWN
ISNULL
join
key word
LATERAL Subqueries
LATERAL
LEAST
LEAST
left join
LIKE
LIMIT and OFFSET
LIMIT
LISTEN
LOAD
LOCK
median
name
natural join
NOT
NOT IN
NOT IN
Calling Functions
notation
NOTIFY
NOTIFY
NOTNULL
NULLIF
OFFSET
ON CONFLICT
The FROM Clause
ONLY
Operators
Operator Precedence
OR
ORDER BY
Sorting Rows
ORDER BY
ordered-set aggregate
outer join
Window Function Calls
OVER clause
OVERLAPS
Operator Invocations
parenthesis
PATH
pg_notify
PREPARE
PREPARE TRANSACTION
prepared statements
prepared statements
prepared statements
prepared statements
Writing SECURITY DEFINER Functions Safely
REASSIGN OWNED
RECURSIVE
REFRESH MATERIALIZED VIEW
REINDEX
RELEASE SAVEPOINT
RESET
RESTRICT
RETURNING
RETURNING INTO
REVOKE
REVOKE
right join
ROLLBACK
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
ROLLUP
ROW
SELECT in WITH
RETURN NEXT
SAVEPOINT
savepoints
savepoints
savepoints
SECURITY LABEL
SELECT
SELECT
SELECT
SELECT
SELECT INTO
SELECT INTO
SET
SET
SET CONSTRAINTS
set difference
set intersection
set operation
SET ROLE
SET SESSION AUTHORIZATION
set union
SET XML OPTION
SHOW
SHOW
SHOW
SIMILAR TO
SOME
SOME
SOME
sorting
STABLE
START TRANSACTION
Storage Parameters
Scalar Subqueries
subquery
Subqueries
subquery
Subscripts
Select Lists
TABLE command
Table Expressions
Lexical Structure
token
transition tables
TRUNCATE
type cast
Description
UESCAPE
String Constants with Unicode Escapes
Unicode escape
UNION
UNION
UNLISTEN
Updatable Views
UPDATE
UPDATE
UPSERT
URI
VACUUM
VALUES Lists
VALUES
VALUES
VALUES
VOLATILE
The WHERE Clause
WHERE
window function
Window Function Processing
window function
WITH Queries (Common Table Expressions)
WITH
WITH
WITH CHECK OPTION
WITHIN GROUP
XML
XMLEXISTS
Function
Dynamic Loading
$libdir
Shared Library Preloading
$libdir/plugins
The Password File
.pgpass
The Connection Service File
.pg_service.conf
_PG_fini
_PG_init
Initialization Function
_PG_output_plugin_init
Network Address Functions and Operators
abbrev
Mathematical Functions and Operators
abs
acos
acosd
adminpack
Advisory Locks
Date/Time Functions and Operators
age
Aggregate Functions
User-defined Aggregates
aggregate function
AIX
hstore Operators and Functions
akeys
Subquery Expressions
Row and Array Comparisons
Developer Options
Role Attributes
amcheck
Updating Planner Statistics
Logical Operators
applicable role
What To Log
Archive Recovery Settings
archive_cleanup_command recovery parameter
Archiving
Geometric Functions and Operators
area
armor
UNION, CASE, and Related Constructs
array_agg
Functions
array_agg
Array Functions and Operators
array_append
array_cat
array_dims
array_fill
array_length
array_lower
array_ndims
Previous PostgreSQL Versions
array_position
array_positions
array_prepend
array_remove
array_replace
JSON Functions and Operators
array_to_json
array_to_string
Text Search Functions and Operators
array_to_tsvector
array_upper
String Functions and Operators
ascii
asin
asind
Asynchronous Commit
atan
atan2
atan2d
atand
Authentication
auth_delay
Configuration Parameters
auto-increment (see
Automatic Vacuuming
Memory
auto_explain
Configuration Parameters
avals
average
avg
Administration Tools
Moving-Aggregate Mode
Ordered-Set Aggregates
Partial Aggregation
Polymorphic and Variadic Aggregates
Support Functions for Aggregates
Shared Memory and Semaphores
User-defined Types
Disable Autocommit
Variables
The Autovacuum Daemon
index
B-tree (see
Asynchronous Behavior
Background Worker Processes
Background workers
Backup Control Functions
backup
Backup and Restore
backup
Streaming Replication Protocol
BASE_BACKUP
Comparison Functions and Operators
BGWORKER_BACKEND_DATABASE_CONNECTION
BGWORKER_SHMEM_ACCESS
Background Writer
Binary String Functions and Operators
binary data
Requirements
bison
Bit String Functions and Operators
bit strings
Combining Multiple Indexes
bitmap scan
Planner Method Configuration
bitmap scan
bit_and
bit_length
bit_or
large object
BLOB (see
Preset Options
bloom
Connection Settings
bool_and
bool_or
BRIN (see
Index Maintenance Functions
brin_desummarize_range
BRIN Functions
brin_metapage_info
brin_page_items
brin_page_type
brin_revmap_data
brin_summarize_new_values
brin_summarize_range
broadcast
BSD Authentication
btree_gin
btree_gist
btrim
btrim
Functions
bt_index_check
bt_index_parent_check
B-tree Functions
bt_metap
bt_page_items
bt_page_stats
Statement Behavior
Starting the Database Server
libpq - C Library
C
ECPG - Embedded SQL in C
C
Using C++ for Extensibility
C++
Canceling Queries in Progress
canceling
cardinality
Dependency Tracking
High Availability, Load Balancing, and Replication
Cascading Replication
Conditional Expressions
cbrt
ceil
ceiling
center
Certificate Authentication
Certificate
Locale and Formatting
character set
character set
Character Set Support
character set
char_length
Check Constraints
WAL Configuration
checkpoint
Checkpoints
chr
citext
Client Authentication
clock_timestamp
clustering
Process Title
System Columns
cmax
cmin
Collation Support
collation
System Information Functions
collation for
Table Basics
column
col_description
Settings
common table expression (see
comparison
comparison
Building libpq Programs
compiling
concat
concat_ws
Concurrency Control
concurrency
Installation Procedure
configure
File Locations
conjunction
Functions Provided
connectby
connection service file
Connection Strings
conninfo
Constraints
Partitioning and Constraint Exclusion
constraint exclusion
Other Planner Options
constraint exclusion
continuous archiving
Extension Files
control file
convert
convert_from
convert_to
Functions Associated with the COPY Command
corr
correlation
cos
cosd
cot
cotd
count
covar_pop
covar_samp
Index-Only Scans and Covering Indexes
covering index
Planner Cost Constants
Creating a Database
Database Roles
Tablespaces
CREATE_REPLICATION_SLOT
cross compilation
crosstab(text)
crosstab
crosstabN(text)
crosstab(text, text)
crypt
ctid
View Rules in Non-SELECT Statements
CTID
cube
Window Functions
cume_dist
current_catalog
current_database
current_date
current_query
current_role
current_schema
current_schemas
Configuration Settings Functions
current_setting
current_time
current_timestamp
current_user
Sequence Manipulation Functions
currval
Writing A Custom Scan Provider
custom scan provider
Cygwin
Foreign Keys
database cluster
SQL Functions with Collations
Adding a Column
Removing a Column
Renaming a Column
Changing a Column's Data Type
Server Configuration
Adding a Constraint
Exclusion Constraints
Not-Null Constraints
Primary Keys
Removing a Constraint
Unique Constraints
Continuous archiving in standby
Extended Statistics
Where To Log
data area (see
data partitioning
Data Types
Type Conversion
data type
Base Types in C-Language Functions
data type
data type
Managing Databases
database
Monitoring Database Activity
database activity
Creating a Database Cluster
database cluster
Error Handling
date_part
EXTRACT, date_part
date_trunc
dblink
dblink
dblink_build_sql_delete
dblink_build_sql_insert
dblink_build_sql_update
dblink_cancel_query
dblink_close
dblink_connect
dblink_connect_u
dblink_disconnect
dblink_error_message
dblink_exec
dblink_fetch
dblink_get_connections
dblink_get_notify
dblink_get_pkey
dblink_get_result
dblink_is_busy
dblink_open
dblink_send_query
Deadlocks
Lock Management
dearmor
decimal (see
decode
decode
Raw Encryption Functions
decrypt
decrypt_iv
Default Values
defined
degrees
Delaying Execution
delay
Returning Data From Modified Rows
delete
dense_rank
diameter
dict_int
dict_xsyn
Soundex
difference
digest
Transaction Isolation
dirty read
disjunction
WAL Internals
disk drive
Recovering Disk Space
disk space
Determining Disk Usage
disk usage
div
Double Metaphone
dmetaphone
dmetaphone_alt
What Is a Document?
document
Destroying a Database
DROP_REPLICATION_SLOT
DTrace
Dynamic Tracing
DTrace
Other Defaults
dynamic loading
dynamic_library_path
Overview
Current Date/Time
Changing a Column's Default Value
each
Cube-based Earth Distances
earth
earthdistance
earth_box
earth_distance
ECPG
Reporting Errors Within the Server
elog
embedded SQL
enabled role
encode
encode
encrypt
Encryption Options
encryption
pgcrypto
encryption
encrypt_iv
Enum Support Functions
enum_first
enum_last
enum_range
Environment Variables
ereport
PostgreSQL Error Codes
error codes
Connection Status Functions
error message
Escaping Strings for Inclusion in SQL Commands
escaping strings
Registering Event Log on Windows
event log
Event Triggers
Writing Event Trigger Functions in C
event trigger
every
exist
exp
Using EXPLAIN
Extending SQL
Packaging Related Objects into an Extension
extension
extract
SPI_register_relation
SPI_register_trigger_data
SPI_unregister_relation
Main Functions
Extensions
failover
family
The Fast-Path Interface
fast path
Use of Secondary File Systems
file system mount points
file_fdw
first_value
flex
float4 (see
float8 (see
floor
Foreign Data
Writing A Foreign Data Wrapper
foreign data wrapper
foreign table
format
Data Type Formatting Functions
formatting
format_type
Free Space Map
Free Space Map
FSM (see
General Functions
fsm_page_contents
Full Text Search
Functions and Operators
function
Functions
User-defined Functions
function
Query Language (SQL) Functions
function
Internal Functions
function
C-Language Functions
function
fuzzystrmatch
Compiling and Linking Dynamically-loaded Functions
SQL Functions with Default Values for Arguments
Arguments for SQL Functions
SQL Functions with Output Parameters
SQL Functions Returning TABLE
SQL Functions with Variable Numbers of Arguments
SQL Functions Returning Sets
gc_to_sec
Set Returning Functions
generate_series
generate_subscripts
Genetic Query Optimizer
genetic query optimization
Random-Data Functions
gen_random_bytes
gen_random_uuid
gen_salt
genetic query optimization
GEQO (see
get_bit
get_byte
get_current_ts_config
get_raw_page
GIN (see
gin_clean_pending_list
GIN Functions
gin_leafpage_items
gin_metapage_info
gin_page_opaque_info
GiST (see
Privileges
GREATEST and LEAST
History of Units
Gregorian calendar
GSSAPI Authentication
GSSAPI
hash (see
Hash Functions
hash_bitmap_info
hash_metapage_info
hash_page_items
hash_page_stats
hash_page_type
has_any_column_privilege
has_column_privilege
has_database_privilege
has_foreign_data_wrapper_privilege
has_function_privilege
has_language_privilege
has_schema_privilege
has_sequence_privilege
has_server_privilege
has_tablespace_privilege
has_table_privilege
has_type_privilege
heap_page_items
heap_page_item_attrs
height
high availability
A Brief History of PostgreSQL
history
hmac
host
Parameter Key Words
host name
hostmask
Hot Standby
Standby Servers
HP-UX
hstore
hstore_to_array
hstore_to_json
hstore_to_jsonb
hstore_to_jsonb_loose
hstore_to_json_loose
hstore_to_matrix
intarray Functions and Operators
icount
ICU
Managing Collations
ICU
Ident Authentication
ident
IDENTIFY_SYSTEM
idx
IFNULL
Function Volatility Categories
Indexes
Multicolumn Indexes
index
Indexes and ORDER BY
index
index
Unique Indexes
index
Indexes on Expressions
index
Partial Indexes
index
index
Examining Index Usage
index
GIN and GiST Index Types
index
Locking and Indexes
index
Interfacing Extensions To Indexes
index
Operators and Functions
index
index scan
index-only scan
inet_client_addr
inet_client_port
inet_merge
inet_same_family
inet_server_addr
inet_server_port
The Information Schema
information schema
Inheritance
initcap
initdb
initdb
The Initialization Fork
Initialization Fork
input function
Installation from Source Code
installation
int2 (see
int4 (see
int8 (see
intagg
intarray
intset
int_array_aggregate
int_array_enum
inverse distribution
B-Tree Support Functions
in_range support functions
Platform and Client Compatibility
isclosed
Range Functions and Operators
isempty
isfinite
isn
Functions and Operators
isn_weak
isopen
is_valid
Managing Configuration File Contents
Index Types
B-Tree Indexes
BRIN Indexes
GIN Indexes
GiST Indexes
SP-GiST Indexes
Installation from Source Code on Windows
Client Interfaces
Just-in-Time Compilation (JIT)
JIT
Controlling the Planner with Explicit JOIN Clauses
join
jsonb_agg
jsonb_array_elements
jsonb_array_elements_text
jsonb_array_length
jsonb_build_array
jsonb_build_object
jsonb_each
jsonb_each_text
jsonb_extract_path
jsonb_extract_path_text
jsonb_insert
jsonb_object
jsonb_object_agg
jsonb_object_keys
jsonb_populate_record
jsonb_populate_recordset
jsonb_pretty
jsonb_set
jsonb_strip_nulls
jsonb_to_record
jsonb_to_recordset
jsonb_typeof
json_agg
json_array_elements
json_array_elements_text
json_array_length
json_build_array
json_build_object
json_each
json_each_text
json_extract_path
json_extract_path_text
json_object
json_object_agg
json_object_keys
json_populate_record
json_populate_recordset
json_strip_nulls
json_to_record
json_to_recordset
json_typeof
Julian date
JIT
Just-In-Time compilation (see
justify_days
justify_hours
justify_interval
SQL Key Words
key word
alias
label (see
lag
Large Objects
lastval
last_value
latitude
lca
LDAP
LDAP Authentication
LDAP
LDAP Lookup of Connection Parameters
LDAP connection parameter lookup
Shared Libraries
ldconfig
lead
left
length
length
length
length
Manipulating Documents
length(tsvector)
Levenshtein
levenshtein_less_equal
lex
libedit
libperl
libpq
Retrieving Query Results Row-By-Row
libpq
libpq-fe.h
libpq-fe.h
libpq-int.h
libpython
library finalization function
library initialization function
linear regression
llvm-config
ll_to_earth
ln
lo
load balancing
locale
Locale Support
locale
localtime
localtimestamp
Explicit Locking
lock
Viewing Locks
lock
Table-level Locks
log
log shipping
Logical Decoding
Logical Decoding
login privilege
Statistics Monitoring
When To Log
longitude
lower
lower
lower_inc
lower_inf
Closing a Large Object Descriptor
lo_close
Creating a Large Object
lo_creat
Server-side Functions
lo_creat
lo_create
Exporting a Large Object
lo_export
lo_export
lo_from_bytea
lo_get
Importing a Large Object
lo_import
lo_import
lo_import_with_oid
Seeking in a Large Object
lo_lseek
lo_lseek64
Opening an Existing Large Object
lo_open
lo_put
Reading Data from a Large Object
lo_read
Obtaining the Seek Position of a Large Object
lo_tell
lo_tell64
Truncating a Large Object
lo_truncate
lo_truncate64
Removing a Large Object
lo_unlink
lo_unlink
Writing Data to a Large Object
lo_write
lpad
LSN
ltree
ltree2text
ltrim
character string, length
Behavior
macaddr8_set7bit
macOS
magic block
Routine Database Maintenance Tasks
maintenance
make
make_date
make_interval
make_time
make_timestamp
make_timestamptz
make_valid
Environment Variables
MANPATH
masklen
Materialized Views
materialized views
max
Kernel Resource Usage
Subscribers
Sending Servers
md5
md5
Password Authentication
MD5
Linux Memory Overcommit
memory overcommit
Metaphone
min
MinGW/Native Windows
MinGW
mod
monitoring
Introduction
Multiversion Concurrency Control
Multixacts and Wraparound
MultiXactId
MVCC
percentile
Memory Management
not a number
NaN (see
negation
netmask
network
Network File Systems
Network Attached Storage (NAS) (see
Use of Network File Systems
Network File Systems
nextval
NFS (see
nlevel
Non-Durable Settings
non-durable
Database Connection Control Functions
nonblocking connection
Asynchronous Command Processing
nonblocking connection
nonrepeatable read
normal_rand
Notice Processing
notice processor
notice receiver
Asynchronous Notification
now
npoints
nth_value
ntile
numnode
Manipulating Queries
numnode
num_nonnulls
num_nulls
NVL
Creating a Schema
The Schema Search Path
Retrieving Query Result Information
obj_description
octet_length
octet_length
oid2name
OOM
OpenSSL
operator
operator
Operators
User-defined Operators
operator
Operator Classes and Operator Families
operator class
Index Methods and Operator Classes
operator class
operator family
Operator Classes and Operator Families
operator family
System Dependencies on Operator Classes
ordering operator
ordinality
output function
overcommit
overlay
overlay
Function Overloading
overloading
owner
Retrieving Other Result Information
SSL
pageinspect
page_checksum
page_header
Writing Code
palloc
PAM
PAM Authentication
PAM
Parallel Query
parse_ident
Partition Pruning
Table Partitioning
partitioned table
partitioning
password
password file
passwordcheck
Pattern Matching
pclose
Peer Authentication
peer
percent_rank
Performance Tips
performance
perl
PL/Perl - Perl Procedural Language
Perl
privilege
permission (see
pfree
PGcancel
PGconn
PGDATA
Event Callback Procedure
PGEventProc
pgp_armor_headers
pgp_key_id
pgp_pub_decrypt
pgp_pub_decrypt_bytea
pgp_pub_encrypt
pgp_pub_encrypt_bytea
pgp_sym_decrypt
pgp_sym_decrypt_bytea
pgp_sym_encrypt
pgp_sym_encrypt_bytea
PGresult
pgrowlocks
Overview
Functions
pgstatginindex
pgstathashindex
pgstatindex
pgstattuple
pgstattuple_approx
Extension Building Infrastructure
pgxs
Advisory Lock Functions
pg_advisory_lock
pg_advisory_lock_shared
pg_advisory_unlock
pg_advisory_unlock_all
pg_advisory_unlock_shared
pg_advisory_xact_lock
pg_advisory_xact_lock_shared
pg_archivecleanup
pg_backend_pid
pg_backup_start_time
pg_basebackup
pg_blocking_pids
pg_buffercache
pg_buffercache_pages
Server Signaling Functions
pg_cancel_backend
pg_client_encoding
Database Object Management Functions
pg_collation_actual_version
pg_collation_is_visible
pg_column_size
pg_conf_load_time
pg_controldata
pg_control_checkpoint
pg_control_init
pg_control_recovery
pg_control_system
pg_conversion_is_visible
Replication Functions
pg_create_logical_replication_slot
pg_create_physical_replication_slot
pg_create_restore_point
pg_ctl
pg_ctl
pg_ctl
pg_current_logfile
pg_current_wal_flush_lsn
pg_current_wal_insert_lsn
pg_current_wal_lsn
Template Databases
pg_database_size
pg_describe_object
pg_drop_replication_slot
Capturing Changes at Command End
pg_event_trigger_ddl_commands
Processing Objects Dropped by a DDL Command
pg_event_trigger_dropped_objects
Handling a Table Rewrite Event
pg_event_trigger_table_rewrite_oid
pg_event_trigger_table_rewrite_reason
Snapshot Synchronization Functions
pg_export_snapshot
Extension Configuration Tables
pg_extension_config_dump
pg_filenode_relation
pg_file_rename
pg_file_unlink
pg_file_write
Functions
pg_freespace
pg_freespacemap
pg_function_is_visible
pg_get_constraintdef
pg_get_expr
pg_get_functiondef
pg_get_function_arguments
pg_get_function_identity_arguments
pg_get_function_result
pg_get_indexdef
pg_get_keywords
pg_get_object_address
pg_get_ruledef
pg_get_serial_sequence
pg_get_statisticsobjdef
pg_get_triggerdef
pg_get_userbyid
pg_get_viewdef
pg_has_role
The pg_hba.conf File
pg_hba.conf
User Name Maps
pg_ident.conf
pg_identify_object
pg_identify_object_as_address
pg_import_system_collations
pg_indexam_has_property
pg_indexes_size
pg_index_column_has_property
pg_index_has_property
pg_is_in_backup
Recovery Control Functions
pg_is_in_recovery
pg_is_other_temp_schema
pg_is_wal_replay_paused
pg_last_committed_xact
pg_last_wal_receive_lsn
pg_last_wal_replay_lsn
pg_last_xact_replay_timestamp
pg_listening_channels
pg_logdir_ls
pg_logical_emit_message
pg_logical_slot_get_binary_changes
pg_logical_slot_get_changes
pg_logical_slot_peek_binary_changes
pg_logical_slot_peek_changes
Generic File Access Functions
pg_ls_dir
pg_ls_logdir
pg_ls_waldir
pg_my_temp_schema
pg_notification_queue_usage
pg_opclass_is_visible
pg_operator_is_visible
pg_opfamily_is_visible
pg_options_to_table
pg_postmaster_start_time
pg_prewarm
Configuration Parameters
pg_read_binary_file
pg_read_file
pg_receivewal
pg_relation_filenode
pg_relation_filepath
pg_relation_size
pg_reload_conf
pg_relpages
pg_replication_origin_advance
pg_replication_origin_create
pg_replication_origin_drop
pg_replication_origin_oid
pg_replication_origin_progress
pg_replication_origin_session_is_setup
pg_replication_origin_session_progress
pg_replication_origin_session_reset
pg_replication_origin_session_setup
pg_replication_origin_xact_reset
pg_replication_origin_xact_setup
pg_replication_slot_advance
pg_resetwal
pg_restore
pg_rewind
pg_rotate_logfile
pg_safe_snapshot_blocking_pids
pg_service.conf
pg_size_bytes
pg_size_pretty
pg_sleep
pg_sleep_for
pg_sleep_until
pg_standby
pg_start_backup
Viewing Statistics
pg_statio_all_indexes
pg_statio_all_sequences
pg_statio_all_tables
pg_statio_sys_indexes
pg_statio_sys_sequences
pg_statio_sys_tables
pg_statio_user_indexes
pg_statio_user_sequences
pg_statio_user_tables
Single-Column Statistics
pg_statistics_obj_is_visible
pg_stat_activity
pg_stat_all_indexes
pg_stat_all_tables
pg_stat_archiver
pg_stat_bgwriter
Statistics Functions
pg_stat_clear_snapshot
pg_stat_database
pg_stat_database_conflicts
pg_stat_file
pg_stat_get_activity
pg_stat_get_snapshot_timestamp
pg_stat_progress_vacuum
pg_stat_replication
pg_stat_reset
pg_stat_reset_shared
pg_stat_reset_single_function_counters
pg_stat_reset_single_table_counters
pg_stat_ssl
pg_stat_statements
Functions
pg_stat_statements_reset
pg_stat_subscription
pg_stat_sys_indexes
pg_stat_sys_tables
pg_stat_user_functions
pg_stat_user_indexes
pg_stat_user_tables
pg_stat_wal_receiver
pg_stat_xact_all_tables
pg_stat_xact_sys_tables
pg_stat_xact_user_functions
pg_stat_xact_user_tables
pg_stop_backup
pg_switch_wal
pg_tablespace_databases
pg_tablespace_location
pg_tablespace_size
pg_table_is_visible
pg_table_size
pg_temp
pg_terminate_backend
pg_test_fsync
pg_test_timing
pg_total_relation_size
pg_trgm
GUC Parameters
pg_try_advisory_lock
pg_try_advisory_lock_shared
pg_try_advisory_xact_lock
pg_try_advisory_xact_lock_shared
pg_ts_config_is_visible
pg_ts_dict_is_visible
pg_ts_parser_is_visible
pg_ts_template_is_visible
pg_typeof
pg_type_is_visible
pg_upgrade
pg_verify_checksums
pg_visibility
pg_waldump
pg_walfile_name
pg_walfile_name_offset
pg_wal_lsn_diff
pg_wal_replay_pause
pg_wal_replay_resume
pg_xact_commit_timestamp
phantom read
phraseto_tsquery
Parsing Queries
phraseto_tsquery
pi
PIC
PITR
PITR standby
pkg-config
PL/Perl
PL/pgSQL - SQL Procedural Language
PL/pgSQL
PL/Python - Python Procedural Language
PL/Python
PL/Tcl - Tcl Procedural Language
PL/Tcl
plainto_tsquery
plainto_tsquery
point-in-time recovery
Row Security Policies
policy
popen
populate_record
port
position
position
The Berkeley POSTGRES Project
POSTGRES
postgres
postgres
postgres
The PostgreSQL User Account
postgres user
Postgres95
Parameter Interaction via the Configuration File
postgresql.auto.conf
postgresql.conf
postgres_fdw
postmaster
power
PQbackendPID
PQbinaryTuples
PQcancel
PQclear
Control Functions
PQclientEncoding
PQcmdStatus
PQcmdTuples
PQconndefaults
PQconnectdb
PQconnectdbParams
PQconnectionNeedsPassword
PQconnectionUsedPassword
PQconnectPoll
PQconnectStart
PQconnectStartParams
PQconninfo
Miscellaneous Functions
PQconninfoFree
PQconninfoParse
PQconsumeInput
PQcopyResult
PQdb
PQdescribePortal
PQdescribePrepared
PQencryptPassword
PQencryptPasswordConn
Obsolete Functions for COPY
PQendcopy
PQerrorMessage
PQescapeBytea
PQescapeByteaConn
PQescapeIdentifier
PQescapeLiteral
PQescapeString
PQescapeStringConn
PQexec
PQexecParams
PQexecPrepared
PQfformat
PQfinish
PQfireResultCreateEvents
PQflush
PQfmod
PQfn
PQfname
PQfnumber
PQfreeCancel
PQfreemem
PQfsize
PQftable
PQftablecol
PQftype
PQgetCancel
Functions for Receiving COPY Data
PQgetCopyData
PQgetisnull
PQgetlength
PQgetline
PQgetlineAsync
PQgetResult
PQgetssl
PQgetvalue
PQhost
SSL Library Initialization
PQinitOpenSSL
PQinitSSL
Event Support Functions
PQinstanceData
PQisBusy
PQisnonblocking
Behavior in Threaded Programs
PQisthreadsafe
PQlibVersion
PQmakeEmptyPGresult
PQnfields
PQnotifies
PQnparams
PQntuples
PQoidStatus
PQoidValue
PQoptions
PQparameterStatus
PQparamtype
PQpass
PQping
PQpingParams
PQport
PQprepare
PQprint
PQprotocolVersion
Functions for Sending COPY Data
PQputCopyData
PQputCopyEnd
PQputline
PQputnbytes
PQregisterEventProc
PQrequestCancel
PQreset
PQresetPoll
PQresetStart
PQresStatus
PQresultAlloc
PQresultErrorField
PQresultErrorMessage
PQresultInstanceData
PQresultSetInstanceData
PQresultStatus
PQresultVerboseErrorMessage
PQsendDescribePortal
PQsendDescribePrepared
PQsendPrepare
PQsendQuery
PQsendQueryParams
PQsendQueryPrepared
PQserverVersion
PQsetClientEncoding
PQsetdb
PQsetdbLogin
PQsetErrorContextVisibility
PQsetErrorVerbosity
PQsetInstanceData
PQsetnonblocking
PQsetNoticeProcessor
PQsetNoticeReceiver
PQsetResultAttrs
PQsetSingleRowMode
PQsetvalue
PQsocket
PQsslAttribute
PQsslAttributeNames
PQsslInUse
PQsslStruct
PQstatus
PQtrace
PQtransactionStatus
PQtty
PQunescapeBytea
PQuntrace
PQuser
Serializable Isolation Level
predicate locking
Standby Server Settings
primary_conninfo recovery parameter
primary_slot_name recovery parameter
Schemas and Privileges
privilege
Rules and Privileges
privilege
Procedural Languages
Writing A Procedural Language Handler
procedural language
User-defined Procedures
procedure
Frontend/Backend Protocol
protocol
Standard Unix Tools
ps
Python
Patterns
Processing Embedded SQL Programs
Upgrading Data via pg_dumpall
PQserverVersion
Procedural Languages
qualified name
Queries
query plan
The Query Tree
query tree
querytree
querytree
quote_ident
quote_literal
quote_nullable
radians
radius
RADIUS Authentication
RADIUS
random
range table
rank
Read Committed Isolation Level
read committed
readline
Recovery Configuration
recovery.conf
recovery_end_command recovery parameter
recovery_min_apply_delay recovery parameter
Recovery Target Settings
recovery_target recovery parameter
recovery_target_action recovery parameter
recovery_target_inclusive recovery parameter
recovery_target_lsn recovery parameter
recovery_target_name recovery parameter
recovery_target_time recovery parameter
recovery_target_timeline recovery parameter
recovery_target_xid recovery parameter
referential integrity
regexp_match
POSIX Regular Expressions
regexp_match
regexp_matches
regexp_matches
regexp_replace
regexp_replace
regexp_split_to_array
regexp_split_to_array
regexp_split_to_table
regexp_split_to_table
regression intercept
regression slope
regression test
Regression Tests
regr_avgx
regr_avgy
regr_count
regr_intercept
regr_r2
regr_slope
regr_sxx
regr_sxy
regr_syy
SIMILAR TO Regular Expressions
regular expression
Routine Reindexing
reindex
repeat
Repeatable Read Isolation Level
repeatable read
replace
replication
Replication Progress Tracking
Replication Origins
restartpoint
restore_command recovery parameter
reverse
right
role
Role Membership
role
Default Roles
role
round
routine
routine maintenance
row
Row Estimation Examples
row estimation
row-level security
row-wise comparison
row_number
row_security_active
row_to_json
rpad
rtrim
The Rule System
rule
Views and the Rule System
rule
How SELECT Rules Work
rule
Rules on INSERT, UPDATE, and DELETE
rule
Rules Versus Triggers
rule
pattern matching
Replication Slots
Replication Slots
Multivariate Statistics Examples
expression
scalar (see
scale
Schemas
The Public Schema
Overview
schema
SCRAM
search path
sec_to_gc
seg
SELECT Output Columns
semaphores
sepgsql
GUC Parameters
sequence
sequential scan
serializable
Serializable Snapshot Isolation
serialization anomaly
Error Reporting and Logging
server log
Log File Maintenance
server log
Preventing Server Spoofing
server spoofing
session_user
setseed
setval
setweight
setweight
set_bit
set_byte
set_config
Functions and Operators
set_limit
set_masklen
sha224
sha256
sha384
sha512
shared library
shared memory
Shared Memory and LWLocks
shared_preload_libraries
shobj_description
show_limit
show_trgm
Shutting Down the Server
shutdown
SIGHUP
SIGHUP
SIGHUP
SIGINT
sign
significant digits
SIGQUIT
SIGTERM
similarity
sin
sind
Options for Single-User Mode
single-user mode
skeys
sleep
slice
TOAST
sliced bread (see
Solaris
sort
sort_asc
sort_desc
SP-GiST (see
Server Programming Interface
SPI
spi
SPI_commit
SPI_connect
SPI_connect_ext
SPI_copytuple
SPI_cursor_close
SPI_cursor_fetch
SPI_cursor_find
SPI_cursor_move
SPI_cursor_open
SPI_cursor_open_with_args
SPI_cursor_open_with_paramlist
SPI_exec
SPI_execp
SPI_execute
SPI_execute_plan
SPI_execute_plan_with_paramlist
SPI_execute_with_args
SPI_finish
SPI_fname
SPI_fnumber
SPI_freeplan
SPI_freetuple
SPI_freetuptable
SPI_getargcount
SPI_getargtypeid
SPI_getbinval
SPI_getnspname
SPI_getrelname
SPI_gettype
SPI_gettypeid
SPI_getvalue
SPI_is_cursor_plan
SPI_keepplan
SPI_modifytuple
SPI_palloc
SPI_pfree
SPI_prepare
SPI_prepare_cursor
SPI_prepare_params
SPI_repalloc
SPI_result_code_string
SPI_returntuple
SPI_rollback
SPI_saveplan
SPI_scroll_cursor_fetch
SPI_scroll_cursor_move
SPI_start_transaction
split_part
SQL Conformance
SQL/CLI
SQL/Foundation
SQL/Framework
SQL/JRT
SQL/MED
SQL/OLB
SQL/PSM
SQL/Schemata
SQL/XML
sqrt
Secure TCP/IP Connections with SSH Tunnels
ssh
SSI
Secure TCP/IP Connections with SSL
SSL
SSL Support
SSL
SSL
sslinfo
Functions Provided
ssl_cipher
ssl_client_cert_present
ssl_client_dn
ssl_client_dn_field
ssl_client_serial
ssl_extension_info
ssl_issuer_dn
ssl_issuer_field
ssl_is_used
ssl_version
SSPI Authentication
SSPI
standard deviation
standby server
standby_mode recovery parameter
starts_with
START_REPLICATION
statement_timestamp
statistics
Statistics Used by the Planner
statistics
statistics
The Statistics Collector
statistics
Query and Index Statistics Collector
stddev
stddev_pop
stddev_samp
STONITH
Streaming Replication
strict_word_similarity
character string
string (see
string_agg
string_to_array
strip
strip
strpos
subarray
subltree
subpath
subquery
substr
substring
substring
substring
sum
superuser
Trigger Functions
suppress_redundant_updates_trigger
svals
synchronous commit
Synchronous Replication
Master Server
SQL Syntax
syntax
The System Catalog Schema
system catalog
systemd
systemd
systemd RemoveIPC
table
Modifying Tables
table
xmltable
table function
Writing A Table Sampling Method
table sampling method
tablefunc
tableoid
TABLESAMPLE method
tablespace
tan
tand
target list
Tcl
tcn
template0
template1
template1
Disk
test
test_decoding
text search
text search
text2ltree
threads
time zone
time zone data
time zone names
timelines
TIMELINE_HISTORY
timeofday
TOAST
to_ascii
to_char
to_date
to_hex
to_json
to_jsonb
to_number
to_regclass
to_regnamespace
to_regoper
to_regoperator
to_regproc
to_regprocedure
to_regrole
to_regtype
to_timestamp
to_timestamp
to_tsquery
to_tsquery
to_tsvector
Parsing Documents
to_tsvector
Preventing Transaction ID Wraparound Failures
transaction ID
transaction isolation level
WAL
transaction log (see
transaction_timestamp
translate
Triggers
Writing Trigger Functions in C
triggered_change_notification
trigger_file recovery parameter
trim
trim
trunc
trunc
tsm_system_rows
tsm_system_time
tsquery_phrase
tsquery_phrase
tsvector concatenation
tsvector_to_array
tsvector_update_trigger
tsvector_update_trigger_column
ts_debug
Configuration Testing
ts_debug
ts_delete
ts_filter
ts_headline
Highlighting Results
ts_headline
ts_lexize
Dictionary Testing
ts_lexize
ts_parse
Parser Testing
ts_parse
ts_rank
Ranking Search Results
ts_rank
ts_rank_cd
ts_rank_cd
ts_rewrite
Query Rewriting
ts_rewrite
ts_stat
Gathering Document Statistics
ts_stat
ts_token_type
ts_token_type
tuple_data_split
txid_current
txid_current_if_assigned
txid_current_snapshot
txid_snapshot_xip
txid_snapshot_xmax
txid_snapshot_xmin
txid_status
txid_visible_in_snapshot
data type
type (see
Renaming a Table
Date/Time Configuration Files
TOAST Considerations
Introduction
ephemeral named relation
Overview of Trigger Behavior
Triggers for Automatic Updates
unaccent
Functions
uniq
Unix domain socket
unnest
unqualified name
Upgrading a PostgreSQL Cluster
upgrading
upper
upper
upper_inc
upper_inf
user
user
user mapping
uuid-ossp
uuid-ossp Functions
uuid_generate_v1
uuid_generate_v1mc
uuid_generate_v3
Routine Vacuuming
vacuum
vacuumlo
Cost-based Vacuum Delay
variadic function
variance
var_pop
var_samp
version
version
view
view
Cooperation with Views
view
Visibility Map
Visibility Map
VM (see
volatility
VPATH
VPATH
Reliability and the Write-Ahead Log
WAL
warm standby
websearch_to_tsquery
width
width_bucket
witness server
word_similarity
xmax
xmin
Mapping Tables to XML
XML export
XML option
xml2
xmlagg
xmlagg
xmlcomment
xmlconcat
xmlelement
xmlforest
xmlpi
xmlroot
xml_is_well_formed
xml_is_well_formed_content
xml_is_well_formed_document
xpath
xpath_exists
xpath_table
xslt_process
yacc
zlib
zlib
Guide
Aggregate Functions
Joins Between Tables
Concepts
column
Populating a Table With Rows
Creating a New Table
Creating a Database
database
database cluster
Deletions
Querying a Table
duplicate
Foreign Keys
hierarchical database
Inheritance
join
object-oriented database
Architectural Fundamentals
postgres
Accessing a Database
query
referential integrity
relation
relational database
row
subquery
superuser
table
Transactions
Updates
version
Views
Window Functions
Setting
allow_system_table_mods
application_name
archive_command
archive_mode
archive_timeout
array_nulls
authentication_timeout
auth_delay.milliseconds
autovacuum
autovacuum_analyze_scale_factor
autovacuum_analyze_threshold
autovacuum_freeze_max_age
autovacuum_max_workers
autovacuum_multixact_freeze_max_age
autovacuum_naptime
autovacuum_vacuum_cost_delay
autovacuum_vacuum_cost_limit
autovacuum_vacuum_scale_factor
autovacuum_vacuum_threshold
autovacuum_work_mem
auto_explain.log_analyze
auto_explain.log_buffers
auto_explain.log_format
auto_explain.log_min_duration
auto_explain.log_nested_statements
auto_explain.log_timing
auto_explain.log_triggers
auto_explain.log_verbose
auto_explain.sample_rate
backend_flush_after
backslash_quote
bgwriter_delay
bgwriter_flush_after
bgwriter_lru_maxpages
bgwriter_lru_multiplier
block_size
bonjour
bonjour_name
bytea_output
checkpoint_completion_target
checkpoint_flush_after
checkpoint_timeout
checkpoint_warning
check_function_bodies
client_encoding
client_min_messages
cluster_name
commit_delay
commit_siblings
config_file
constraint_exclusion
cpu_index_tuple_cost
cpu_operator_cost
cpu_tuple_cost
cursor_tuple_fraction
data_checksums
data_directory
data_directory_mode
data_sync_retry
DateStyle
db_user_namespace
deadlock_timeout
debug_assertions
debug_deadlocks
debug_pretty_print
debug_print_parse
debug_print_plan
debug_print_rewritten
default_statistics_target
default_tablespace
default_text_search_config
default_transaction_deferrable
default_transaction_isolation
default_transaction_read_only
default_with_oids
dynamic_library_path
dynamic_shared_memory_type
effective_cache_size
effective_io_concurrency
enable_bitmapscan
enable_gathermerge
enable_hashagg
enable_hashjoin
enable_indexonlyscan
enable_indexscan
enable_material
enable_mergejoin
enable_nestloop
enable_parallel_append
enable_parallel_hash
enable_partitionwise_aggregate
enable_partitionwise_join
enable_partition_pruning
enable_seqscan
enable_sort
enable_tidscan
escape_string_warning
event_source
exit_on_error
external_pid_file
extra_float_digits
force_parallel_mode
from_collapse_limit
fsync
full_page_writes
geqo
geqo_effort
geqo_generations
geqo_pool_size
geqo_seed
geqo_selection_bias
geqo_threshold
gin_fuzzy_search_limit
gin_pending_list_limit
hba_file
hot_standby
hot_standby_feedback
huge_pages
ident_file
idle_in_transaction_session_timeout
ignore_checksum_failure
ignore_system_indexes
integer_datetimes
IntervalStyle
jit
jit_above_cost
jit_debugging_support
jit_dump_bitcode
jit_expressions
jit_inline_above_cost
jit_optimize_above_cost
jit_profiling_support
jit_provider
jit_tuple_deforming
join_collapse_limit
krb_caseins_users
krb_server_keyfile
lc_collate
lc_ctype
lc_messages
lc_monetary
lc_numeric
lc_time
listen_addresses
local_preload_libraries
lock_timeout
logging_collector
log_autovacuum_min_duration
log_btree_build_stats
log_checkpoints
log_connections
log_destination
log_directory
log_disconnections
log_duration
log_error_verbosity
log_executor_stats
log_filename
log_file_mode
log_hostname
log_line_prefix
log_lock_waits
log_min_duration_statement
log_min_error_statement
log_min_messages
log_parser_stats
log_planner_stats
log_replication_commands
log_rotation_age
log_rotation_size
log_statement
log_statement_stats
log_temp_files
log_timezone
log_truncate_on_rotation
lo_compat_privileges
maintenance_work_mem
max_connections
max_files_per_process
max_function_args
max_identifier_length
max_index_keys
max_locks_per_transaction
max_logical_replication_workers
max_parallel_maintenance_workers
max_parallel_workers
max_parallel_workers_per_gather
max_pred_locks_per_page
max_pred_locks_per_relation
max_pred_locks_per_transaction
max_prepared_transactions
max_replication_slots
max_stack_depth
max_standby_archive_delay
max_standby_streaming_delay
max_sync_workers_per_subscription
max_wal_senders
max_wal_size
max_worker_processes
min_parallel_index_scan_size
min_parallel_table_scan_size
min_wal_size
old_snapshot_threshold
operator_precedence_warning
parallel_setup_cost
parallel_tuple_cost
password_encryption
pg_prewarm.autoprewarm
pg_prewarm.autoprewarm_interval
pg_trgm.similarity_threshold
pg_trgm.word_similarity_threshold
plperl.on_init
plperl.on_plperlu_init
plperl.on_plperl_init
plperl.use_strict
plpgsql.check_asserts
plpgsql.variable_conflict
pltcl.start_proc
pltclu.start_proc
port
post_auth_delay
pre_auth_delay
quote_all_identifiers
random_page_cost
restart_after_crash
row_security
search_path
search_path
segment_size
sepgsql.debug_audit
sepgsql.permissive
seq_page_cost
server_encoding
server_version
server_version_num
session_preload_libraries
session_replication_role
shared_buffers
shared_preload_libraries
ssl
ssl_ca_file
ssl_cert_file
ssl_ciphers
ssl_crl_file
ssl_dh_params_file
ssl_ecdh_curve
ssl_key_file
ssl_passphrase_command
ssl_passphrase_command_supports_reload
ssl_prefer_server_ciphers
standard_conforming_strings
statement_timeout
stats_temp_directory
superuser_reserved_connections
synchronize_seqscans
synchronous_commit
synchronous_standby_names
syslog_facility
syslog_ident
syslog_sequence_numbers
syslog_split_messages
tcp_keepalives_count
tcp_keepalives_idle
tcp_keepalives_interval
temp_buffers
temp_file_limit
temp_tablespaces
TimeZone
timezone_abbreviations
trace_locks
trace_lock_oidmin
trace_lock_table
trace_lwlocks
trace_notify
trace_recovery_messages
trace_sort
trace_userlocks
track_activities
track_activity_query_size
track_commit_timestamp
track_counts
track_functions
track_io_timing
transform_null_equals
unix_socket_directories
unix_socket_group
unix_socket_permissions
update_process_title
vacuum_cleanup_index_scale_factor
vacuum_cost_delay
vacuum_cost_limit
vacuum_cost_page_dirty
vacuum_cost_page_hit
vacuum_cost_page_miss
vacuum_defer_cleanup_age
vacuum_freeze_min_age
vacuum_freeze_table_age
vacuum_multixact_freeze_min_age
vacuum_multixact_freeze_table_age
wal_block_size
wal_buffers
wal_compression
wal_consistency_checking
wal_debug
wal_keep_segments
wal_level
wal_log_hints
wal_receiver_status_interval
wal_receiver_timeout
wal_retrieve_retry_interval
wal_segment_size
wal_sender_timeout
wal_sync_method
wal_writer_delay
wal_writer_flush_after
work_mem
xmlbinary
xmloption
zero_damaged_pages
Type
Pseudo-Types
any
anyarray
anyelement
anyenum
anynonarray
anyrange
Arbitrary Precision Numbers
Arrays
serial
serial4
Accessing Arrays
Array Value Input
Declaration of Array Types
Array Input and Output Syntax
Modifying Arrays
Searching in Arrays
The PostgreSQL Type System
base type
bigint
int8
Integer Types
bigint
int8
Serial Types
bigserial
serial8
Binary Data Types
binary data
Bit String Types
bit string
Boolean Type
Boolean
box
Boxes
box
bytea
Character Types
char
character
char
character string
character varying
varchar
Object Identifier Types
cid
cidr
Circles
circle
Composite Types
composite type
Using Composite Types in Queries
computed field
container type
cstring
Constructing Composite Values
Numeric Types
data type
Enumerated Types
data type
Domain Types
data type
data type
Polymorphic Types
Date/Time Types
date
numeric
decimal
domain
Floating-Point Types
double precision
float8
Creating XML Values
DTD
Special Values
Date/Time Output
event_trigger
false
fdw_handler
real
float4
double precision
float8
floating point
Text Search Types
full text search
function
UUID Type
GUID
index_am_handler
inet
smallint
int2
integer
int
int4
bigint
int8
integer
int
int4
integer
int
int4
internal
interval
Interval Input
Interval Output
JSON Types
JSON
JSON
JSONB
jsonb Containment and Existence
jsonb Indexing
language_handler
Lines
Line Segments
lseg
lseg
macaddr
macaddr8
Network Address Types
network
numeric
decimal
numeric
decimal
object identifier
oid
opaque
path
Paths
path
pg_ddl_command
pg_lsn Type
pg_lsn
Points
point
Polygons
polygon
polymorphic function
Range Types
real
float4
record
rectangle
regclass
regconfig
regdictionary
regoper
regoperator
regproc
regprocedure
regtype
row type
Constraints on Ranges
Indexing
serial
serial4
serial2
smallint
int2
smallserial
text
text
text search
tid
time
timetz
time span
time with time zone
time without time zone
Time Zones
timestamp
timestamptz
Time Stamps
timestamp with time zone
timestamp without time zone
trigger
trigger
trigger
trigger
trigger
true
tsm_handler
tsquery
tsvector
unknown
UUID
UUID
varchar
void
xid
XML Type
XML option
xmlparse
xmlserialize
View
applicable_roles
enabled_roles
pg_matviews
pg_aggregate
pg_am
pg_amop
pg_amproc
pg_attrdef
pg_attribute
pg_authid
pg_auth_members
pg_available_extensions
pg_available_extension_versions
pg_cast
pg_class
pg_collation
pg_config
pg_config
pg_constraint
pg_conversion
pg_cursors
pg_database
pg_database
pg_db_role_setting
pg_default_acl
pg_depend
pg_description
pg_enum
pg_event_trigger
pg_extension
pg_file_settings
pg_foreign_data_wrapper
pg_foreign_server
pg_foreign_table
pg_group
pg_hba_file_rules
pg_index
pg_indexes
pg_inherits
pg_init_privs
pg_language
pg_largeobject
pg_largeobject_metadata
pg_locks
pg_namespace
pg_opclass
pg_operator
pg_opfamily
pg_partitioned_table
pg_pltemplate
pg_policies
pg_policy
pg_prepared_statements
pg_prepared_xacts
pg_proc
pg_publication
pg_publication_rel
pg_publication_tables
pg_range
pg_replication_origin
pg_replication_origin_status
pg_replication_slots
pg_rewrite
pg_roles
pg_rules
pg_seclabel
pg_seclabels
pg_sequence
pg_sequences
pg_settings
pg_shadow
pg_shdepend
pg_shdescription
pg_shseclabel
pg_statistic
pg_statistic
pg_statistic_ext
pg_statistic_ext
pg_stats
pg_stats
pg_subscription
pg_subscription_rel
pg_tables
pg_tablespace
pg_timezone_abbrevs
pg_timezone_names
pg_transform
pg_trigger
pg_ts_config
pg_ts_config_map
pg_ts_dict
pg_ts_parser
pg_ts_template
pg_type
pg_user
pg_user_mapping
pg_user_mappings
pg_views
information_schema_catalog_name
administrable_role_authorizations
attributes
character_sets
check_constraint_routine_usage
check_constraints
collations
collation_character_set_applicability
column_domain_usage
column_options
column_privileges
column_udt_usage
columns
constraint_column_usage
constraint_table_usage
data_type_privileges
domain_constraints
domain_udt_usage
domains
element_types
foreign_data_wrapper_options
foreign_data_wrappers
foreign_server_options
foreign_servers
foreign_table_options
foreign_tables
key_column_usage
parameters
referential_constraints
role_column_grants
role_routine_grants
role_table_grants
role_udt_grants
role_usage_grants
routine_privileges
routines
schemata
sequences
sql_features
sql_implementation_info
sql_languages
sql_packages
sql_parts
sql_sizing
sql_sizing_profiles
table_constraints
table_privileges
tables
transforms
triggered_update_columns
triggers
udt_privileges
usage_privileges
user_defined_types
user_mapping_options
user_mappings
view_column_usage
view_routine_usage
view_table_usage
views
Procedure
Checking Assertions
ASSERT
assertions
Cursors
Collation of PL/pgSQL Variables
collation
Utility Functions in PL/Perl
Utility Functions
Database Access from PL/Tcl
Event Trigger Functions in PL/Tcl
Trapping Errors
exceptions
Error Handling in PL/Tcl
EXIT
Executing Dynamic Commands
format
Global Data in PL/Tcl
global data
Sharing Data
Appendix
instr function
Simple Loops
loop
PL/Perl Functions and Arguments
Null, None
Porting from Oracle PL/SQL
Oracle
Trusted and Untrusted PL/Perl
PL/PerlU
PL/SQL (Oracle)
Configuration
Variable Substitution
PL/Tcl Configuration
Plan Caching
preparing a query
Database Access Functions
quote_ident
quote_literal
quote_nullable
Executing a Query with a Single-row Result
Reporting Errors and Messages
RAISE
reporting errors
RETURN NEXT and RETURN QUERY
RETURN QUERY
Database Access from PL/Perl
Explicit Subtransactions in PL/Tcl
Trigger Functions
Trigger Functions
trusted
Trigger Functions in PL/Tcl
WHILE
Command
clusterdb
createdb
createdb
createdb
createuser
createuser
dropdb
dropdb
dropuser
dropuser
ecpg
pgbench
pg_dump
pg_dumpall
pg_isready
pg_recvlogical
psql
psql
reindexdb
vacuumdb
"parallel_leader_participation configuration
"transparent
Environment
PGAPPNAME
PGCLIENTENCODING
PGCONNECT_TIMEOUT
PGDATABASE
PGDATESTYLE
PGGEQO
PGGSSLIB
PGHOST
PGHOSTADDR
PGKRBSRVNAME
PGLOCALEDIR
PGOPTIONS
PGPASSFILE
PGPASSWORD
PGPORT
PGREQUIREPEER
PGREQUIRESSL
PGSERVICE
PGSERVICEFILE
PGSSLCERT
PGSSLCOMPRESSION
PGSSLCRL
PGSSLKEY
PGSSLMODE
PGSSLROOTCERT
PGSYSCONFDIR
PGTARGETSESSIONATTRS
PGTZ
PGUSER
Error
00000
01000
0100C
01008
01003
01007
01006
01004
01P01
02000
02001
03000
08000
08003
08006
08001
08004
08007
08P01
09000
0A000
0B000
0F000
0F001
0L000
0LP01
0P000
0Z000
0Z002
20000
21000
22000
2202E
22021
22008
22012
22005
2200B
22022
22015
2201E
22014
22016
2201F
2201G
22018
22007
22019
2200D
22025
22P06
22010
22023
22013
2201B
2201W
2201X
2202H
2202G
22009
2200C
2200G
22004
22002
22003
2200H
22026
22001
22011
22027
22024
2200F
22P01
22P02
22P03
22P04
22P05
2200L
2200M
2200N
2200S
2200T
23000
23001
23502
23503
23505
23514
23P01
24000
25000
25001
25002
25008
25003
25004
25005
25006
25007
25P01
25P02
25P03
26000
27000
28000
28P01
2B000
2BP01
2D000
2F000
2F005
2F002
2F003
2F004
34000
38000
38001
38002
38003
38004
39000
39001
39004
39P01
39P02
39P03
3B000
3B001
3D000
3F000
40000
40002
40001
40003
40P01
42000
42601
42501
42846
42803
42P20
42P19
42830
42602
42622
42939
42804
42P18
42P21
42P22
42809
428C9
42703
42883
42P01
42P02
42704
42701
42P03
42P04
42723
42P05
42P06
42P07
42712
42710
42702
42725
42P08
42P09
42P10
42611
42P11
42P12
42P13
42P14
42P15
42P16
42P17
44000
53000
53100
53200
53300
53400
54000
54001
54011
54023
55000
55006
55P02
55P03
57000
57014
57P01
57P02
57P03
57P04
58000
58030
58P01
58P02
72000
F0000
F0001
HV000
HV005
HV002
HV010
HV021
HV024
HV007
HV008
HV004
HV006
HV091
HV00B
HV00C
HV00D
HV090
HV00A
HV009
HV014
HV001
HV00P
HV00J
HV00K
HV00Q
HV00R
HV00L
HV00M
HV00N
P0000
P0001
P0002
P0003
P0004
XX000
XX001
XX002
Query
Function
Guide
Setting
Type
View
Procedure
Command
Environment
Error
Query(429)
Function(1893)
Guide(33)
Setting(319)
Type(197)
View(158)
Procedure(52)
Command(20)
(2)
Environment(29)
Error(241)