Category: Types

In this section, we are going to understand the working of the PostgreSQL Bigint data type. And we also see examples of the bigint data type. What is PostgreSQL Bigint Data Type? In PostgreSQL, the next integer data type that we are going to understand is BIGINT. The BIGINT data types are large-range integers, which involve 8 bytes of storage size and store…

In this section, we are going to understand the working of the PostgreSQL Smallint data type. And we also see examples of the Smallint data type. What is PostgreSQL Smallint Data Type? In PostgreSQL, the next integer data type that we are going to understand is SMALLINT. The SMALLINT data type small range integer involves 2 bytes of storage size and store…

In this section, we are going to understand the working of the PostgreSQL Integer data type. And we also see examples of the Integer data type. What is PostgreSQL Integer Data Type? In PostgreSQL, the INTEGER data type is also known as INT. The PostgreSQL Integer data type has been classified into three types which are as follows: In this section,…

In this section, we are going to understand the working of PostgreSQL Boolean data types, which allows us to design the database tables. And we also see examples of the Boolean data type. What is PostgreSQL Boolean Data Type? A Boolean is a commonly used data type in PostgreSQL, which always to return two probable values, such as TRUE and FALSE. The…

In this section, we are going to understand the working of PostgreSQL varchar data types, which allows us to store the character of unlimited length. And we also see examples of the Varchar data type and spaces. What is PostgreSQL Varchar datatype? In PostgreSQL, the Varchar data type is used to keep the character of infinite length. And it can hold…

In this section, we are going to understand the working of PostgreSQL Text data types, which allows us to store the character of unlimited length. And we also see examples of the text data type. What is PostgreSQL Text datatype? In PostgreSQL, the text data type is used to keep the character of infinite length. And the text data type…

In this section, we are going to understand the working of PostgreSQL Character data types, which allows us to select the right character types for our tables. And we also see examples of the character data type. What is PostgreSQL Character Data Type? In PostgreSQL, the character data represent the character type values and also known as CHAR. In other words, we…

In this section, we are going to understand the working of PostgreSQL Numeric data types, which allows us to store the numeric data. And we also see examples of Numeric data type. What is PostgreSQL NUMERIC Data Type? In PostgreSQL, the Numeric data type is used to store the numbers with various significant numbers of digits. In other words, we can say that the…

A data type specifies what kind of data you want to store in the table field. While creating a table, for each column, you have to use a datatype. It identifies a particular type of data, like integer, Boolean, floating points, and so on. In this section, we are going to discuss the various data…