Search PostgreSQL documentation

pg_cheat_funcsExtensionsExtensionsAdministration · ExtensionsProvides cheat (but useful) functions pg_cheat_funcs Administration pg_checkExtensionsExtensionsAdministration · ExtensionsProvides basic integrity checks for data files. check corruption data integrity structure pg_check Administration pg_checkdestroyExtensionsExtensionsAdministration · Extensionscheck sql drop&delete&truncate table destructive-statement guard shared-preload pg_checkdestroy Administration pg_checksumsCommand-line ToolsPG18enable, disable or check data checksums in a PostgreSQL database cluster Synopsis pg_checksums [option...] [[ -D | --pgdata ]datadir] pg_checksumsManual ChaptersPG18enable, disable or check data checksums in a PostgreSQL database cluster Synopsis pg_checksums [option...] [[ -D | --pgdata ]datadir] pg_checksumsExtensionsExtensionsAdministration · ExtensionsActivate/deactivate/verify checksums in offline Postgres clusters bin pg_checksums Administration pg_checksums --checkCommand-line ToolsPG18pg_checksums › Optionsc--check Checks checksums. This is the default mode if nothing else is specified. pg_checksums --disableCommand-line ToolsPG18pg_checksums › Optionsd--disable Disables checksums. pg_checksums --enableCommand-line ToolsPG18pg_checksums › Optionse--enable Enables checksums. pg_checksums --filenode=filenodeCommand-line ToolsPG18pg_checksums › Optionsf filenode--filenode=filenode Only validate checksums in the relation with filenode filenode. pg_checksums --helpCommand-line ToolsPG18pg_checksums › Options?--help Show help about pg_checksums command line arguments, and exit. pg_checksums --no-syncCommand-line ToolsPG18pg_checksums › OptionsN--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 subsequ… pg_checksums --pgdata=directoryCommand-line ToolsPG18pg_checksums › OptionsD directory--pgdata=directory Specifies the directory where the database cluster is stored. pg_checksums --progressCommand-line ToolsPG18pg_checksums › OptionsP--progress Enable progress reporting. Turning this on will deliver a progress report while checking or enabling checksums. pg_checksums --sync-method=methodCommand-line ToolsPG18pg_checksums › Optionssync-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 link… pg_checksums --verboseCommand-line ToolsPG18pg_checksums › Optionsv--verbose Enable verbose output. Lists all checked files. pg_checksums --versionCommand-line ToolsPG18pg_checksums › OptionsV--version Print the pg_checksums version and exit. pg_circuitExtensionsExtensionsAdministration · ExtensionsRuntime observation, warnings and blocking for dangerous SQL statements guard ddl dml pg_circuit Administration pg_cjk_parserExtensionsExtensionsFull-text search · ExtensionsCJK bigram parser derived from PostgreSQL full-text search pg_cjk_parser Full-text search pg_classManual ChaptersPG18The 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 see also pg_seque… pg_cld2ExtensionsExtensionsFull-text search · ExtensionsDetects likely human language and script in PostgreSQL using CLD2. cld2 language language-detection pg_cld2 Full-text search pg_clickhouseExtensionsExtensionsAnalytics · ExtensionsInterfaces to query ClickHouse databases from PostgreSQL pg_clickhouse Analytics pg_climbExtensionsExtensionsFunctions and aggregates · ExtensionsRock-climbing grade conversion and utility functions. climbing grade conversion statistics pg_climb Functions and aggregates pg_colbert_llamaExtensionsExtensionsAI and vectors · ExtensionsColBERT embedding companion extension for pgturbohybrid bm25 hybrid hybrid-search pgvector postgres-extension postgresql rag retrieval turboquant vector-search pg_colbert_llama AI and vector… pg_collationManual ChaptersPG18The 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 more information. Tab… pg_collkeyExtensionsExtensionsUtilities · ExtensionsICU collation function wrapper collation icu unicode pg_collkey Utilities pg_colorExtensionsExtensionsData types · ExtensionsColor data type for PostgreSQL pg_color Data types pg_column_tetrisExtensionsExtensionsAdministration · ExtensionsEnforce optimal column alignment to minimize row padding pg_column_tetris Administration pg_columnmaskExtensionsExtensionsSecurity · ExtensionsAmazon Aurora PostgreSQL extension for role-based dynamic column masking without changing stored data. aurora aws data-masking pg_columnmask Security pg_combinebackupCommand-line ToolsPG18reconstruct a full backup from an incremental backup and dependent backups Synopsis pg_combinebackup [option...] [backup_directory...] pg_combinebackupManual ChaptersPG18reconstruct a full backup from an incremental backup and dependent backups Synopsis pg_combinebackup [option...] [backup_directory...] pg_combinebackup --cloneCommand-line ToolsPG18pg_combinebackup › Optionsclone 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 fil… pg_combinebackup --copyCommand-line ToolsPG18pg_combinebackup › Optionscopy Perform regular file copy. This is the default. (See also --copy-file-range, --clone, and -k/--link.) pg_combinebackup --copy-file-rangeCommand-line ToolsPG18pg_combinebackup › Optionscopy-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 st… pg_combinebackup --debugCommand-line ToolsPG18pg_combinebackup › Optionsd--debug Print lots of debug logging output on stderr. pg_combinebackup --dry-runCommand-line ToolsPG18pg_combinebackup › Optionsn--dry-run The -n/--dry-run option instructs pg_combinebackup to figure out what would be done without actually creating the target directory or any output files. It is particularly useful i… pg_combinebackup --helpCommand-line ToolsPG18pg_combinebackup › Options?--help Shows help about pg_combinebackup command line arguments, and exits. pg_combinebackup --linkCommand-line ToolsPG18pg_combinebackup › Optionsk--link Use hard links instead of copying files to the synthetic backup. Reconstruction of the synthetic backup might be faster (no file copying) and use less disk space, but care must be ta… pg_combinebackup --manifest-checksums=algorithmCommand-line ToolsPG18pg_combinebackup › Optionsmanifest-checksums=algorithm Like pg_basebackup, pg_combinebackup writes a backup manifest in the output directory. This option specifies the checksum algorithm that should be applied to eac… pg_combinebackup --no-manifestCommand-line ToolsPG18pg_combinebackup › Optionsno-manifest Disables generation of a backup manifest. If this option is not specified, a backup manifest for the reconstructed backup will be written to the output directory.