In this tutorial, we will learn how can we rename the table using the RENAME command. We have to use the RENAME keyword with the ALTER TABLE statement to make it work. So, let’s see how it is done! PostgreSQL RENAME Table Statement First of all, the RENAME keyword cannot be used standalone to rename …
Renaming Tables in PostgreSQL: A Step-by-Step Guide Read More »
In this tutorial, we will be learning to add single or multiple columns in PostgreSQL. This is going to be a very simple tutorial where we will use the ALTER TABLE statement with the ADD COLUMN statement. So, let’s get started! ADD COLUMN Statement in PostgreSQL In PostgreSQL, the ADD COLUMN statement is used with …
In this tutorial, we will be learning about one of the coolest features of PostgreSQL which is UPDATE join. When you want to update the value of a certain table based on a value in another table, you use the UPDATE join. This is a very interesting topic, so let’s get started without wasting time! …
PostgreSQL UPDATE Join: Introduction, Syntax & Example Read More »
In some cases, you want to modify the table structure but not the table data. In this case, you use the ALTER TABLE command. In this tutorial, we will go through all the important key points of the ALTER TABLE statement. So, let’s get started! Also Read: PostgreSQL – A Complete Introduction, History, and Features …
In this tutorial, we will learn about the INSERT ON CONFLICT statement which is used to perform the upsert operation. If you don’t know what is the upsert operation, don’t worry, we will cover everything in this tutorial. So without further wasting time, let’s get started! Also Read: PostgreSQL – A Complete Introduction, History, and …
Upsert Operation in PostgreSQL using INSERT ON CONFLICT Read More »
In this tutorial, we will learn about the DELETE statement in PostgreSQL with examples. The delete statement is used to delete the table records. Let’s see the DELETE statement in depth. Also Read: PostgreSQL – A Complete Introduction, History, and Features Introduction to DELETE in PostgreSQL The DELETE statement in SQL is used to delete …
PostgreSQL DELETE Statement: Removing Rows from Table Read More »
SQL is used to manage data in relational databases. While it is most commonly associated with querying databases, SQL offers much more through its versatile functions that enable efficient data analysis and manipulation. A significant amount of raw data is in text form, so having versatile methods for manipulating strings is very important. Raw data is …
5 SQL Functions for String Manipulation (With Examples) Read More »
Sometimes you need to display a different name for the column of a table than the original one. In this case, you can use the alias for that column. In this tutorial, we will learn how we can use the column aliases in PostgreSQL. So, let’s get started! Introduction to Column Alias in PostgreSQL A …
The UPDATE statement is used to update or modify the existing data in the table on a certain condition. In this tutorial, we will be learning the UPDATE statement in PostgreSQL with some other important points related to it. So, let’s get started! Introduction to UPDATE Statement in PostgreSQL The UPDATE statement can be used …
PostgreSQL UPDATE: Introduction, Syntax & Examples Read More »
There is a probability that you would need to fetch only unique rows from the table. That is where the DISTINCT clause comes into action. In this tutorial, we will learn how can we use the PostgreSQL DISTINCT clause in multiple ways to fetch unique records. So, let’s get started! Also Read: How to Create …
PostgreSQL SELECT DISTINCT Clause: Introduction, Syntax & Examples Read More »