PostgreSQL
Queries & Joins
Queries & Joins Basic SELECT -- Basic query SELECT id, name, email FROM users WHERE active = true ORDER BY name LIMIT 10 OFFSET 20; -- Aliases and expressions S…
Queries & Joins Basic SELECT -- Basic query SELECT id, name, email FROM users WHERE active = true ORDER BY name LIMIT 10 OFFSET 20; -- Aliases and expressions S…
Indexes & Performance Index Types B-tree — default, great for =, <, >, BETWEEN, LIKE prefix Hash — only equality (=), faster than B-tree for exact lookups GIN —…
Advanced Features Window Functions -- ROW_NUMBER, RANK, DENSE_RANK SELECT name, department, salary, ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary D…
PostgreSQL Interview Questions Q: What is the difference between CHAR, VARCHAR, and TEXT? CHAR(n) is fixed-length, padded with spaces. VARCHAR(n) is variable-le…
Save this stack to your personal DevRecall — add your own notes, track what you're learning, and share what you know with the community.
Get started — free forever