Similar Topics

Web Technologies32.1K+ articles

DSA20.5K+ articles

Python19.6K+ articles

Experiences15.8K+ articles

Interview Experiences14.5K+ articles

School Learning11.1K+ articles

Databases1.9K+ articles

PostgreSQL386+ articles

postgreSQL-managing-table38+ articles

postgreSQL35+ articles

postgreSQL-dataTypes

24 posts

PostgreSQL - Constants

Last Updated: 01 August 2026

Constants in PostgreSQL are fixed values that cannot be changed after they are declared. They help make code more readable, reduce repeated hard-coded values, and simplify...read more

article_image

postgreSQL-dataTypes

PostgreSQL - Copying Data Types

Last Updated: 15 July 2025

When working with PostgreSQL, you can define a variable that directly references the data type of a column in a table or the data type of another variable. This feature is...read more

postgreSQL-dataTypes

PostgreSQL - CAST

Last Updated: 28 July 2026

The CAST operator in PostgreSQL is used to convert a value from one data type to another. It helps perform operations on compatible data types and improves the readability...read more

article_image

postgreSQL-dataTypes

PostgreSQL - Change Column Type

Last Updated: 15 July 2025

Changing the column type in PostgreSQL is good for adapting to increase the data needs. Using the ALTER TABLE statement, we can modify the structure of existing tables eas...read more

postgreSQL-dataTypes

postgreSQL-managing-table

PostgreSQL - JSON Data Type

Last Updated: 15 July 2025

JSON (JavaScript Object Notation) is a widely used format for storing data in the form of key-value pairs. Its popularity comes from being easy for humans to read and unde...read more

article_image

postgreSQL-dataTypes

PostgreSQL - hstore Data Type

Last Updated: 12 August 2024

The 'hstore' module in PostgreSQL is designed to implement a data type for storing key-value pairs within a single value. This feature is particularly useful for handling ...read more

article_image

postgreSQL-dataTypes

PostgreSQL - Array Data Type

Last Updated: 15 July 2025

PostgreSQL provides an advanced and flexible feature known as the Array Data Type, which allows us to store multiple values in a single column. Arrays in PostgreSQL can be...read more

article_image

postgreSQL-dataTypes

PostgreSQL - CREATE DOMAIN

Last Updated: 15 July 2025

PostgreSQL supports the creation of user-defined data types through the CREATE DOMAIN and CREATE TYPE statements. These capabilities allow for the customization and extens...read more

article_image

postgreSQL-dataTypes

PostgreSQL - Interval Data Type

Last Updated: 15 July 2025

The interval data type in PostgreSQL stores time periods using 16 bytes of storage and supports a range from -178,000,000 years to 178,000,000 years. It provides a precisi...read more

article_image

postgreSQL-dataTypes

PostgreSQL - TIME Data Type

Last Updated: 15 July 2025

In PostgreSQL, the TIME data type is essential for applications that require precise time tracking, such as scheduling systems and event logging. This data type allows for...read more

article_image

postgreSQL-dataTypes

PostgreSQL - UUID Data Type

Last Updated: 15 July 2025

TheUUID (Universally Unique Identifier)is a 128-bit identifier defined byRFC 4122. It generates globally unique values using algorithms that ensure no duplication, making ...read more

article_image

postgreSQL-dataTypes

PostgreSQL - Timestamp Data Type

Last Updated: 15 July 2025

PostgreSQL supports two primary temporal data types to store date and time: TIMESTAMP (without timezone) and TIMESTAMPTZ (with timezone). Understanding these data types is...read more

article_image

postgreSQL-dataTypes

PostgreSQL - Date Data Type

Last Updated: 15 July 2025

PostgreSQL offers powerful DATE data type and date functions to efficiently handle date and time information. PostgreSQL DATE data type allows for storing and manipulating...read more

postgreSQL-dataTypes

PostgreSQL - SERIAL

Last Updated: 15 July 2025

When working with PostgreSQL, we need to create tables with unique primary keys. PostgreSQL offers a powerful feature known as the SERIAL pseudo-type which simplifies gene...read more

postgreSQL-dataTypes

PostgreSQL - BIGINT Integer Data Type

Last Updated: 15 July 2025

PostgreSQL is a powerful open-source relational database management system that offers various integer data types to suit different needs. One of these is the BIGINT data ...read more

article_image

postgreSQL-dataTypes

1 2