CYBERTEC PostgreSQL Logo
Ants Aasma Profile Picture

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

What is a schema in PostgreSQL?

by Hans-Jürgen Schönig | 06.2023
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: DELETE vs. TRUNCATE

by Hans-Jürgen Schönig | 03.2023
Archiving and database cleanup in PostgreSQL: Find out how DELETE and TRUNCATE compare in terms of performance and how the magic works

PostgREST: Get started with automated PostgreSQL APIs

by Hans-Jürgen Schönig | 03.2023
PostgREST quick-start guide: Writing APIs by hand is a lot of work. PostgREST automatically generates an API out of your PostgreSQL database.

Stored procedures in PostgreSQL: getting started

by Hans-Jürgen Schönig | 02.2023
Learn all about stored procedures in PostgreSQL right here with examples created by a database expert. Includes syntax & tips

PostgreSQL: Finding the current timestamp

by Hans-Jürgen Schönig | 02.2023
How can I find the current timestamp in PostgreSQL? Read more about real time, statement time and transaction time.

Improving GROUP BY with CREATE STATISTICS

by Hans-Jürgen Schönig | 01.2023
For a PostgreSQL time series report - find out how CREATE STATISTICS can improve performance when you group on expressions

JSON logs in PostgreSQL 15

by Hans-Jürgen Schönig | 12.2022
Find out how JSON logs can be configured in PostgreSQL 15 and get all the advantages of this brand new feature

Oracle to PostgreSQL migration cost assessment made easy

by Hans-Jürgen Schönig | 12.2022
Migration cost assessment - Find out about conducting an assessment using the free Oracle-to-PostgreSQL migration tool, the CYBERTEC Migrator

Partition PostgreSQL: which partition did I INSERT my data into?

by Hans-Jürgen Schönig | 11.2022
When partitioning in PostgreSQL, it's not obvious how to find the location of data afterwards. Here's some great partition tips and tricks.

PostgreSQL ERROR: permission denied for schema public

by Hans-Jürgen Schönig | 11.2022
Public schema default permissions changed in PostgreSQL 15 - it might hurt you during application deployment. Here's what to do.
1 2 3 4 5 6 … 29
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2025
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram