What is a schema in PostgreSQL?
What is a schema in PostgreSQL? Why do we need a schema and how can schemas be used to make your life easier? Let's find out.
PostgreSQL ALTER DEFAULT PRIVILEGES - permissions explained
by
Laurenz Albe |
05.2023 Many people have heard that ALTER DEFAULT PRIVILEGES makes it easy to allow other users access to tables. But […]
EXPLAIN (GENERIC_PLAN): New in PostgreSQL 16
by
Laurenz Albe |
04.2023 A while ago, I wrote about how difficult it is to get an execution plan for a parameterized query. […]
Parallel aggregate - PostgreSQL 16 - better performance
What is a parallel aggregate? In PostgreSQL, a parallel aggregate refers to a way of processing aggregate functions (such as […]
Breaking your PostgreSQL database with bad CHECK constraints
by
Laurenz Albe |
03.2023I am on a spree! After writing about breaking your database and transaction ID wraparound, here I am writing about […]
PostgREST: Get started with automated PostgreSQL APIs
PostgREST quick-start guide: Writing APIs by hand is a lot of work. PostgREST automatically generates an API out of your PostgreSQL database.
ER diagrams with SQL and Mermaid
What does ER stand for? An Entity Relationship (ER) diagram is one of the most important tools for database design. […]
Go & PostgreSQL: FOSDEM 2023 talk
Intro On the 5th of February 2023, I had the privilege of giving a talk at the PostgreSQL devroom during […]
PostgreSQL: Finding the current timestamp
How can I find the current timestamp in PostgreSQL? Read more about real time, statement time and transaction time.
A unique constraint where NULL conflicts with everything
by
Laurenz Albe |
01.2023 I have been faced with a request for an unusual unique constraint that puzzled me for a while. Since […]
