Preamble
Below is a list of data types available in PostgreSQL, which includes string, numeric, and date/time type.
String data types
Below are String data types in PostgreSQL :
|
Syntax of data types
|
Explanation
|
|---|---|
|
char (size)
|
Where size is the number of characters to store. A string of fixed lengths. Space is added to the right to the size of the characters.
|
|
character (size)
|
Where size is the number of characters to store. A string of fixed lengths. Space is added to the right to the size of the characters.
|
|
var symbol (size)
|
Where size is the number of characters to store. A string of variable lengths.
|
|
character varying(size)
|
Where size is the number of characters to store. A string of variable lengths.
|
|
text
|
The string of variable length.
|
Numerical data types
Below are the numeric data types in PostgreSQL:
|
Syntax of data types
|
Explanation
|
|---|---|
|
bit(size)
|
Bit string of fixed length,
where size is the length of a string of bits. |
|
varbit(size) bit varying(size)
|
Bit string of variable length,
where size is the length of a string of bits. |
|
smallint
|
Equivalent to int2.
2-byte integer with a sign. |
|
int
|
Equivalent to int4.
4-byte integer with a sign. |
|
integer
|
Equivalent to int4.
4-byte integer with a sign. |
|
bigint
|
A large integer value, equivalent to int8.
An 8-byte integer with a sign. |
|
smallserial
|
A small integer value with auto-increment equivalent to serial2.
2-byte integer with a sign, autoincrement. |
|
serial
|
Auto-incremental integer value, equivalent to serial4.
4-byte integer with a sign, auto-incremental. |
|
bigserial
|
Large auto-incremental integer value equivalent to serial8.
8-byte integer with a sign, auto-incremental. |
|
numeric(m,d)
|
Where m is the total number of digits, and d is the number after the decimal fraction.
|
|
double precision
|
8 bytes, double-precision, floating-point number.
|
|
real
|
4-byte floating-point single-precision number.
|
|
money
|
Cost of currency.
|
|
bool
|
Logical logical data type – true or false.
|
|
boolean
|
Logical logical data type – true or false.
|
Date/Time Types of data
Below is the date/time of the data types in PostgreSQL:
|
Syntax of data types
|
Explanation
|
|---|---|
|
date
|
Displayed as “YYYY-MM-DD”.
|
|
timestamp
|
Displayed as «YYYY-MM-DD HH:MM:SS».
|
|
timestamp without time zone
|
Displayed as «YYYY-MM-DD HH:MM:SS».
|
|
timestamp with time zone
|
Displayed as «YYYY-MM-DD HH:MM:SS-TZ».
Equivalent to the timestamptz. |
|
time
|
Displayed as «HH:MM:SS» without a time zone.
|
|
time without time zone
|
Displayed as «HH:MM:SS» without a time zone.
|
|
time with time zone
|
Displayed as «HH:MM:SS-TZ» with the time zone.
Equivalent to the time zone. |
Understanding Advanced Datatypes in PostgreSQL
About Enteros
Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
Why BFSI Leaders Are Turning to Enteros for Database Optimization, AI Ops, and Cloud FinOps Excellence
- 16 April 2026
- Database Performance Management
Introduction The Banking, Financial Services, and Insurance (BFSI) sector is undergoing a massive digital transformation. With the rise of digital banking, real-time payments, fraud detection systems, and AI-driven financial services, organizations are becoming increasingly dependent on high-performance data infrastructure. From managing millions of transactions per second to enabling real-time risk analysis and personalized customer experiences, … Continue reading “Why BFSI Leaders Are Turning to Enteros for Database Optimization, AI Ops, and Cloud FinOps Excellence”
How to Optimize Telecom Sector Growth with Enteros AIOps Platform, Resource Metadata, Hierarchy Metadata, Spot Instances, and RevOps Efficiency
Introduction The telecom sector is at the center of global digital transformation, enabling connectivity for billions of users, businesses, and emerging technologies like IoT, 5G, and edge computing. As demand for high-speed, reliable communication services continues to rise, telecom providers are under immense pressure to scale operations efficiently while maintaining performance and controlling costs. However, … Continue reading “How to Optimize Telecom Sector Growth with Enteros AIOps Platform, Resource Metadata, Hierarchy Metadata, Spot Instances, and RevOps Efficiency”
Who Should Adopt Enteros for Retail Growth Management with AI SQL and Cloud FinOps Efficiency
Introduction The retail sector is evolving at an unprecedented pace, driven by digital transformation, omnichannel experiences, and data-driven decision-making. From global eCommerce giants to mid-sized retail chains, businesses are increasingly relying on cloud infrastructure, databases, and analytics platforms to fuel growth. However, this rapid expansion introduces a fundamental challenge:how to scale efficiently while maintaining performance, … Continue reading “Who Should Adopt Enteros for Retail Growth Management with AI SQL and Cloud FinOps Efficiency”
How to Optimize Technology Sector Growth with Enteros Database Management Platform, Cloud FinOps, and RevOps Efficiency
Introduction The technology sector is at the forefront of innovation, powering digital transformation across industries. From SaaS platforms and cloud-native applications to AI-driven solutions, technology companies are scaling rapidly to meet growing global demand. However, this rapid expansion introduces a critical challenge:how to sustain growth while maintaining high-performance systems, controlling cloud costs, and aligning operations … Continue reading “How to Optimize Technology Sector Growth with Enteros Database Management Platform, Cloud FinOps, and RevOps Efficiency”