Cheetsheet for PostGresql learning

psql.sh

# For Restoring the the backup in the given database
# While running on docker I first copied the local file to docker container and docker cp and did below
psql -U {db_user} -d database_name -f {db}.sql

sudo docker exec -e PGPASSWORD="" -t {docker_name} pg_dump -U postgres {db} > backuptody.sql

Changing the Password

ALTER USER your_user WITH PASSWORD 'new_password';