Data Types & JSONB

9 pages in this section.

How PostgreSQL's type system shapes storage, indexing, and casting, and when to reach for jsonb, arrays, enums, or domains instead of a strictly normalized column.

Explainer Sql Data Types Jsonb Jsonb

Data Types Basics

Learn to choose PostgreSQL data types for IDs, counts, text, booleans, and money. Understand performance, storage, and indexing implications.

Sql Data Types Jsonb Basics Types

Numeric & Text Types

Compare PostgreSQL numeric and float types, text and varchar, and collation basics. Learn practical patterns for production SQL queries.

Sql Data Types Jsonb Numeric And Text Types

Date, Time & Timestamptz

Learn to manage date, time, and timestamptz data types in PostgreSQL. Understand timezone pitfalls and use practical SQL patterns for production queries.

Sql Data Types Jsonb Date Time And Timestamptz

UUID, Enum & Domain Types

Learn to use UUIDs, Enums, and Domain Types in PostgreSQL. Understand when to use Enums versus lookup tables for efficient queries.

Sql Data Types Jsonb Uuid Enum And Domain Types

Arrays & Composite Types

Learn to use PostgreSQL arrays and composite types for efficient data handling. Discover practical SQL patterns, working examples, and common pitfalls to avoid.

Sql Data Types Jsonb Arrays And Composite Types

JSONB Operators & Indexing

Sql Data Types Jsonb Jsonb Operators And Indexing

Data Types Best Practices

Learn best practices for choosing SQL data types, including numeric for money, timestamptz for events, and JSONB for optional facets.

Sql Data Types Jsonb Best Practices List

Data Types & JSONB Highlights Summary

A single-page roundup of every highlight bullet from the 8 pages in the Data Types & JSONB section, grouped by source page so you can scan all 46 takeaways without opening each article individually.

Highlights Summary Data Types Jsonb

Data Types & JSONB

Search Documentation

Data Types & JSONB