PostgreSQL

PostgreSQL tutorials with examples: install PostgreSQL, write SELECT queries and joins, work with dates, run VACUUM, back up data and use PL/pgSQL.

PostgreSQL DATE Functions Examples

by
PostgreSQL Date Functions Manipulation DATE_PART YEAR

In this PostgreSQL tutorial, we will learn about PostgreSQL DATE Functions Examples and know how to extract specific parts of the dates, manipulate the dates, perform arithmetic operations on dates, and convert dates or times to different time zone. PostgreSQL DATE Functions Examples Let us discuss various examples one by one in detail. Example 1: … Read more >>

Upper Bound of for Loop cannot be Null

by
Upper Bound of for Loop cannot be Null

Recently, I was working on a requirement that required me to execute a for loop in PostgreSQL. In this article, I will walk you through the solution to fix the error upper bound of for loop cannot be null. Upper Bound of for Loop cannot be Null I executed the below query. After executing the … Read more >>

PostgreSQL For Loop

by
flowchart of PostgreSQL for loop

In this comprehensive PostgreSQL tutorial, I’ll walk you through everything you need to know about PostgreSQL For loop, from basic concepts to advanced techniques that I’ve personally implemented in many applications. PostgreSQL For Loop PostgreSQL provides for loop statements to iterate over a range of integers or a result set in a sequence query. What is a … Read more >>

PostgreSQL TO_TIMESTAMP

by
PostgreSQL TO_TIMESTAMP format

In this PostgreSQL tutorial, we will discuss the PostgreSQL TO_TIMESTAMP() function, which converts a string into a timestamp type value based on a specified format, with 11 real-time examples. PostgreSQL TO_TIMESTAMP PostgreSQL provides several data type formatting functions, which serve as a comprehensive set of tools to convert various data type values (such as date-time/timestamp, integer, numeric, and floating-point) into formatted strings … Read more >>

How to connect PostgreSQL database

by
postgreSQL connect to database in rpm

In this comprehensive article, I’ll guide you through various approaches to connecting to a PostgreSQL database and share best practices I’ve gained experience with. How to connect PostgreSQL database Case 1: In Linux In this section, we’ll learn how to connect to the PostgreSQL database in the Linux RPM package. We’ll be discussing a terminal-based … Read more >>

How to find date difference in PostgreSQL

by
Postgresql date difference

In this PostgreSQL tutorial, I will teach you how to find the date difference in PostgreSQL. You will learn how to calculate the difference between two dates using the DATE_PART(), EXTRACT(), and AGE () functions. How to find date difference in PostgreSQL There is a function called DATEDIFF in other database software, such as Oracle and … Read more >>

Postgres Timestamp Comparison

by
Postgres Timestamp Comparison Using Greater Than Operator

In this PostgreSQL tutorial, I will show you the Postgres timestamp comparison to compare the timestamp values. Additionally, you will learn how to compare timestamps using different real-world examples with different operators and functions. Postgres Timestamp Comparison Timestamps in the PostgreSQL database represent the date and time. They play a vital role in database management when … Read more >>

How to write update query in PostgreSQL

by
How to write update query in PostgreSQL

In this PostgreSQL tutorial, I will demonstrate to you how to update a query in PostgreSQL. Additionally, you will learn how to update single or multiple rows simultaneously. Then I will show how to get updated or modified rows using the clause ((RETURNING *)). How to write update query in PostgreSQL To modify the records … Read more >>

PostgreSQL Length + 12 Examples

by
Postgresql length( )

As a database developer, I frequently utilize the LENGTH() function. This powerful yet simple function is essential for string manipulation and data validation in PostgreSQL databases. In this PostgreSQL tutorial, we will explore the use of PostgreSQL length functions, which will enable us to understand the application of all length-related functions. PostgreSQL Length The length() function in PostgreSQL is used … Read more >>

PostgreSQL If Else Statement

by
PostgreSQL If Else Statement

In this PostgreSQL tutorial, I will show how to use PostgreSQL If Else Statement to control the flow of the program. Also, I will introduce to you three variants of PostgreSQL: IF, IF ELSE, and IF ELSE with ELSEIF to handle one or multiple conditions. PostgreSQL If Else Statement Introduction to PostgreSQL If Else Statement PostgreSQL’s IF-ELSE statements are … Read more >>