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.

Introduction.
Lesser known features from PG 10+.
# of updated & inserted rows at upsert.
Sleeping.
Match against multiple patterns.
Generate reproducible random data.
Dollar quoting.
Prevent setting the value of an auto-generated key.
Add constraints without validating immediately.
PSQL tips.
Q&A with Haki & Claire .