Connect to postrgres with psql password Authentication

by | Apr 4, 2023 | IT Tips | 0 comments

Connect to postgres DB and show the server version (full string and

?
1
2
3
4
5
6
7
8
9
10
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

Submit a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.