PostgreSQL Tutorial: Data Types
Summary: in this tutorial, you will learn about PostgreSQL data types including Boolean, character, numeric, temporal, array, json, uuid, and special types.
PostgreSQL Tutorial: Basics of JSON
Summary: in this tutorial, you will learn how to how to work with PostgreSQL JSONB data type and some useful operators and functions for handling JSONB data.
PostgreSQL Tutorial: REAL Data Type
Summary: In this tutorial, you will learn how to use the PostgreSQL REAL data type to store single-precision floating-point numbers in the database.
PostgreSQL Tutorial: DOUBLE PRECISION Data Type
Summary: In this tutorial, you will learn about the PostgreSQL DOUBLE PRECISION data type and its features.
PostgreSQL Tutorial: BYTEA Data Type
Summary: In this tutorial, you will learn about PostgreSQL BYTEA data type and how to use it to store binary strings in the database.
PostgreSQL Tutorial: User-defined Data Types
Summary: in this tutorial, you will learn how to create PostgreSQL user-defined data type using CREATE DOMAIN and CREATE TYPE statements.
PostgreSQL Tutorial: Array Data Type
Summary: in this tutorial, we will show you how to work with PostgreSQL array and introduce you to some handy functions for array manipulation.
PostgreSQL Tutorial: Boolean Data Type
Summary: in this tutorial, you will learn about the PostgreSQL Boolean data type and how to use it in designing the database tables.
PostgreSQL Tutorial: Date Data Type
Summary: this tutorial discusses PostgreSQL DATE data type and shows you how to use some handy date functions to handle dates values.
PostgreSQL Tutorial: hstore Data Type
Summary: in this tutorial, you’ll learn how to work with PostgreSQL hstore data type.