RajKishore

Rajkishore Sahoo is a Microsoft Azure consultant with more than 14 years of hands-on experience building cloud-native data solutions across Azure and AWS, focused on Azure SQL Database, Azure SQL Managed Instance, and the pipelines that connect them to production apps. Day to day, he provisions Azure SQL instances, configures firewalls and connection strings, tunes queries for cloud workloads, and wires databases into Azure Functions and Logic Apps. Read more

How to remove special characters in PostgreSQL

by
Simple Example Replace Special Characters in Postgres Translate()

In this PostgreSQL tutorial, I’ll walk you through multiple proven methods to effectively remove special characters in PostgreSQL using the REPLACE() and REGEXP_REPLACE() functions. Additionally, you will learn to use the TRANSLATE() function, which can be used in conjunction with these two functions to replace special characters with new string values. How to remove special characters in PostgreSQL Sometimes your database contains a … Read more >>

PostgreSQL change column data type

by
postgresql change column data type from integer to var

In this PostgreSQL tutorial, we will learn how to change column type in PostgreSQL from one data type to another. PostgreSQL change column data type Suppose you are an employee of XYZ company in the USA, and in front of you is a situation to change the data type of a column of a database. So, … Read more >>

How to set user password in PostgreSQL

by
How to Set PostgreSQL User Password using Configuration File

Whether you’re setting up a new database user, resetting a forgotten password, or implementing stronger security policies, understanding how to manage PostgreSQL passwords effectively is crucial for database administrators and developers. In this PostgreSQL tutorial, I will show the steps on how to set the PostgreSQL user password. How to set user password in PostgreSQL In … Read more >>

PostgreSQL Date Add

by
Postgresql date add

In this PostgreSQL tutorial, we will learn about “PostgreSQL date add,” which means we will add the month, year, and hours to the current date with multiple examples. PostgreSQL date add Before beginning, we need to know that PostgreSQL does not have the DATEADD( ) function like other databases such as SQL, MYSQL, etc. But we can achieve the same result using … Read more >>

PostgreSQL date between two dates

by
Postgresql date between two dates

In this PostgreSQL tutorial, I’ll guide you through multiple approaches to filtering data between two dates in PostgreSQL, complete with practical examples and performance considerations. PostgreSQL date between two dates Why Date Range Filtering Matters in PostgreSQL Before diving into the syntax, let’s understand why effective date filtering is crucial: Now, let’s explore the various … Read more >>

PostgreSQL To_Char Date Format

by
Using PostgreSQL To_Char to Format Date in Table

In this PostgreSQL tutorial, I will demonstrate how to utilize PostgreSQL’s TO_CHAR format date, enabling you to understand how to use the TO_CHAR() function to format dates in a meaningful way. You will learn practical examples where I will show you how to use TO_CHAR() on a column of type date in the table, and also how to use the TO_CHAR() function with … Read more >>

PostgreSQL list users

by
postgresql list users using sql statement

I’ve found that understanding how to list and manage users is fundamental to maintaining secure and efficient database environments. In this PostgreSQL tutorial, we will learn about listing users in PostgreSQL. PostgreSQL list users In this section, we will explore the use of the PostgreSQL list user command to display all users in a PostgreSQL database … Read more >>

Postgresql listen_addresses

by
Postgresql listen_addresses example

In this PostgreSQL tutorial, we will learn about “PostgreSQL listen_addresses” and how to connect to PostgreSQL from any IP address across different environments, using various examples. Postgresql listen_addresses Before beginning, we need to know “What is listen_address?” listen_addresses is found in the section of the PostgreSQL.conf file. It enables the database server to listen for incoming connections on the specified IP … Read more >>

PostgreSQL To_Number

by
How to use PostgreSQL To_Number for Thousand Separator

The TO_NUMBER() Function stands out as a handy tool when working with string representations of numeric values. In this PostgreSQL tutorial, I will teach you how to use the PostgreSQL To_Number function with multiple examples. PostgreSQL To_Number The to_number() function of PostgreSQL converts the given string into a number or numeric value. This function takes … Read more >>

PostgreSQL Loop

by
Postgresql current_timestamp

Recently, as a PostgreSQL developer, I got many requirements to use the PostgreSQL Loop in multiple real time scenarios. In this PostgreSQL tutorial, we will learn about the “Postgresql loop” for inserting records or accessing an array using a loop with multiple examples. PostgreSQL Loop In PostgreSQL, we can use a loop to perform the … Read more >>