Kumar Saurabh

In this PostgreSQL tutorial, we will learn about “PostgreSQL cast int” using different data types or functions and casting or converting from int to another data type, such as boolean, float, timestamp, etc. PostgreSQL Cast Int When data is stored in a PostgreSQL database, we want to convert the data type of a value or column in the table into … Read more >>

In this PostgreSQL tutorial, I will show you how to format numbers in PostgreSQL, where you will understand different functions provided by PostgreSQL such as to_char, round() and etc. Additionally, you will understand how to use lpad() function with the numeric value, and use the to_char() function to format the numeric value with the currency … Read more >>

Mastering inner joins is essential for anyone working with relational databases. In this comprehensive article, I’ll share my expertise on implementing multiple inner joins in PostgreSQL. PostgreSQL Multiple Inner Joins Now, we will understand how multiple inner joins are implemented in Postgresql using the psql tool. In PostgreSQL, the INNER JOIN will select all rows from both … Read more >>

A multiple join is a query that contains similar or different join types that are used more than once. In this comprehensive article, I’ll walk you through everything you need about using multiple joins in PostgreSQL – from basic concepts to advanced approaches. PostgreSQL multiple joins Using multiple joins in PostgreSQL, we can combine various … Read more >>

In this PostgreSQL tutorial, we will learn about PostgreSQL Joins. Here we will learn how to use joins in PostgreSQL and PostgreSQL Joins Types. PostgreSQL Joins PostgreSQL joins are used to merge columns from one (self-join) or more tables based on the values of the common columns between related tables. The standard columns are generally the … Read more >>

In this PostgreSQL tutorial, I show you how to use PostgreSQL current_timestamp to get the current timestamp of the system. Also, I will show you the way to control the format and convert the timestamp value returned by the CURRENT_TIMESTAMP to the UTC time zone. PostgreSQL current_timestamp PostgreSQL has the function current_timestamp to get time … Read more >>

In this PostgreSQL tutorial, I will show you how to use the PostgreSQL Average Count to compute the average value of the given set of values or columns. You will learn how to use the AVG() function with the HAVING, GROUP BY clause, and the DISTINCT operator. Additionally, you will understand how to deal with null values while computing the … Read more >>

In this PostgreSQL tutorial, I will show you how to rename column in PostgreSQL, where you will understand how to check the column’s existence in the table before renaming the column. How to Rename Column in PostgreSQL Sometimes, as business requirements change, you also need to rename the columns, and there can be different reasons … Read more >>

In this PostgreSQL tutorial, I will teach you how to use the Postgres Rank Function to assign a rank value to rows of the tables in a specific order with multiple examples. PostgreSQL RANK Function The RANK() function in PostgreSQL is a window function that assigns a number, known as a rank, to each row of the result set … Read more >>

Recently, I was required to export data to CSV format in PostgreSQL. In this tutorial, you will learn how to use Postgres Export to CSV. Basically, in this tutorial, you will gain the knowledge of exporting the PostgreSQL table data to the CSV file. Postgres Export to CSV Suppose you have a database with multiple … Read more >>