Lessons
Partitioning (???????????) ???? ???
Database Connection Pooling
Postgres Command
Using PostgreSQL on Linux via Terminal
PostgreSQL Users & Login
???? Default system user
-
Linux user: postgres
-
DB superuser: postgres
Linux user: postgres
DB superuser: postgres
Login to PostgreSQL
sudo -u postgres psql
Exit: \q
Module 4: Database Operations
Create Database
CREATE DATABASE users;List Databases
\lConnect to DB
\c usersDrop Database
DROP DATABASE users;
View Tables
Describe Table
\d manage_trackings