Lessons
Partitioning (???????????) ???? ???
Database Connection Pooling
Postgres Command
Sign to Postgres psql
PostgreSQL psql Cheat Sheet (Docker Friendly)
Docker container me PostgreSQL ke common commands aur tips ek hi jagah.
1️⃣ Docker me PostgreSQL se Connect karna
docker exec -it my_postgres psql -U postgres
Yahan my_postgres container ka naam hai, aur postgres username.
2️⃣ Databases List karna
\l
Saare databases ka list show hota hai.
3️⃣ Database me Switch karna
\c mydb
Ab prompt me database mydb select ho jayega.
4️⃣ Tables List karna
\dt
Agar tables nahi hain, toh message aayega: No relations found.
5️⃣ Table ka Structure Dekhna
\d tablename
Example: \d users
6️⃣ Table Create Karna
CREATE TABLE users (
id SERIAL PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100) UNIQUE
);
7️⃣ Data Insert Karna
INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');
8️⃣ Data Query Karna
SELECT * FROM users;
9️⃣ SQL File se Migrations Apply Karna
docker exec -i my_postgres psql -U postgres -d mydb < ./migrations/001_create_table.sql
???? Other Useful psql Commands
| Command | Use |
|---|---|
| \q | Exit psql |
| \dt+ | List tables with extra info |
| \df | List functions |
| \dv | List views |
| \du | List roles/users |