data type

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.

Continue reading

PostgreSQL Tutorial: DOUBLE PRECISION Data Type

Summary: In this tutorial, you will learn about the PostgreSQL DOUBLE PRECISION data type and its features.

Continue reading

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.

Continue reading

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.

Continue reading

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.

Continue reading

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.

Continue reading

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.

Continue reading

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.

Continue reading

PostgreSQL Tutorial: hstore Data Type

Summary: in this tutorial, you’ll learn how to work with PostgreSQL hstore data type.

Continue reading

PostgreSQL Tutorial: Integer Data Types

Summary: this tutorial introduces you to various PostgreSQL integer types including SMALLINT, INTEGER, and BIGINT.

Continue reading