Search PostgreSQL documentation

pg_checksums --checkCommand-line ToolsPG18-c--check Checks checksums. This is the default mode if nothing else is specified.pg_checksums › Options pg_checksums --disableCommand-line ToolsPG18-d--disable Disables checksums.pg_checksums › Options pg_checksums --enableCommand-line ToolsPG18-e--enable Enables checksums.pg_checksums › Options pg_checksums --filenode=filenodeCommand-line ToolsPG18-f filenode--filenode=filenode Only validate checksums in the relation with filenode filenode.pg_checksums › Options pg_checksums --helpCommand-line ToolsPG18-?--help Show help about pg_checksums command line arguments, and exit.pg_checksums › Options pg_checksums --no-syncCommand-line ToolsPG18-N--no-sync By default, pg_checksums will wait for all files to be written safely to disk. This option causes pg_checksums to return without waiting, which is faster, but means that a subseq…pg_checksums › Options pg_checksums --pgdata=directoryCommand-line ToolsPG18-D directory--pgdata=directory Specifies the directory where the database cluster is stored.pg_checksums › Options pg_checksums --progressCommand-line ToolsPG18-P--progress Enable progress reporting. Turning this on will deliver a progress report while checking or enabling checksums.pg_checksums › Options pg_checksums --sync-method=methodCommand-line ToolsPG18--sync-method=method When set to fsync, which is the default, pg_checksums will recursively open and synchronize all files in the data directory. The search for files will follow symbolic li…pg_checksums › Options pg_checksums --verboseCommand-line ToolsPG18-v--verbose Enable verbose output. Lists all checked files.pg_checksums › Options pg_checksums --versionCommand-line ToolsPG18-V--version Print the pg_checksums version and exit.pg_checksums › Options pg_circuitExtensionsExtensionsRuntime observation, warnings and blocking for dangerous SQL statements guard ddl dml pg_circuit AdministrationAdministration · Extensions pg_cjk_parserExtensionsExtensionsCJK bigram parser derived from PostgreSQL full-text search pg_cjk_parser Full-text searchFull-text search · Extensions pg_classManual ChaptersPG1852.11. pg_class The catalog pg_class describes tables and other objects that have columns or are otherwise similar to a table. This includes indexes (but see also pg_index), sequences (but s…pg_class pg_classCatalogs & ViewsReferencepg_class System catalogs 10 The catalog pg_class catalogs tables and most everything else that has columns or is otherwise similar to a table. This includes indexes (but see also pg_index), …System Catalogs · System catalogs pg_cld2ExtensionsExtensionsDetects likely human language and script in PostgreSQL using CLD2. cld2 language language-detection pg_cld2 Full-text searchFull-text search · Extensions pg_clear_attribute_statsFunctionsReferencepg_clear_attribute_stats System Administration Functions 18 Clears column-level statistics for the given relation and attribute, as though the table was newly created. pg_clear_attribute_sta…Functions · System Administration Functions pg_clear_extended_statsFunctionsReferencepg_clear_extended_stats System Administration Functions 19 Clears data of an extended statistics object, as though the object was newly-created. The required arguments are schemaname and rel…Functions · System Administration Functions pg_clear_relation_statsFunctionsReferencepg_clear_relation_stats System Administration Functions 18 Clears table-level statistics for the given relation, as though the table was newly created. pg_clear_relation_stats ( schemaname t…Functions · System Administration Functions pg_clickhouseExtensionsExtensionsInterfaces to query ClickHouse databases from PostgreSQL pg_clickhouse AnalyticsAnalytics · Extensions pg_client_encodingFunctionsReferencepg_client_encoding String Functions And Operators 10 Current client encoding name pg_client_encoding ( ) → name Current client encoding name 11 12 13 Returns current client encoding name. pg…Functions · String Functions And Operators pg_climbExtensionsExtensionsRock-climbing grade conversion and utility functions. climbing grade conversion statistics pg_climb Functions and aggregatesFunctions and aggregates · Extensions pg_colbert_llamaExtensionsExtensionsColBERT embedding companion extension for pgturbohybrid bm25 hybrid hybrid-search pgvector postgres-extension postgresql rag retrieval turboquant vector-search pg_colbert_llama AI and vector…AI and vectors · Extensions pg_collationManual ChaptersPG1852.12. pg_collation The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories. See Section 23.2 for m…pg_collation pg_collationCatalogs & ViewsReferencepg_collation System catalogs 10 The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories. See Sectio…System Catalogs · System catalogs pg_collation_actual_versionFunctionsReferencepg_collation_actual_version System Administration Functions 10 Return actual version of collation from operating system pg_collation_actual_version ( oid ) → text Return actual version of co…Functions · System Administration Functions pg_collation_is_visibleFunctionsReferencepg_collation_is_visible System Information Functions And Operators 10 is collation visible in search path pg_collation_is_visible ( collation_oid ) → boolean is collation visible in search p…Functions · System Information Functions And Operators pg_collkeyExtensionsExtensionsICU collation function wrapper collation icu unicode pg_collkey UtilitiesUtilities · Extensions pg_colorExtensionsExtensionsColor data type for PostgreSQL pg_color Data typesData types · Extensions pg_column_compressionFunctionsReferencepg_column_compression System Administration Functions 14 Shows the compression algorithm that was used to compress an individual variable-length value. Returns NULL if the value is not compr…Functions · System Administration Functions pg_column_sizeFunctionsReferencepg_column_size System Administration Functions 10 Number of bytes used to store a particular value (possibly compressed) pg_column_size ( any ) → int Number of bytes used to store a particul…Functions · System Administration Functions pg_column_tetrisExtensionsExtensionsEnforce optimal column alignment to minimize row padding pg_column_tetris AdministrationAdministration · Extensions pg_column_toast_chunk_idFunctionsReferencepg_column_toast_chunk_id System Administration Functions 17 Shows the chunk_id of an on-disk TOASTed value. Returns NULL if the value is un-TOASTed or not on-disk. See Section 65.2 for more …Functions · System Administration Functions pg_columnmaskExtensionsExtensionsAmazon Aurora PostgreSQL extension for role-based dynamic column masking without changing stored data. aurora aws data-masking pg_columnmask SecuritySecurity · Extensions pg_combinebackupCommand-line ToolsPG18pg_combinebackup pg_combinebackup — reconstruct a full backup from an incremental backup and dependent backups Synopsis pg_combinebackup [option...] [backup_directory...]pg_combinebackup pg_combinebackupManual ChaptersPG18pg_combinebackup pg_combinebackup — reconstruct a full backup from an incremental backup and dependent backups Synopsis pg_combinebackup [option...] [backup_directory...]pg_combinebackup pg_combinebackup --cloneCommand-line ToolsPG18--clone Use efficient file cloning (also known as “reflinks” on some systems) instead of copying files to the new data directory, which can result in near-instantaneous copying of the data f…pg_combinebackup › Options pg_combinebackup --copyCommand-line ToolsPG18--copy Perform regular file copy. This is the default. (See also --copy-file-range, --clone, and -k/--link.)pg_combinebackup › Options pg_combinebackup --copy-file-rangeCommand-line ToolsPG18--copy-file-range Use the copy_file_range system call for efficient copying. On some file systems this gives results similar to --clone, sharing physical disk blocks, while on others it may …pg_combinebackup › Options pg_combinebackup --debugCommand-line ToolsPG18-d--debug Print lots of debug logging output on stderr.pg_combinebackup › Options