Learning #postgresql part 3: Secure your connection, Manage users/permissions, schemas & tables



Learning #postgresql part 3: Secure your connection, Manage users/permissions, schemas & tables

Learning #postgresql part 3: Secure your connection, Manage users/permissions,  schemas & tables

Week 1: Setup local = Naaaah
Week 2:
Setup Docker
Set up pgAdmin Client
Installed PostgreSQL on Docker
Week 3:
Secure your connection
Manage users & permissions
Create schemas & tables

Steps taken for setup
1. Initiate Docker
2. Run PostgreSQL and pgAdmin containers
3. Click pgAdmin Port & login
4. On the left, under servers shows the one setup last week
Whatever name for postgres that was previously setup
5. After PG is selected under server, select portion to edit
A- Under 2nd top menu, click “properties”, click pencil to edit
B- Right click selected item a select “create new”