Add a primary key to an existing table
Recently we started to move some old legacy databases from our data center to AWS….
How to Check the PostgreSQL Version
Checking your PostgreSQL database version is a simple process, but there are several ways to…
How to reset the pg_stat statistics tables.
There is a group of PostgreSQL views that allow you to view various statistics on…
Sleeping with Postgres
Do you want to sleep with PostgreSQL or maybe just have your session sleep for…
Common SQL mistakes and how to avoid them.
In addition to DBAs and data engineers, SQL is used by analysts, data scientists, product…
How do I change column default value in PostgreSQL
Once a table is created you can alter its configuration and set default values for…