Postgresql

Postgresql Basic Commands
Login to postgresql: psql -d mydb -U myuser -W psql -h myhost -d mydb -U myuser -W psql -U myuser -h myhost "dbname=mydb sslmode=require" # ssl connection Default Admin Login: sudo -u postgres psql -U postgres sudo -u postgres psql List databases on postgresql server: psql -l [-U myuser] [-W]
https://jazstudios.blogspot.com/2010/06/postgresql-login-commands.html
What's the difference between sudo su - postgres and sudo -u postgres?
There is no benefit to using sudo su, it's an anachronistic habit from when people were used to using su. People started tacking sudo in front when Linux distros stopped setting a root password and made sudo the only way to access the root account. Rather than change their habits, they just used sudo su.
https://serverfault.com/questions/601140/whats-the-difference-between-sudo-su-postgres-and-sudo-u-postgres
Learn PostgreSQL Tutorial - Full Course for Beginners
Learn how to use PostgreSQL in this full course. PostgreSQL is a general purpose and object-relational database management system. It is the most advanced op...
https://www.youtube.com/watch?v=qw--VYLpxG4
Docker and PostgreSQL in [10 Minutes]
Docker is a fantastic way to run spin up containers that work on any environment removing the saying "BUT IT WORKS ON MY MACHINE". In this tutorial you will ...
https://www.youtube.com/watch?v=aHbE3pTyG-Q&t=982s
Spring Boot Connect to PostgreSQL Database Example
Learn how to write Java code that connects to PostgreSQL Database Server in a Spring Boot application with:- JdbcTemplate for connecting and execute a SQL In...
https://www.youtube.com/watch?v=GyFBp5v4tHY
Spring Boot 2.1 Tutorial | Connecting to Databases | 2019
Spring Boot 2.0 is an amazing framework for building java applications. Its awesome for enterprise and using it on your own projects. ➡️Grab source code here...
https://www.youtube.com/watch?v=8fbfHu8isI4