immich/server/src/queries/database.repository.sql

-- NOTE: This file is auto generated by ./sql-generator

-- DatabaseRepository.getExtensionVersions
SELECT
  name,
  default_version as "availableVersion",
  installed_version as "installedVersion"
FROM
  pg_available_extensions
WHERE
  name in ($1)

-- DatabaseRepository.getPostgresVersion
SHOW server_version