Extract Day From Timestamp in PostgreSQL
PostgreSQL provides a timestamp datatype to store date and time information in a database. For some requirements, we need to extract only the day portion …
A 5-Minute Guide to Auto-Increment Primary Key in PostgreSQL
In PostgreSQL, each row in a table is uniquely identified by its primary key. The values in the column are verified to be unique and …
Effective way to use COALESCE in PostgreSQL
The COALESCE in PostgreSQL returns the first non-null argument value. PostgreSQL provides various functions to handle NULL-value scenarios. The coalesce function in PostgreSQL is one …
2 Easy ways to handle the ISNULL function in PostgreSQL
SELECT queries are frequently used by developers to retrieve the necessary data from PostgreSQL databases. There is a chance that some of the columns’ data …
SELECT first row in each group in PostgreSQL
PostgreSQL provides some powerful grouping functions for complex datasets. Finding the first row in each group based on an order by clause is a common …
An easy way to describe table in psql
One of the core tasks in PostgreSQL is to examine the structure of the table. We frequently look at the structure of the table to …
Mastering SUBSTRING Function in PostgreSQL
PostgreSQL offers a powerful substring function for manipulating strings. You can extract a section of a string based on predefined criteria by using the substring …
5-Minute Guide to Delete a column in PostgreSQL
Some administrative tasks in PostgreSQL databases are a necessary part of a software developer’s daily work. In a PostgreSQL database, deleting a column is a …
Learn 2 easy ways to PostgreSQL list databases
There are several meta commands in PostgreSQL that can be used to list databases. These commands are helpful for list databases and also retrieving other …
Proper way to ADD COLUMN in PostgreSQL
The majority of the time, software needs to be changed, requiring us to later add a column to an existing table through modification. In the …