Online / 5 & 6 February 2022

visit

Lesser Known PostgreSQL Features

Features you already have but may not know about!


In the talk I want to present a few lesser know, but useful features you may never heard about! For example, do you know how you can get the number of inserted and update rows in an upsert? how to create reproducible random data for testing and demonstrations? match a text against multiple patterns without complicated condition? How about using \copy with multi-line queries? All that and more... in my talk :)

In this talk I'll present lesser known features in PostgreSQL such as:

  • How you can get the number of inserted and update rows in an upsert
  • How to create reproducible random data for testing and demonstration
  • How to match a text against multiple patterns without complicated condition
  • How to use \copy with multi-line queries
  • And many more fun features from the deep end of the documentation!

Speakers

Haki Benita

Links