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 »
In this tutorial, we will learn about the SELECT statement in PostgreSQL to fetch the data from the table. The SELECT statement is straightforward and doesn’t have complex terminologies. So without further ado, let’s get started! Also Read: How to Create a Database in PostgreSQL Introduction to PostgreSQL SELECT Statement Fetching the data from the …
PostgreSQL SELECT Statement: Introduction, Explanation & Examples Read More »
In this tutorial, we will learn to insert a single row as well as multiple rows using the INSERT statement in PostgreSQL. It is very similar to other database systems. So, let’s get started! Also Read: How to Create a Database? PostgreSQL INSERT Statement The INSERT statement is one of the DML commands in DBMS. …
PostgreSQL INSERT Statement: Inserting Rows into a Table Read More »
Creating a table is a basic functionality in any database after creating a database. In this tutorial, we will learn to create a table in PostgreSQL with multiple points related to it. So, let’s get started! Also Read: How to Create a Database in PostgreSQL Introduction to PostgreSQL CREATE TABLE There are a few things …
PostgreSQL CREATE TABLE – How to Create a Table in PostgreSQL? Read More »
In this tutorial, we will learn about the UUID data type in PostgreSQL. It is one of the easiest and most useful data types while developing any application. So, read the tutorial carefully and try it yourself. Now without further ado, let’s get started! Also Read: PostgreSQL – Data Types What is UUID Type in …
As I always say, PostgreSQL is one of the best database systems out there in the world because of the features it provides. In this tutorial, we will see one of the most incredible features of PostgreSQL: hstore datatype. Let’s see what is it and how it can be used. Also Read: PostgreSQL – Data …
PostgreSQL hstore Data Type: In-Depth Explanation Read More »
In this tutorial, we will learn about the JSON type in PostgreSQL, how it works and how to use it in real life using multiple examples. So, let’s get started! Also Read: PostgreSQL – Data Types Introduction to JSON Type in PostgreSQL JSON term is pretty common in the programming world as it is available …
One of the best features of PostgreSQL is the array datatype. You can create and store an array of any datatype in PostgreSQL without doing any workaround. In this tutorial, we will learn everything about the PostgreSQL array with examples. So, let’s get started! Introduction to PostgreSQL Array In PostgreSQL, you can create a multi-dimensional …