Skip to content

Tag Archives: postgreSQL-dataTypes

Unlike variables, the value of constants cannot be changed once initialized. The main purpose of the use of constants in PostgreSQL are: It makes the… Read More
PostgreSQL enables you to define a variable with a data type that references to the data type of a column of a table or the… Read More
PostgreSQL supports a CAST operator that is used to convert a value of one type to another. Syntax: CAST ( expression AS target_type ); Let’s… Read More
In this article, we will discuss the step by step process of changing the data type of a column using the ALTER TABLE statement in… Read More
In this article, we will look into the various data types available in PostgreSQL. The following data types are supported by PostgreSQL:  Boolean Character Types… Read More
In this article, we will look into the PostgreSQL Boolean data type and it’s implementation while designing a database table. PostgreSQL boolean data type has… Read More
JSON stands for JavaScript Object Notation. It is used to store data in the form of key-value pairs and is generally used for communicating between… Read More
The hstore module is used to implement the hstore data type in the form of key-value pairs for a single value within PostgreSQL. The hstore… Read More
PostgreSQL Supports the concept of Arrays. All data type has a companion array associated with it irrespective of the properties of the the data type.It… Read More
PostgreSQL supports the creation of user-defined data types using the following statements: CREATE DOMAIN:It creates a user-defined data type that can have optional constraints. CREATE… Read More
In PostgreSQL 2 temporal data types namely timestamp and timestamptz where one is without timezone and the later is with timezone respectively, are supported to… Read More
PostgreSQL supports a DATE data type to store date values. It takes 4 bytes of storage and ranges from 4713 BC to 5874897 AD. PostgreSQL… Read More
PostgreSQL has a special kind of database object generator called SERIAL. It is used to generate a sequence of integers which are often used as… Read More
In PostgreSQL the interval data type is used to store and manipulate a time period. It holds 16 bytes of space and ranging from -178,… Read More
PostgreSQL provides user with TIME data type that is used to handle time values. It requires 8 bytes of storage and can have precision up… Read More