PostgreSQL Tutorial: Integer Data Types
Summary: this tutorial introduces you to various PostgreSQL integer types including SMALLINT, INTEGER, and BIGINT.
PostgreSQL Tutorial: Interval Data Type
Summary: in this tutorial, you will learn about the PostgreSQL interval data type and how to manipulate interval values.
PostgreSQL Tutorial: JSON Data Type
Summary: in this tutorial, you will learn how to how to work with PostgreSQL JSON data type and some useful operators and functions for handling JSON data.
PostgreSQL Tutorial: NUMERIC Data Type
Summary: in this tutorial, you will learn about the PostgreSQL NUMERIC type for storing numeric data.
PostgreSQL Tutorial: TIME Data Type
Summary: in this tutorial, we will introduce you to the PostgreSQL TIME data types and show you some handy functions to handle time values.
PostgreSQL Tutorial: Timestamp Data Types
Summary: in this tutorial, you will learn about the PostgreSQL timestamp data types including timestamp and timestamptz. You will also learn how to use some handy functions to handle timestamp data more effectively.
PostgreSQL Tutorial: Using CAST To Convert a Value of One Type to Another
Summary: in this tutorial, we will show you how to use PostgreSQL CAST operator to convert a value of one type to another.
PostgreSQL Tutorial: Using SERIAL To Create Auto-increment Column
Summary: in this tutorial, you will learn about the PostgreSQL SERIAL pseudo-type and how to use the SERIAL pseudo-type to define auto-increment columns in tables.
PostgreSQL Tutorial: UUID Data Type
Summary: in this tutorial, you will learn about the PostgreSQL UUID data type and how to generate UUID values using a supplied module.
PostgreSQL Tutorial: Character Types: CHAR, VARCHAR, and TEXT
Summary: in this tutorial, you will learn about the PostgreSQL character data types including CHAR, VARCHAR, and TEXT, and learn how to select the right character types for your tables.