conferences | speakers | series

Lesser Known PostgreSQL Features

home

Lesser Known PostgreSQL Features
FOSDEM 2022

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