Connect to postrgres with psql password Authentication

Connect to postgres DB and…

Login

Blog History

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

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.