Lesser Known PostgreSQL Features
summary
Covers several lesser-known PostgreSQL features and how to use them in practice: obtaining counts of inserted vs. updated rows in an UPSERT (INSERT ... ON CONFLICT), generating reproducible random test/demo data, matching text against multiple patterns with concise SQL, and using psql’s \copy with multi-line queries, plus other deeper-dive documentation examples.
AI-written summary · about
related talks
30mLesser known features of PostgreSQL
45mSELECT 'amazing_features' FROM "postgresql"
53mBreakout Session
49mSELECT 'amazing features' FROM "postgresql"
29mSELECT 'amazing_features' FROM "postgresql"
34mSimple and Awesome Database Tricks
54mBreakout Session
51mExploring new enhancements and improvements Fujitsu has delivered to