In this tutorial, we will be learning about the DROP TABLE statement in PostgreSQL which is used to remove the existing table from the database. Apart from just deleting the table, we will learn some additional things as well. So, let’s get started! PostgreSQL DROP TABLE Statement The DROP TABLE is a DDL command which …
PostgreSQL DROP TABLE: Deleting Tables from Database Read More »
In this tutorial, we will learn to create a sequence in PostgreSQL. This topic might seem a little bit confusing but trust me, it is as simple as creating a table. So, without getting distracted from the topic, let’s dive straight into it. Introduction to PostgreSQL Sequence A sequence is simply an object that generates …
PostgreSQL CREATE SEQUENCE: Introduction, Syntax & Examples Read More »
In this tutorial, we will learn how we can change or modify the column data type or change the size of the data type in PostgreSQL. Along with the syntax and examples, we will learn the pros and cons of it. So, let’s get started! Introduction Creating a database and tables is the backbone of …
In this tutorial, we will learn to delete a column from the table using the ALTER TABLE statement with the DROP COLUMN keyword. We can remove one or more columns using this statement. So, let’s see how is it done! Introduction to PostgreSQL DROP COLUMN In PostgreSQL, the DROP COLUMN clause is used with the …
PostgreSQL DROP COLUMN: Remove Columns From Table Read More »
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 »