AWS aurora-dsql documentation change

Service: aurora-dsql · 2026-03-16 · Documentation low

File: aurora-dsql/latest/userguide/working-with-systems-tables.md

Summary

Added system version queries (Aurora DSQL major version and PostgreSQL version) to system tables documentation.

Security assessment

The changes add informational queries for retrieving database version information. This is general documentation improvement without security implications or references to security features. Version disclosure could theoretically aid attackers, but there's no security context provided in the diff.

Diff

diff --git a/aurora-dsql/latest/userguide/working-with-systems-tables.md b/aurora-dsql/latest/userguide/working-with-systems-tables.md
index d2183ee23..619b98722 100644
--- a//aurora-dsql/latest/userguide/working-with-systems-tables.md
+++ b//aurora-dsql/latest/userguide/working-with-systems-tables.md
@@ -9 +9 @@ System tablesUseful system queriesThe ANALYZE command
-See the following sections to learn about the supported system tables and catalogs in Aurora DSQL.
+See the following sections to learn about the supported system tables and catalogs in Aurora DSQL as well as useful queries for fetching information about the system, such as the version.
@@ -230 +230 @@ The view `sys.iam_pg_role_mappings` provides information about the permissions g
-Use these queries to get table statistics and metadata without performing expensive operations like full table scans.
+Use these queries to get table statistics and system metadata without performing expensive operations like full table scans.
@@ -247,0 +248,32 @@ This approach is more efficient than `SELECT COUNT(*)` for large tables in Auror
+### Get current Aurora DSQL major version
+
+To get the current major version of the Aurora DSQL cluster, use the following query:
+    
+    
+    SELECT * FROM sys.dsql_major_version();
+
+The command returns output similar to the following:
+    
+    
+     dsql_major_version
+    --------------------
+                      1
+
+This returns the major version the SQL connection is on in Aurora DSQL.
+
+### Get current PostgreSQL version
+
+To get the current PostgreSQL version of the Aurora DSQL cluster, use the following query:
+    
+    
+    SHOW server_version;
+
+The command returns output similar to the following:
+    
+    
+     server_version
+    ----------------
+     16.13
+
+This returns the PostgreSQL version the SQL connection is on in Aurora DSQL.
+