PostgreSQL Documentation
Errors
Functions
- A Brief History of PostgreSQL
- ANALYZE Progress Reporting
- AT TIME ZONE and AT LOCAL
- Access Privilege Inquiry Functions
- Adding a Column
- Adding a Constraint
- Administration Tools
- Administrator's Overview
- Advisory Lock Functions
- Advisory Locks
- Aggregate Functions
- Anti-Features
- Anti-Features
- Archive Modules
- Archive Recovery
- Archiving
- Arguments for SQL Functions
- Array Functions and Operators
- Asynchronous Behavior
- Asynchronous Command Processing
- Asynchronous Commit
- Asynchronous Notification
- Authentication
- Automatic Vacuuming
- B-Tree
- B-Tree Functions
- B-Tree Indexes
- B-Tree Support Functions
- BRIN
- BRIN Functions
- BRIN Indexes
- BSD Authentication
- Background Worker Processes
- Background Writer
- Backup Control Functions
- Backup Manifest Format
- Backup and Restore
- Base Backup Progress Reporting
- Base Types in C-Language Functions
- Behavior
- Behavior in Threaded Programs
- Binary String Functions and Operators
- Bit String Functions and Operators
- Build Process Details
- Build Process Details
- Building libpq Programs
- C-Language Functions
- CLUSTER Progress Reporting
- COPY Progress Reporting
- CREATE INDEX Progress Reporting
- Canceling Queries in Progress
- Capturing Changes at Command End
- Certificate Authentication
- Changing a Column's Data Type
- Changing a Column's Default Value
- Character Set Support
- Check Constraints
- Checkpoints
- Client Authentication
- Client Interfaces
- Closing a Large Object Descriptor
- Collation Support
- Color Support
- Combining Multiple Indexes
- Command-Line Editing
- Comment Information Functions
- Committed Transaction Information Functions
- Comparison Functions and Operators
- Compiling and Linking Dynamically-Loaded Functions
- Concurrency Control
- Conditional Expressions
- Configuration Parameters
- Configuration Parameters
- Configuration Parameters
- Configuration Parameters
- Configuration Parameters
- Configuration Parameters
- Configuration Parameters
- Configuration Settings Functions
- Configuration Testing
- Configuring the Colors
- Connection Settings
- Connection Status Functions
- Connection Strings
- Constraints
- Continuous Archiving in Standby
- Control Data Functions
- Control Functions
- Controlling the Planner with Explicit JOIN Clauses
- Cooperation with Views
- Cost-based Vacuum Delay
- Creating a Database
- Creating a Database Cluster
- Creating a Large Object
- Creating a Schema
- Cube-Based Earth Distances
- Cumulative Query and Index Statistics
- Current Date/Time
- Cygwin
- Daitch-Mokotoff Soundex
- Data Checksums
- Data Type Formatting Functions
- Data Types
- Data Validity Checking Functions
- Database Connection Control Functions
- Database Object Management Functions
- Database Roles
- Date/Time Configuration Files
- Date/Time Functions and Operators
- Deadlocks
- Default Roles Renamed to Predefined Roles
- Default Values
- Delaying Execution
- Dependency Tracking
- Destroying a Database
- Determining Disk Usage
- Developer Options
- Developer Options
- Developer Options
- Dictionary Testing
- Differences from SQL Standard and XQuery
- Disable Autocommit
- Disk
- Double Metaphone
- Dynamic Loading
- Dynamic Tracing
- ECPG — Embedded SQL in C
- EXPLAIN Basics
- EXTRACT, date_part
- Encryption Options
- Enum Support Functions
- Environment Variables
- Environment Variables
- Error Handling
- Error Reporting and Logging
- Escaping Strings for Inclusion in SQL Commands
- Event Callback Procedure
- Event Support Functions
- Event Triggers
- Examining Index Usage
- Exclusion Constraints
- Explicit Locking
- Exporting a Large Object
- Extended Statistics
- Extending SQL
- Extension Building Infrastructure
- Extension Configuration Tables
- Extension Files
- Extensions
- File Locations
- Foreign Data
- Foreign Keys
- Free Space Map
- Frontend/Backend Protocol
- Full Text Search
- Function Optimization Information
- Function Overloading
- Function Volatility Categories
- Functions
- Functions
- Functions
- Functions
- Functions
- Functions
- Functions
- Functions Associated with Pipeline Mode
- Functions Associated with the COPY Command
- Functions Provided
- Functions Provided
- Functions and Operators
- Functions and Operators
- Functions and Operators
- Functions for Receiving COPY Data
- Functions for Sending COPY Data
- Functions for Sending Cancel Requests
- GIN
- GIN Functions
- GIN Indexes
- GREATEST and LEAST
- GSSAPI Authentication
- GUC Parameters
- GUC Parameters
- Gathering Document Statistics
- General Functions
- Generated Columns
- Generic File Access Functions
- Genetic Query Optimizer
- Geometric Functions and Operators
- GiST
- GiST Functions
- GiST Indexes
- Handling a Table Rewrite Event
- Hash
- Hash Functions
- Hash Indexes
- Heap Functions
- High Availability, Load Balancing, and Replication
- Highlighting Results
- History of Units
- How SELECT Rules Work
- Ident Authentication
- Identity Columns
- Importing a Large Object
- Index Access Method Interface Definition
- Index Maintenance Functions
- Index Methods and Operator Classes
- Index-Only Scans and Covering Indexes
- Indexes
- Indexes and ORDER BY
- Indexes on Expressions
- Inheritance
- Initialization Function
- Initialization Functions
- Inspecting MCV Lists
- Installation Procedure
- Installation Procedure
- Installation from Binaries
- Installation from Source Code
- Interfacing Extensions to Indexes
- Internal Functions
- Introduction
- Introduction
- JSON Functions and Operators
- Julian Dates
- Just-in-Time Compilation (JIT)
- Kernel Resource Usage
- LDAP Authentication
- LDAP Lookup of Connection Parameters
- Large Objects
- Levenshtein
- Linux Memory Overcommit
- Locale Providers
- Locale Support
- Locale and Formatting
- Lock Management
- Locking and Indexes
- Log File Maintenance
- Logical Decoding
- Logical Decoding
- Logical Operators
- Main Functions
- Managing Collations
- Managing Configuration File Contents
- Managing Databases
- Manipulating Documents
- Manipulating Queries
- Mapping Tables to XML
- Materialized Views
- Mathematical Functions and Operators
- Memory
- Memory Management
- Merge Support Functions
- Meta-Commands
- Metaphone
- MinGW
- Miscellaneous Functions
- Modifying Tables
- Monitoring Database Activity
- Moving-Aggregate Mode
- Multicolumn Indexes
- Multivariate Statistics Examples
- Multixacts and Wraparound
- NFS
- Network Address Functions and Operators
- Non-Durable Settings
- Not-Null Constraints
- Notice Processing
- Object Information and Addressing Functions
- Obsolete Functions for COPY
- Obsolete Functions for Sending Cancel Requests
- Obtaining the Seek Position of a Large Object
- Opening an Existing Large Object
- Operator Classes and Operator Families
- Operator Classes and Operator Families
- Operator Optimization Information
- Operators
- Operators and Functions
- Options
- Options for Single-User Mode
- Ordered-Set Aggregates
- Other Defaults
- Other Planner Options
- Overview
- Overview
- Overview
- Overview of Trigger Behavior
- PAM Authentication
- PL/Perl — Perl Procedural Language
- PL/Python — Python Procedural Language
- PL/Tcl — Tcl Procedural Language
- PL/pgSQL — SQL Procedural Language
- POSIX Regular Expressions
- POSIX Time Zone Specifications
- Packaging Related Objects into an Extension
- Parallel Query
- Parameter Interaction via the Configuration File
- Parameter Key Words
- Parser Testing
- Parsing Documents
- Parsing Queries
- Partial Aggregation
- Partial Indexes
- Partition Pruning
- Partitioning and Constraint Exclusion
- Password Authentication
- Pattern Matching
- Patterns
- Peer Authentication
- Performance Tips
- Pipeline Mode
- Pipelining
- Planner Cost Constants
- Planner Method Configuration
- Platform and Client Compatibility
- Polymorphic and Variadic Aggregates
- PostgreSQL Error Codes
- PostgreSQL Features
- PostgreSQL Features
- Postgres95
- Predefined Roles
- Preferred Index Types for Text Search
- Preset Options
- Preventing Server Spoofing
- Preventing Transaction ID Wraparound Failures
- Previous PostgreSQL Versions
- Primary Keys
- Primary Server
- Privileges
- Procedural Languages
- Procedural Languages
- Process Title
- Processing Embedded SQL Programs
- Processing Objects Dropped by a DDL Command
- Processing and Creating JSON Data
- Queries
- Query Language (SQL) Functions
- Query Rewriting
- RADIUS Authentication
- Random-Data Functions
- Range/Multirange Functions and Operators
- Ranking Search Results
- Raw Encryption Functions
- Read Committed Isolation Level
- Reading Data from a Large Object
- Recovering Disk Space
- Recovery
- Recovery Control Functions
- Recovery Target
- Registering Event Log on Windows
- Regression Tests
- Reliability and the Write-Ahead Log
- Removing a Column
- Removing a Constraint
- Removing a Large Object
- Renaming a Column
- Renaming a Table
- Repeatable Read Isolation Level
- Replication Management Functions
- Replication Progress Tracking
- Replication Slots
- Replication Slots
- Reporting Errors Within the Server
- Requesting LWLocks at Startup
- Requesting Shared Memory at Startup
- Requirements
- Retrieving Other Result Information
- Retrieving Query Result Information
- Retrieving Query Results in Chunks
- Returning Data from Modified Rows
- Role Attributes
- Role Membership
- Routine Database Maintenance Tasks
- Routine Reindexing
- Routine Vacuuming
- Row Estimation Examples
- Row Security Policies
- Row and Array Comparisons
- Rules Versus Triggers
- Rules and Privileges
- Rules on INSERT, UPDATE, and DELETE
- SELECT Output Columns
- SIMILAR TO Regular Expressions
- SLRU
- SP-GiST
- SP-GiST Indexes
- SPI_commit
- SPI_connect
- 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_cursor_parse_open
- SPI_exec
- SPI_execp
- SPI_execute
- SPI_execute_extended
- SPI_execute_plan
- SPI_execute_plan_extended
- 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_extended
- SPI_prepare_params
- SPI_register_relation
- SPI_register_trigger_data
- SPI_repalloc
- SPI_result_code_string
- SPI_returntuple
- SPI_rollback
- SPI_saveplan
- SPI_scroll_cursor_fetch
- SPI_scroll_cursor_move
- SPI_start_transaction
- SPI_unregister_relation
- SQL Conformance
- SQL Functions Returning Sets
- SQL Functions Returning TABLE
- SQL Functions with Collations
- SQL Functions with Default Values for Arguments
- SQL Functions with Output Parameters
- SQL Functions with Variable Numbers of Arguments
- SQL Key Words
- SQL Procedures with Output Parameters
- SQL Syntax
- SQL/JSON Query Functions
- SQL/JSON Regular Expressions
- SSL
- SSL Library Initialization
- SSL Support
- SSPI Authentication
- Schema Visibility Inquiry Functions
- Schemas
- Schemas and Privileges
- Secure TCP/IP Connections with GSSAPI Encryption
- Secure TCP/IP Connections with SSH Tunnels
- Secure TCP/IP Connections with SSL
- Seeking in a Large Object
- Sending Servers
- Sequence Manipulation Functions
- Serializable Isolation Level
- Serialization Failure Handling
- Server Configuration
- Server Programming Interface
- Server Signaling Functions
- Server-Side Functions
- Session Information Functions
- Set Returning Functions
- Setting Up a Standby Server
- Settings
- Shared Libraries
- Shared Library Preloading
- Shared Memory and Semaphores
- Shutting Down the Server
- Single-Column Statistics
- Snapshot Synchronization Functions
- Solaris
- Soundex
- Standard Unix Tools
- Standby Server Operation
- Standby Servers
- Starting the Database Server
- Statement Behavior
- Statistics Functions
- Statistics Information Functions
- Statistics Monitoring
- Statistics Used by the Planner
- Streaming Replication Protocol
- String Functions and Operators
- Subquery Expressions
- Subscribers
- Support Functions for Aggregates
- System Catalog Information Functions
- System Columns
- System Dependencies on Operator Classes
- TCP Settings
- TOAST
- TOAST Considerations
- Table Access Method Interface Definition
- Table Basics
- Table Partitioning
- Table-Level Locks
- Tablespaces
- Template Databases
- Text Search Functions and Operators
- The Autovacuum Daemon
- The Berkeley POSTGRES Project
- The Connection Service File
- The Cumulative Statistics System
- The Fast-Path Interface
- The Information Schema
- The Initialization Fork
- The Password File
- The PostgreSQL User Account
- The Public Schema
- The Query Tree
- The Rule System
- The SQL/JSON Path Language
- The Schema Search Path
- The System Catalog Schema
- The pg_hba.conf File
- The pg_stat_statements_info View
- Transaction ID and Snapshot Information Functions
- Transaction Isolation
- Trigger Functions
- Triggers
- Triggers for Automatic Updates
- Truncating a Large Object
- Type Conversion
- Typedefs
- UNION, CASE, and Related Constructs
- UUID Functions
- Unique Constraints
- Unique Indexes
- Updating Planner Statistics
- Upgrading Data via pg_dumpall
- Upgrading a PostgreSQL Cluster
- Use of Secondary File Systems
- User Name Maps
- User-Defined Aggregates
- User-Defined Functions
- User-Defined Operators
- User-Defined Procedures
- User-Defined Types
- Using C++ for Extensibility
- Using EXPLAIN
- VACUUM Progress Reporting
- Variables
- Version Information Functions
- View Rules in Non-SELECT Statements
- Viewing Locks
- Viewing Statistics
- Views and the Rule System
- Visibility Map
- Visual Studio
- WAL Configuration
- WAL Internals
- WAL Summarization
- WAL Summarization Information Functions
- What Is a Document?
- What to Log
- When Color is Used
- When to Log
- Where to Log
- Window Functions
- Writing Code
- Writing Data to a Large Object
- Writing Event Trigger Functions in C
- Writing Trigger Functions in C
- Writing a Custom Scan Provider
- Writing a Foreign Data Wrapper
- Writing a Procedural Language Handler
- Writing a Table Sampling Method
- XML Functions
- XML Limits and Conformance to SQL/XML
- abbrev
- abs
- acldefault
- aclexplode
- acos
- acosd
- acosh
- age
- age
- akeys
- amcheck — tools to verify table and index consistency
- any_value
- applicable_roles
- area
- armor
- array_agg
- array_append
- array_cat
- array_dims
- array_fill
- array_length
- array_lower
- array_ndims
- array_position
- array_positions
- array_prepend
- array_remove
- array_replace
- array_sample
- array_shuffle
- array_to_json
- array_to_string
- array_to_tsvector
- array_upper
- ascii
- asin
- asind
- asinh
- atan
- atan2
- atan2d
- atand
- atanh
- auth_delay — pause on authentication failure
- auto_explain — log execution plans of slow queries
- avals
- avg
- basebackup_to_shell — example "shell" pg_basebackup module
- basic_archive — an example WAL archive module
- bit_and
- bit_count
- bit_count
- bit_length
- bit_length
- bit_length
- bit_or
- bit_xor
- bloom — bloom filter index access method
- bool_and
- bool_or
- bound_box
- brin_desummarize_range
- brin_summarize_new_values
- brin_summarize_range
- broadcast
- btree_gin — GIN operator classes with B-tree behavior
- btree_gist — GiST operator classes with B-tree behavior
- btrim
- btrim
- cardinality
- cbrt
- ceil
- ceiling
- center
- char_length
- character_length
- chr
- citext — a case-insensitive character string type
- clock_timestamp
- clusterdb
- col_description
- concat
- concat_ws
- configure Environment Variables
- configure Options
- connectby
- convert
- convert_from
- convert_to
- corr
- cos
- cosd
- cosh
- cot
- cotd
- count
- covar_pop
- covar_samp
- createdb
- createuser
- crosstab
- crosstab(text)
- crosstab(text, text)
- crosstabN(text)
- crypt
- cube
- cube — a multi-dimensional cube data type
- cume_dist
- current_catalog
- current_database
- current_date
- current_query
- current_role
- current_schema
- current_schemas
- current_setting
- current_time
- current_timestamp
- current_user
- currval
- date_add
- date_bin
- date_part
- date_subtract
- date_trunc
- dblink
- dblink — connect to other PostgreSQL databases
- 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
- decode
- defined
- degrees
- delete
- dense_rank
- diagonal
- diameter
- dict_int —
- dict_xsyn — example synonym full-text search dictionary
- digest
- div
- dropdb
- dropuser
- each
- earth
- earth_box
- earth_distance
- earthdistance — calculate great-circle distances
- ecpg
- enabled_roles
- encode
- enum_first
- enum_last
- enum_range
- erf
- erfc
- every
- exist
- exp
- extract
- factorial
- family
- file_fdw — access data files in the server's file system
- first_value
- floor
- format
- format_type
- fuzzystrmatch — determine string similarities and distance
- gc_to_sec
- gcd
- gen_salt
- generate_series
- generate_subscripts
- get_bit
- get_bit
- get_byte
- get_current_ts_config
- gin_clean_pending_list
- has_any_column_privilege
- has_column_privilege
- has_database_privilege
- has_foreign_data_wrapper_privilege
- has_function_privilege
- has_language_privilege
- has_parameter_privilege
- has_schema_privilege
- has_sequence_privilege
- has_server_privilege
- has_table_privilege
- has_tablespace_privilege
- has_type_privilege
- height
- hmac
- host
- hostmask
- hstore
- hstore Operators and Functions
- hstore — hstore key/value datatype
- hstore_to_array
- hstore_to_json
- hstore_to_json_loose
- hstore_to_jsonb
- hstore_to_jsonb_loose
- hstore_to_matrix
- icount
- icu_unicode_version
- idx
- index
- inet_client_addr
- inet_client_port
- inet_merge
- inet_same_family
- inet_server_addr
- inet_server_port
- initcap
- initdb
- intagg — integer aggregator and enumerator
- intarray Functions and Operators
- intarray — manipulate arrays of integers
- intset
- is_valid
- isclosed
- isempty
- isfinite
- isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)
- isn_weak
- isopen
- json_agg
- json_agg_strict
- json_array
- json_array_elements
- json_array_elements_text
- json_array_length
- json_arrayagg
- 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_agg_strict
- json_object_agg_unique
- json_object_agg_unique_strict
- json_object_keys
- json_objectagg
- json_populate_record
- json_populate_recordset
- json_scalar
- json_strip_nulls
- json_to_record
- json_to_recordset
- json_to_tsvector
- json_typeof
- jsonb_agg
- jsonb_agg_strict
- 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_agg_strict
- jsonb_object_agg_unique
- jsonb_object_agg_unique_strict
- jsonb_object_keys
- jsonb_path_exists
- jsonb_path_exists_tz
- jsonb_path_match
- jsonb_path_match_tz
- jsonb_path_query
- jsonb_path_query_array
- jsonb_path_query_array_tz
- jsonb_path_query_first
- jsonb_path_query_first_tz
- jsonb_path_query_tz
- jsonb_populate_record
- jsonb_populate_record_valid
- jsonb_populate_recordset
- jsonb_pretty
- jsonb_set
- jsonb_set_lax
- jsonb_strip_nulls
- jsonb_to_record
- jsonb_to_recordset
- jsonb_to_tsvector
- jsonb_typeof
- justify_days
- justify_hours
- justify_interval
- lag
- last_value
- lastval
- latitude
- lca
- lcm
- lead
- left
- length
- length
- length
- length
- length
- libpq — C Library
- ll_to_earth
- ln
- lo — manage large objects
- lo_from_bytea
- lo_get
- lo_put
- localtime
- localtimestamp
- log
- log10
- longitude
- lower
- lower
- lower_inc
- lower_inf
- lpad
- ltree — hierarchical tree-like data type
- ltree2text
- ltrim
- ltrim
- macOS
- macaddr8_set7bit
- make_date
- make_interval
- make_time
- make_timestamp
- make_timestamptz
- make_valid
- makeaclitem
- masklen
- max
- md5
- md5
- merge_action
- min
- min_scale
- mod
- mxid_age
- netmask
- network
- nextval
- nlevel
- normal_rand
- normalize
- now
- npoints
- nth_value
- ntile
- num_nonnulls
- num_nulls
- numnode
- obj_description
- octet_length
- octet_length
- octet_length
- oid2name
- overlay
- overlay
- overlay
- pageinspect — low-level inspection of database pages
- parse_ident
- passwordcheck — verify password strength
- pclose
- percent_rank
- 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_aggregate
- pg_am
- pg_amcheck
- pg_amop
- pg_amproc
- pg_archivecleanup
- pg_attrdef
- pg_attribute
- pg_auth_members
- pg_authid
- pg_available_extension_versions
- pg_available_extensions
- pg_available_wal_summaries
- pg_backend_memory_contexts
- pg_backend_pid
- pg_backup_start
- pg_backup_stop
- pg_basebackup
- pg_basetype
- pg_blocking_pids
- pg_buffercache — inspect PostgreSQL
- pg_cancel_backend
- pg_cast
- pg_char_to_encoding
- pg_checksums
- pg_class
- pg_client_encoding
- pg_collation
- pg_collation_actual_version
- pg_collation_is_visible
- pg_column_compression
- pg_column_size
- pg_column_toast_chunk_id
- pg_combinebackup
- pg_conf_load_time
- pg_config
- pg_config
- pg_constraint
- pg_control_checkpoint
- pg_control_init
- pg_control_recovery
- pg_control_system
- pg_controldata
- pg_conversion
- pg_conversion_is_visible
- pg_copy_logical_replication_slot
- pg_copy_physical_replication_slot
- pg_create_logical_replication_slot
- pg_create_physical_replication_slot
- pg_create_restore_point
- pg_createsubscriber
- pg_ctl
- pg_current_logfile
- pg_current_snapshot
- pg_current_wal_flush_lsn
- pg_current_wal_insert_lsn
- pg_current_wal_lsn
- pg_current_xact_id
- pg_current_xact_id_if_assigned
- pg_cursors
- pg_database
- pg_database_collation_actual_version
- pg_database_size
- pg_db_role_setting
- pg_default_acl
- pg_depend
- pg_describe_object
- pg_description
- pg_drop_replication_slot
- pg_dump
- pg_dumpall
- pg_encoding_to_char
- pg_enum
- pg_event_trigger
- pg_event_trigger_table_rewrite_oid
- pg_event_trigger_table_rewrite_reason
- pg_export_snapshot
- pg_extension
- pg_file_settings
- pg_filenode_relation
- pg_foreign_data_wrapper
- pg_foreign_server
- pg_foreign_table
- pg_freespacemap — examine the free space map
- pg_function_is_visible
- pg_get_catalog_foreign_keys
- pg_get_constraintdef
- pg_get_expr
- pg_get_function_arguments
- pg_get_function_identity_arguments
- pg_get_function_result
- pg_get_functiondef
- pg_get_indexdef
- pg_get_keywords
- pg_get_object_address
- pg_get_partkeydef
- pg_get_ruledef
- pg_get_serial_sequence
- pg_get_statisticsobjdef
- pg_get_triggerdef
- pg_get_userbyid
- pg_get_viewdef
- pg_get_wal_replay_pause_state
- pg_get_wal_resource_managers
- pg_get_wal_summarizer_state
- pg_group
- pg_has_role
- pg_hba_file_rules
- pg_ident_file_mappings
- pg_identify_object
- pg_identify_object_as_address
- pg_import_system_collations
- pg_index
- pg_index_column_has_property
- pg_index_has_property
- pg_indexam_has_property
- pg_indexes
- pg_indexes_size
- pg_inherits
- pg_init_privs
- pg_input_error_info
- pg_input_is_valid
- pg_is_in_recovery
- pg_is_other_temp_schema
- pg_is_wal_replay_paused
- pg_isready
- pg_jit_available
- pg_language
- pg_largeobject
- pg_largeobject_metadata
- pg_last_committed_xact
- pg_last_wal_receive_lsn
- pg_last_wal_replay_lsn
- pg_last_xact_replay_timestamp
- pg_listening_channels
- pg_locks
- pg_log_backend_memory_contexts
- pg_log_standby_snapshot
- 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
- pg_ls_archive_statusdir
- pg_ls_dir
- pg_ls_logdir
- pg_ls_logicalmapdir
- pg_ls_logicalsnapdir
- pg_ls_replslotdir
- pg_ls_tmpdir
- pg_ls_waldir
- pg_matviews
- pg_my_temp_schema
- pg_namespace
- pg_notification_queue_usage
- pg_opclass
- pg_opclass_is_visible
- pg_operator
- pg_operator_is_visible
- pg_opfamily
- pg_opfamily_is_visible
- pg_options_to_table
- pg_parameter_acl
- pg_partition_ancestors
- pg_partition_root
- pg_partition_tree
- pg_partitioned_table
- pg_policies
- pg_policy
- pg_postmaster_start_time
- pg_prepared_statements
- pg_prepared_xacts
- pg_prewarm — preload relation data into buffer caches
- pg_proc
- pg_promote
- pg_publication
- pg_publication_namespace
- pg_publication_rel
- pg_publication_tables
- pg_range
- pg_read_binary_file
- pg_read_file
- pg_receivewal
- pg_receivexlog renamed to pg_receivewal
- pg_recvlogical
- pg_relation_filenode
- pg_relation_filepath
- pg_relation_size
- pg_reload_conf
- pg_replication_origin
- 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_status
- pg_replication_origin_xact_reset
- pg_replication_origin_xact_setup
- pg_replication_slot_advance
- pg_replication_slots
- pg_resetwal
- pg_resetxlog renamed to pg_resetwal
- pg_restore
- pg_rewind
- pg_rewrite
- pg_roles
- pg_rotate_logfile
- pg_rules
- pg_safe_snapshot_blocking_pids
- pg_seclabel
- pg_seclabels
- pg_sequence
- pg_sequences
- pg_settings
- pg_settings_get_flags
- pg_shadow
- pg_shdepend
- pg_shdescription
- pg_shmem_allocations
- pg_shseclabel
- pg_size_bytes
- pg_size_pretty
- pg_snapshot_xip
- pg_snapshot_xmax
- pg_snapshot_xmin
- pg_split_walfile_name
- pg_stat_clear_snapshot
- pg_stat_file
- pg_stat_get_activity
- pg_stat_get_backend_activity
- pg_stat_get_backend_activity_start
- pg_stat_get_backend_client_addr
- pg_stat_get_backend_client_port
- pg_stat_get_backend_dbid
- pg_stat_get_backend_idset
- pg_stat_get_backend_pid
- pg_stat_get_backend_start
- pg_stat_get_backend_subxact
- pg_stat_get_backend_userid
- pg_stat_get_backend_wait_event
- pg_stat_get_backend_wait_event_type
- pg_stat_get_backend_xact_start
- pg_stat_get_snapshot_timestamp
- pg_stat_get_xact_blocks_fetched
- pg_stat_get_xact_blocks_hit
- pg_stat_reset
- pg_stat_reset_replication_slot
- pg_stat_reset_shared
- pg_stat_reset_single_function_counters
- pg_stat_reset_single_table_counters
- pg_stat_reset_slru
- pg_stat_reset_subscription_stats
- pg_stat_statements — track statistics of SQL planning and execution
- pg_stat_statements_reset
- pg_statistic
- pg_statistic_ext
- pg_statistics_obj_is_visible
- pg_stats
- pg_stats_ext
- pg_stats_ext_exprs
- pg_subscription
- pg_subscription_rel
- pg_surgery — perform low-level surgery on relation data
- pg_switch_wal
- pg_sync_replication_slots
- pg_table_is_visible
- pg_table_size
- pg_tables
- pg_tablespace
- pg_tablespace_databases
- pg_tablespace_location
- pg_tablespace_size
- pg_terminate_backend
- pg_test_fsync
- pg_test_timing
- pg_timezone_abbrevs
- pg_timezone_names
- pg_total_relation_size
- pg_transform
- pg_trgm —
- pg_trigger
- pg_trigger_depth
- pg_try_advisory_lock
- pg_try_advisory_lock_shared
- pg_try_advisory_xact_lock
- pg_try_advisory_xact_lock_shared
- pg_ts_config
- pg_ts_config_is_visible
- pg_ts_config_map
- pg_ts_dict
- pg_ts_dict_is_visible
- pg_ts_parser
- pg_ts_parser_is_visible
- pg_ts_template
- pg_ts_template_is_visible
- pg_type
- pg_type_is_visible
- pg_typeof
- pg_upgrade
- pg_user
- pg_user_mapping
- pg_user_mappings
- pg_verifybackup
- pg_views
- pg_visibility — visibility map information and utilities
- pg_visible_in_snapshot
- pg_wait_events
- pg_wal_lsn_diff
- pg_wal_replay_pause
- pg_wal_replay_resume
- pg_wal_summary_contents
- pg_waldump
- pg_walfile_name
- pg_walfile_name_offset
- pg_walinspect — low-level WAL inspection
- pg_walsummary
- pg_xact_commit_timestamp
- pg_xact_commit_timestamp_origin
- pg_xact_status
- pg_xlogdump renamed to pg_waldump
- pgbench
- pgcrypto — cryptographic functions
- pgp_armor_headers
- pgp_key_id
- pgp_pub_decrypt
- pgp_pub_encrypt
- pgp_sym_decrypt
- pgp_sym_encrypt
- pgrowlocks — show a table's row locking information
- pgstattuple — obtain tuple-level statistics
- phraseto_tsquery
- pi
- plainto_tsquery
- popen
- populate_record
- position
- position
- position
- postgres
- postgres_fdw —
- power
- psql
- querytree
- quote_ident
- quote_literal
- quote_nullable
- radians
- radius
- random
- random_normal
- range_agg
- range_intersect_agg
- range_merge
- rank
- recovery.conf file merged into postgresql.conf
- regexp_count
- regexp_instr
- regexp_like
- regexp_match
- regexp_matches
- regexp_replace
- regexp_split_to_array
- regexp_split_to_table
- regexp_substr
- regr_avgx
- regr_avgy
- regr_count
- regr_intercept
- regr_r2
- regr_slope
- regr_sxx
- regr_sxy
- regr_syy
- regression test
- reindexdb
- repeat
- replace
- reverse
- right
- round
- row_number
- row_security_active
- row_to_json
- rpad
- rtrim
- rtrim
- scale
- sec_to_gc
- seg — a datatype for line segments or floating point intervals
- sepgsql —
- session_user
- set_bit
- set_bit
- set_byte
- set_config
- set_limit
- set_masklen
- setseed
- setval
- setweight
- sha224
- sha256
- sha384
- sha512
- shobj_description
- show_limit
- show_trgm
- sign
- similarity
- sin
- sind
- sinh
- skeys
- slice
- slope
- sort
- sort_asc
- sort_desc
- spi — Server Programming Interface features/examples
- split_part
- sqrt
- sslinfo — obtain client SSL information
- starts_with
- statement_timestamp
- stddev
- stddev_pop
- stddev_samp
- strict_word_similarity
- string_agg
- string_to_array
- string_to_table
- strip
- strpos
- subarray
- subltree
- subpath
- substr
- substr
- substring
- substring
- substring
- sum
- suppress_redundant_updates_trigger
- svals
- system_user
- systemd RemoveIPC
- tablefunc — functions that return tables (crosstab and others)
- tan
- tand
- tanh
- tcn — a trigger function to notify listeners of changes to table content
- test_decoding — SQL-based test/example module for WAL logical decoding
- text2ltree
- timeofday
- to_ascii
- to_bin
- to_char
- to_date
- to_hex
- to_json
- to_jsonb
- to_number
- to_oct
- to_regclass
- to_regcollation
- to_regnamespace
- to_regoper
- to_regoperator
- to_regproc
- to_regprocedure
- to_regrole
- to_regtype
- to_regtypemod
- to_timestamp
- to_timestamp
- to_tsquery
- to_tsvector
- transaction_timestamp
- translate
- trim
- trim
- trim_array
- trim_scale
- trunc
- trunc
- ts_debug
- ts_delete
- ts_filter
- ts_headline
- ts_lexize
- ts_parse
- ts_rank
- ts_rank_cd
- ts_rewrite
- ts_stat
- ts_token_type
- tsm_system_rows —
- tsm_system_time —
- tsquery_phrase
- tsvector_to_array
- tsvector_update_trigger
- tsvector_update_trigger_column
- txid_current
- txid_current_if_assigned
- txid_current_snapshot
- txid_snapshot_xip
- txid_snapshot_xmax
- txid_snapshot_xmin
- txid_status
- txid_visible_in_snapshot
- unaccent — a text search dictionary which removes diacritics
- unicode_assigned
- unicode_version
- uniq
- unistr
- unnest
- upper
- upper
- upper_inc
- upper_inf
- user
- uuid-ossp Functions
- uuid-ossp — a UUID generator
- uuid_generate_v1
- uuid_generate_v1mc
- uuid_generate_v3
- vacuumdb
- vacuumlo
- var_pop
- var_samp
- variance
- version
- websearch_to_tsquery
- width
- width_bucket
- word_similarity
- xml2 — XPath querying and XSLT functionality
- xml_is_well_formed
- xmlagg
- xmlagg
- xmlcomment
- xmlconcat
- xmlelement
- xmlforest
- xmlpi
- xmlroot
- xmltable
- xmltext
- xpath
- xpath_exists
- xpath_table
- xslt_process
Guides
Procedures
Querys
Settings
Types
Views