RajKishore 
In this PostgreSQL tutorial, we will learn about the PostgreSQL date_trunc function, which extracts specific parts of the date and time, such as seconds, minutes, hours, days, months, and years. Postgresql date_trunc function In PostgreSQL, the date_trunc function is used to extract and truncate the specific date part (level of precision) of the date and time, such as seconds, minutes, … Read more >>
In this PostgreSQL tutorial, I will show you how to use row_number in PostgreSQL to assign a unique sequential integer as a rank to each row. I will also tell you the importance of the Row_number() function with syntax and examples. Additionally, you will understand how to implement Row_number() for ranking and pagination with an … Read more >>
In this PostgreSQL tutorial, I will show you how to use the Postgres Min Function with SELECT, GROUP BY, and HAVING clauses. You will also understand how to use the min() function with a subquery and multiple columns. Postgres Min Function PostgreSQL’s MIN() function finds the minimum value from the set of values. It is an aggregate function that … Read more >>
In this PostgreSQL tutorial, I will show you how to create a view in Postgres. You will learn “what is the view?” and the syntax for creating the view and its execution process. How to Create View in PostgreSQL Before diving deep into the topic, let me understand what views are. What Are PostgreSQL Views? … Read more >>
As a Project Manager, I was confused about which relational database management system to choose for my upcoming project, PostgreSQL or SQL Server. Both are powerful enough in their feature, but both serve different purposes. Still, I have to consider my project’s cost and technical requirements. Here, I have shared a detailed comparison of PostgreSQL … Read more >>
In this PostgreSQL tutorial, I will show you how to escape a single quote in PostgreSQL. You will also understand the three different methods, such as double quotes, dollar quoted string, and backslash, to escape the single quote. How to Escape Single Quote in PostgreSQL Sometimes, you must insert data into the database containing a single quote within the … Read more >>
In this comprehensive article, I’ll explain everything you need to know about converting a date string into PostgreSQL’s timestamp data type. PostgreSQL date string to timestamp Let’s explore the various methods to convert your string dates into proper timestamps. Approach 1: Using TO_TIMESTAMP() Function The most common and flexible approach is using PostgreSQL’s built-in TO_TIMESTAMP() … Read more >>
In this comprehensive article, I’ll explain the various methods for converting PostgreSQL date values to formatted strings with practical examples. By the end, you’ll have a clear picture of this. PostgreSQL date to string Let us discuss all the approaches individually. Approach-1 Using the CAST function In PostgreSQL, dates are converted into strings using the … Read more >>
In this PostgreSQL tutorial, I will show you how to compute the total sum of columns in PostgreSQL. You will also understand the function SUM(), which computes the sum of all the values in a column. I will also explain the syntax of the SUM() function and how to use it. Finally, you will implement the … Read more >>
As a developer working on PostgreSQL, I have many requirements to work with the ALTER TABLE command. In this PostgreSQL tutorial, we will discuss PostgreSQL ALTER TABLE to make changes to the properties of the table, such as removing columns from the table, renaming columns, etc. PostgreSQL ALTER TABLE The ALTER TABLE command in PostgreSQL … Read more >>