PostgreSQL important commands

1- To go into postgreSQL db

postgres=# sudo su - postgres

2- To check the database port and user name

postgres=# \conninfo

3- To disconnect from postgreSQL

postgres=# \q

4- Check postgres version

$ psql -version

Reset the password of postgresSQL

step-1 first login in postgres database then

ALTER USER "user_name" WITH PASSWORD 'new_password';

How to install postgres

Click here- Install Postgres