RDBMS Information - PostgreSQL - How to check the postgres server version by performing a query on a schema of the server

Created by Unknown User (sse_20162) on Feb 11, 2022
Purpose
 The page details the process to check the postgre server version by performing a query on a schema of the server.
Applicable Platform or <Sub Platform Version>


Platform or <Sub Platform Version>

Yes/No



Details
  1. Log in to PG Admin.
  2. Open SQL editor.

  3. Run the below query

    select version()

    Example of results

    "PostgreSQL 9.1.8 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit"

    Expected results for CSS1

    PostgreSQL 8.4.1, compiled by Visual C++ build 1400, 32-bit

    Expected results for CSS2 

    PostgreSQL 9.2.3, compiled by Visual C++ build 1600, 64-bit
Notes/comments