usql? But why? usql is a universal command-line interface for many database. But why are we still using CLI (command […]
JSON logs in PostgreSQL 15
Find out how JSON logs can be configured in PostgreSQL 15 and get all the advantages of this brand new feature
hex, oct, bin integers in PostgreSQL 16
SQL and integer notations NEW in PostgreSQL 16 - support for non-decimal notation of integer constants! PostgreSQL already has powerful […]
UNION ALL, data types and performance
by
Laurenz Albe |
12.2022 A while ago, I wrote about the performance impact of query parameter data types. Recently I encountered a similar […]
How to corrupt your PostgreSQL database
by
Laurenz Albe |
08.2022Of course most people do not want to corrupt their databases. These people will profit from avoiding the techniques used […]
Transaction anomalies with SELECT FOR UPDATE
by
Laurenz Albe |
06.2022© Laurenz Albe 2022 I was recently confronted with a nice example of how adding FOR UPDATE to a query […]
How to cancel a hanging PostgreSQL query
by
Laurenz Albe |
05.2022 Sometimes a PostgreSQL query takes forever. Usually, it is easy to interrupt (cancel) such a statement, but sometimes it […]
PostgreSQL 15: Using MERGE in SQL
Merge - UPDATED 2023 - a technical preview of how to merge lists with ease. Find out about a wonderful command - add power to your PostgreSQL.
Multiranges in PostgreSQL 14
Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.
How to DROP ROLE or DROP USER in PostgreSQL
by
Laurenz Albe |
03.2022 You might, at first glance, believe that DROP ROLE (or DROP USER, which is the same) is a simple […]
