Hans-Jürgen Schönig

Founder & CEO of CYBERTEC

Hans-Jürgen Schönig has worked with PostgreSQL since the 90's. He is the CEO and technical lead of CYBERTEC PostgreSQL International, a market leader in the field. He's served countless customers around the globe since the year 2000. He is also the author of the well-received "Mastering PostgreSQL" book series, as well as several other books about PostgreSQL replication and administration.

Articles by Hans-Jürgen Schönig

LISTEN / NOTIFY: Automatic client notification in PostgreSQL

by Hans-Jürgen Schönig | 09.2022

What is LISTEN and NOTIFY? LISTEN / NOTIFY is a feature that enables users to listen to what goes on […]

How To

PostgreSQL: Sequences vs. Invoice numbers

by Hans-Jürgen Schönig | 09.2022

Sequences are a core feature of SQL. However, some users are tempted to implement sequences to generate invoices. That's dangerous […]

How To

What is an inner join in SQL? And what is an outer join?

by Hans-Jürgen Schönig | 09.2022

A join is a concept in IT which is widely used and often referred to but rarely really understood. What […]

How To

ERROR: nextval: reached maximum value of sequence

by Hans-Jürgen Schönig | 09.2022

serial is a popular pseudo data type in PostgreSQL which is often used to generate auto-increment columns. However, this can […]

How To

ALTER TABLE ... ADD COLUMN … done right in PostgreSQL

by Hans-Jürgen Schönig | 08.2022

Running ALTER TABLE … ADD COLUMN can have side effects which have the potential to cause serious issues in production. […]

How To

Column order in PostgreSQL does matter

by Hans-Jürgen Schönig | 07.2022

I've recently seen some really broad tables (hundreds of columns) in a somewhat inefficiently structured database. Our PostgreSQL support customer […]

Performance