Lesser Known Features of PostgreSQL
Discover lesser-known but powerful PostgreSQL features in this conference talk from Citus Con: An Event for Postgres 2022. Explore techniques such as retrieving the number of inserted and updated rows in an upsert, creating reproducible random data for testing, matching text against multiple patterns efficiently, and using \copy with multi-line queries. Learn about sleeping functions, dollar quoting, preventing auto-generated key value setting, and adding constraints without immediate validation. Gain valuable PSQL tips and insights from technical lead and DBA Haki Benita, who specializes in databases, web development, and performance tuning. The talk includes a Q&A session and provides timestamps for easy navigation through various topics, making it an essential resource for PostgreSQL users looking to enhance their database management skills.