Connect to postgres DB and show the server version (full string and
psql -U myuser-d mydb -h localhost
Password for user myuser:
mydb=# SELECT VERSION();
# output
PostgreSQL 15.2 (Debian 15.2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
mydb=# show server_version;
# output
15.2 (Debian 15.2-1.pgdg110+1)
0 Comments