Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Lesser Known Features of PostgreSQL

Microsoft via YouTube

Overview

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.

Syllabus

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 .

Taught by

Microsoft Developer

Reviews

Start your review of Lesser Known Features of PostgreSQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.