#Spring Boot Practice using Postgres
Technologies
- Java - Spring Boot Framework
- Postman - Testing API
- PostreSQL - Database
Starter Project Dependencies
- spring-boot-starter-data-jpa
- spring-boot-starter-web
- postgresql
Postgres Guide
login to postgre
psql user=<username>
list all database
\l or \list
list users
\du
connect to database
\c <database name>
create dabatase
CREATE DATABASE <db name>;
create new username w/o password
CREATE USER username;
create new username w/ password
CREATE USER username WITH PASSWORD 'password'
Grant all privileges on data to the specific user
GRANT ALL PRIVILEGES ON DATABASE <db name> TO <user>;
Learn โค๏ธ + Grind ๐บ