How to Check the PostgreSQL Version
Checking your PostgreSQL database version is a simple process, but there are several ways to obtain that information. If you
Read moreTips
How to reset the pg_stat statistics tables.
There is a group of PostgreSQL views that allow you to view various statistics on the database. Some of the
Read more
Common SQL mistakes and how to avoid them.
In addition to DBAs and data engineers, SQL is used by analysts, data scientists, product managers, programmers, and designers. There
Read more
How do I change column default value in PostgreSQL
Once a table is created you can alter its configuration and set default values for a column. When altering a
Read more
Extract the domain name from a string
Have you ever needed to extract the domain name from a string using PostgreSQL? There are various methods to accomplish
Read more
Create a table like another table
Quick Tip: Want to create a table just like another table (without data). It’s simple to do with this command:
Read more