Search PostgreSQL documentation

pg_amprocManual ChaptersPG1852.5. pg_amproc The catalog pg_amproc stores information about support functions associated with access method operator families. There is one row for each support function belonging to an o…pg_amproc pg_amprocCatalogs & ViewsReferencepg_amproc System catalogs 10 The catalog pg_amproc stores information about support procedures associated with access method operator families. There is one row for each support procedure be…System Catalogs · System catalogs pg_analyticsExtensionsExtensionsPostgres for analytics, powered by DuckDB duckdb pgrx pg_analytics AnalyticsAnalytics · Extensions pg_archivecleanupManual ChaptersPG18pg_archivecleanup pg_archivecleanup — clean up PostgreSQL WAL archive files Synopsis pg_archivecleanup [option...] archivelocation oldestkeptwalfilepg_archivecleanup pg_argon2idExtensionsExtensionsPostgreSQL extension for Argon2id password hashing functions pg_argon2id SecuritySecurity · Extensions pg_array_multi_indexExtensionsExtensionssimultaneous multiple-indexing of PostgreSQL arrays array function indexing pg_array_multi_index Functions and aggregatesFunctions and aggregates · Extensions pg_ascii_movieExtensionsExtensionspg ascii movie is a PostgreSQL extension to watch ascii movies. ascii-movies plpgsql postgresql-extension pg_ascii_movie FeaturesFeatures · Extensions pg_askExtensionsExtensionsPostgres Extension which uses AI to create SQL from Natural language. pg_ask AI and vectorsAI and vectors · Extensions pg_asyncExtensionsExtensionsC extension that provides async LISTEN/NOTIFY queue support on PostgreSQL replicas in hot standby. async listen-notify queue shared-preload pg_async FeaturesFeatures · Extensions pg_attrdefManual ChaptersPG1852.6. pg_attrdef The catalog pg_attrdef stores column default expressions and generation expressions. The main information about columns is stored in pg_attribute. Only columns for which a d…pg_attrdef pg_attrdefCatalogs & ViewsReferencepg_attrdef System catalogs 10 The catalog pg_attrdef stores column default values. The main information about columns is stored in pg_attribute (see below). Only columns that explicitly spec…System Catalogs · System catalogs pg_attributeManual ChaptersPG1852.7. pg_attribute The catalog pg_attribute stores information about table columns. There will be exactly one pg_attribute row for every column in every table in the database. (There will al…pg_attribute pg_attributeCatalogs & ViewsReferencepg_attribute System catalogs 10 The catalog pg_attribute stores information about table columns. There will be exactly one pg_attribute row for every column in every table in the database. (…System Catalogs · System catalogs pg_auditExtensionsExtensionsAn extension for creating audit tables audit history trigger pg_audit SecuritySecurity · Extensions pg_audit_toolsExtensionsExtensionsPostgreSQL extension for audit tables management pg_audit_tools SecuritySecurity · Extensions pg_auditorExtensionsExtensionsAudit data changes and provide flashback ability pg_auditor SecuritySecurity · Extensions pg_auth_membersManual ChaptersPG1852.9. pg_auth_members The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed. Because user identities are cluster-wide, pg…pg_auth_members pg_auth_membersCatalogs & ViewsReferencepg_auth_members System catalogs 10 The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed. Because user identities are cl…System Catalogs · System catalogs pg_auth_monExtensionsExtensionsmonitor connection attempts per user pg_auth_mon SecuritySecurity · Extensions pg_authidManual ChaptersPG1852.8. pg_authid The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of “users” and “groups”. A user is essentially just …pg_authid pg_authidCatalogs & ViewsReferencepg_authid System catalogs 10 The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of “users” and “groups”. A user is esse…System Catalogs · System catalogs pg_available_extension_versionsManual ChaptersPG1853.4. pg_available_extension_versions The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the pg_extension catalog, w…pg_available_extension_versions pg_available_extension_versionsCatalogs & ViewsReferencepg_available_extension_versions System views 10 The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the pg_extension …System Catalogs · System views pg_available_extensionsManual ChaptersPG1853.3. pg_available_extensions The pg_available_extensions view lists the extensions that are available for installation. See also the pg_extension catalog, which shows the extensions current…pg_available_extensions pg_available_extensionsCatalogs & ViewsReferencepg_available_extensions System views 10 The pg_available_extensions view lists the extensions that are available for installation. See also the pg_extension catalog, which shows the extensio…System Catalogs · System views pg_available_wal_summariesFunctionsReferencepg_available_wal_summaries System Information Functions And Operators 17 Returns information about the WAL summary files present in the data directory, under pg_wal/summaries. One row will b…Functions · System Information Functions And Operators pg_backend_memory_contextsManual ChaptersPG1853.5. pg_backend_memory_contexts The view pg_backend_memory_contexts displays all the memory contexts of the server process attached to the current session. pg_backend_memory_contexts contai…pg_backend_memory_contexts pg_backend_memory_contextsCatalogs & ViewsReferencepg_backend_memory_contexts System views 14 The view pg_backend_memory_contexts displays all the memory contexts of the server process attached to the current session. pg_backend_memory_cont…System Catalogs · System views pg_backend_pidFunctionsReferencepg_backend_pid System Information Functions And Operators 10 Process ID of the server process attached to the current session pg_backend_pid ( ) → int Process ID of the server process attach…Functions · System Information Functions And Operators pg_backgroundExtensionsExtensionsRun SQL queries in the background pg_background Time seriesTime series · Extensions pg_background_queueExtensionsExtensionsTopic-aware background SQL task queue with concurrency limits and retries. queue background-worker retry scheduler pg_background_queue Time seriesTime series · Extensions pg_backtraceExtensionsExtensionsShow backtrace for errors and signals backtrace debugging error pg_backtrace MonitoringMonitoring · Extensions pg_backup_startFunctionsReferencepg_backup_start System Administration Functions 15 Prepares the server to begin an on-line backup. The only required parameter is an arbitrary user-defined label for the backup. (Typically t…Functions · System Administration Functions pg_backup_start_timeFunctionsReferencepg_backup_start_time System Administration Functions 10 Get start time of an on-line exclusive backup in progress. pg_backup_start_time ( ) → timestamp with time zone Get start time of an on…Functions · System Administration Functions pg_backup_stopFunctionsReferencepg_backup_stop System Administration Functions 15 Finishes performing an on-line backup. The desired contents of the backup label file and the tablespace map file are returned as part of the…Functions · System Administration Functions pg_base58ExtensionsExtensionsBase58 Encoder/Decoder Extension for PostgreSQL pgrx pg_base58 Functions and aggregatesFunctions and aggregates · Extensions pg_base62ExtensionsExtensionsEncode UUID values to URL-safe Base62 strings and decode them back. base62 pgrx postgresql rust uuidv7 pg_base62 UtilitiesUtilities · Extensions pg_basebackupCommand-line ToolsPG18pg_basebackup pg_basebackup — take a base backup of a PostgreSQL cluster Synopsis pg_basebackup [option...]pg_basebackup pg_basebackupManual ChaptersPG18pg_basebackup pg_basebackup — take a base backup of a PostgreSQL cluster Synopsis pg_basebackup [option...]pg_basebackup pg_basebackup --checkpoint={fast|spread}Command-line ToolsPG18-c {fast|spread}--checkpoint={fast|spread} Sets checkpoint mode to fast (immediate) or spread (the default) (see Section 25.3.4).pg_basebackup › Options