(Updated 2023-04-07) Even if you understand what a deadlock is, debugging deadlocks can be tricky. This article shows some […]
Case-insensitive pattern matching in PostgreSQL
by
Laurenz Albe |
06.2022 (Updated on 2024-11-27) Case-insensitive search is a much-requested feature, partly (I suspect) to maintain compatibility with Microsoft SQL […]
Next to character encoding, time zones are among the least-loved topics in computing. In addition, PostgreSQL's implementation of timestamp […]
Data Normalization in PostgreSQL
In his blog "Normalization by Osmosis", Michał Małecki gives you an overview of data normalization in PostgreSQL, including normal forms
PostgreSQL on WSL2 for Windows: Install and setup
UPDATE on 23.02.2023: This post explains how to install PostgreSQL on WSL2 for Windows, apply the necessary changes to PostgreSQL […]
Most database tables have an artificial numeric primary key, and that number is usually generated automatically using a sequence. […]
Creating and refreshing materialized views in PostgreSQL
A “materialized view” is an integral feature of every advanced database system. How can you make use of materialized views in PostgreSQL?
For many people, “cross join” is something to be afraid of. They remember the time when they forgot the […]
What to return from a PostgreSQL row level trigger?
by
Laurenz Albe |
04.2021 In this article, I'll talk about row level triggers, which are the most frequently used kind of triggers. I […]
PostgreSQL: How to write a trigger
UPDATED 2023: A trigger is a way to automatically respond to events. This is a tutorial on how to manage and program triggers in PostgreSQL.