Search PostgreSQL documentation

pg_current_wal_flush_lsnFunctionsReferencepg_current_wal_flush_lsn System Administration Functions 10 Get current write-ahead log flush location pg_current_wal_flush_lsn ( ) → pg_lsn Get current write-ahead log flush location 11 12 …Functions · System Administration Functions pg_current_wal_insert_lsnFunctionsReferencepg_current_wal_insert_lsn System Administration Functions 10 Get current write-ahead log insert location pg_current_wal_insert_lsn ( ) → pg_lsn Get current write-ahead log insert location 11…Functions · System Administration Functions pg_current_wal_lsnFunctionsReferencepg_current_wal_lsn System Administration Functions 10 Get current write-ahead log write location pg_current_wal_lsn ( ) → pg_lsn Get current write-ahead log write location 11 12 13 Returns t…Functions · System Administration Functions pg_current_xact_idFunctionsReferencepg_current_xact_id System Information Functions And Operators 13 Returns the current transaction's ID. It will assign a new one if the current transaction does not have one already (because …Functions · System Information Functions And Operators pg_current_xact_id_if_assignedFunctionsReferencepg_current_xact_id_if_assigned System Information Functions And Operators 13 Returns the current transaction's ID, or NULL if no ID is assigned yet. (It's best to use this variant if the tra…Functions · System Information Functions And Operators pg_current_xlog_flush_locationFunctionsReferencepg_current_xlog_flush_location System Administration Functions 9.6 Get current transaction log flush location pg_current_xlog_flush_location ( ) → pg_lsn Get current transaction log flush lo…Functions · System Administration Functions pg_current_xlog_insert_locationFunctionsReferencepg_current_xlog_insert_location System Administration Functions 9.0 Get current transaction log insert location pg_current_xlog_insert_location ( ) → text Get current transaction log insert …Functions · System Administration Functions pg_current_xlog_locationFunctionsReferencepg_current_xlog_location System Administration Functions 9.0 Get current transaction log write location pg_current_xlog_location ( ) → text Get current transaction log write location 9.1 9.2…Functions · System Administration Functions pg_cursorsManual ChaptersPG1853.7. pg_cursors The pg_cursors view lists the cursors that are currently available. Cursors can be defined in several ways: via the DECLARE statement in SQL via the Bind message in the fron…pg_cursors pg_cursorsCatalogs & ViewsReferencepg_cursors System views 10 The pg_cursors view lists the cursors that are currently available. Cursors can be defined in several ways: The pg_cursors view displays cursors created by any of…System Catalogs · System views pg_cuvsExtensionsExtensions⚡ Blazing-fast GPU vector search for PostgreSQL powered by NVIDIA cuVS. approximate-nearest-neighbor cuda cuvs gpu multi-tenant nvidia pgvector postgresql postgresql-extension rag similarity…AI and vectors · Extensions pg_dagdbExtensionsExtensionsPostgreSQL SQL client extension for the DagDB graph engine daemon. pgrx pg_dagdb UtilitiesUtilities · Extensions pg_data_retentionExtensionsExtensionsPostgreSQL background-worker extension that applies table data retention policies. background-worker data-retention pgrx pg_data_retention AdministrationAdministration · Extensions pg_databaseManual ChaptersPG1852.15. pg_database The catalog pg_database stores information about the available databases. Databases are created with the CREATE DATABASE command. Consult Chapter 22 for details about the …pg_database pg_databaseCatalogs & ViewsReferencepg_database System catalogs 10 The catalog pg_database stores information about the available databases. Databases are created with the CREATE DATABASE command. Consult Chapter 22 for detail…System Catalogs · System catalogs pg_database_collation_actual_versionFunctionsReferencepg_database_collation_actual_version System Administration Functions 15 Returns the actual version of the database's collation as it is currently installed in the operating system. If this i…Functions · System Administration Functions pg_database_sizeFunctionsReferencepg_database_size System Administration Functions 10 Disk space used by the database with the specified OID pg_database_size ( oid ) → bigint Disk space used by the database with the specifie…Functions · System Administration Functions pg_datasentinelExtensionsExtensionsObservability and activity monitoring extension for PostgreSQL pg_datasentinel MonitoringMonitoring · Extensions pg_datatype_passwordExtensionsExtensionsSQL-only password data type and operators using pgcrypto Blowfish hashes, with trigger-based encryption before storage. encryption password pgcrypto type pg_datatype_password Data typesData types · Extensions pg_db_role_settingManual ChaptersPG1852.16. pg_db_role_setting The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database combination. Unlike mo…pg_db_role_setting pg_db_role_settingCatalogs & ViewsReferencepg_db_role_setting System catalogs 10 The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database combinatio…System Catalogs · System catalogs pg_dbms_errlogExtensionsExtensionsEmulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table. oracle pg_dbms_errlog CompatibilityCompatibility · Extensions pg_dbms_jobExtensionsExtensionsExtension to add Oracle DBMS_JOB full compatibility to PostgreSQL oracle dep-break pg_dbms_job CompatibilityCompatibility · Extensions pg_dbms_lockExtensionsExtensionsExtension to add Oracle DBMS_LOCK full compatibility to PostgreSQL oracle pg_dbms_lock CompatibilityCompatibility · Extensions pg_dbms_metadataExtensionsExtensionsExtension to add Oracle DBMS_METADATA compatibility to PostgreSQL oracle pg_dbms_metadata CompatibilityCompatibility · Extensions pg_dbms_statsExtensionsExtensionsStatistics management extension for stabilizing PostgreSQL execution plans using fixed statistics. plan-stability shared-preload statistics pg_dbms_stats AdministrationAdministration · Extensions pg_dbo_timestampExtensionsExtensionsPostgreSQL extension for storing time and author of database structure modification. audit ddl event-trigger pg_dbo_timestamp SecuritySecurity · Extensions pg_dbsmExtensionsExtensionstrack database size pg_dbsm MonitoringMonitoring · Extensions pg_dbwaExtensionsExtensionsAnalyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. monitoring query-statistics workload-analysis pg_dbwa MonitoringMonitoring · Extensions pg_dctpExtensionsExtensionsPreload-only module that blocks clear-text passwords in role DDL password security ddl-hook preload logging pg_dctp SecuritySecurity · Extensions pg_ddl_commandData TypesPG18pg_ddl_command Identifies a representation of DDL commands that is available to event triggers.Pseudo-Types pg_debug_scanExtensionsExtensionsDebug PostgreSQL table scans with custom MVCC snapshot definitions. pgrx pg_debug_scan FeaturesFeatures · Extensions pg_debyte_extExtensionsExtensionsExample PostgreSQL extension for decoding bytea payloads to JSON using pg_debyte Rust crates. pgrx pg_debyte_ext UtilitiesUtilities · Extensions pg_decode_infomaskExtensionsExtensionsPostgreSQL 9.6 C functions that decode heap tuple infomask and infomask2 hint bits into queryable fields. heap infomask tuple-header pg_decode_infomask AdministrationAdministration · Extensions pg_decode_recordExtensionsExtensionsHacky extension to extract SQL from WAL INSERT records; Originally from https://github.com/rjuju pg_decode_record AdministrationAdministration · Extensions pg_deeplakeExtensionsExtensionsDeeplake is AI Data Runtime for Agents. It provides serverless postgres with a multimodal datalake, enabling scalable retrieval and training. agent agentic-rag ai clawbot computer-vision dat…AI and vectors · Extensions pg_default_aclManual ChaptersPG1852.17. pg_default_acl The catalog pg_default_acl stores initial privileges to be assigned to newly created objects. Table 52.17. pg_default_acl Columns Column Type Description oid oid Row id…pg_default_acl pg_default_aclCatalogs & ViewsReferencepg_default_acl System catalogs 10 The catalog pg_default_acl stores initial privileges to be assigned to newly created objects. oid Row identifier (hidden attribute; must be explicitly selec…System Catalogs · System catalogs pg_deltaExtensionsExtensionsDelta Lake streaming integration for PostgreSQL pg_delta Replication and streamsReplication and streams · Extensions pg_delta_amExtensionsExtensionsDelta table access method skeleton iceberg lakebase lakehouse postgresql postgresql-extension pg_delta_am AnalyticsAnalytics · Extensions