Aurora PostgreSQL – Check version

You can check the version of your Postgresql database using the below query:

SELECT VERSION();

Below select query gives the patch number specific to your Amazon Aurora PostgreSQL Installation.

SELECT aurora_version();

Output is as follows:

aurora_version
--------------
12.8.4
See also  PostgreSQL - Change Owner of Tablespace