How to know the PostgreSQL version I am connected to using a query?

Question

I do not have access to the server where the PostgreSQL is running, how to know the version I am connected to using a query?

Karthik Divi · Accepted Answer

You can run the following command to see the version of PostgreSQL you are connected to.

```sql
SELECT version();
```

Sample output
```
PostgreSQL 9.5.17 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609, 64-bit
```

1 Answer