SELECT 'amazing_features' FROM "postgresql"
summary
Demos concrete PostgreSQL features using the Sakila sample database: readable pipelines with common table expressions, window functions (FILTER, row_number) to find and delete duplicates (exactly 40 rows removed), and RETURNING to skip extra SELECTs. Covers switching SERIAL to UUIDs with the ossp extension and client-side ID generation, creating domains/types/operators for validation, comparing LTREE vs recursive CTEs for hierarchies, using file and postgres foreign data wrappers, and using LISTEN/NOTIFY to push JSON payloads to applications, with commands and results shown.
AI-written summary · about
related talks
45mSELECT 'amazing_features' FROM "postgresql"
49mSELECT 'amazing features' FROM "postgresql"
48mSELECT 'amazing_features' FROM "postgresql"
44mSELECT 'amazing_features' FROM "posgresql"
30mLesser known features of PostgreSQL
34mSimple and Awesome Database Tricks
01h 09mReplacing Oracle Features in PostgreSQL: HA, Functions & Extensibility
29mPostgres Demystified