PostgreSQL Tutorial: Index Types
Summary: In this tutorial, you will learn about various PostgreSQL index types and how to use them appropriately.
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: List Indexes
Summary: In this tutorial, you will learn how to list indexes from a PostgreSQL database by using either pg_indexes view or psql command.
PostgreSQL Tutorial: Multicolumn Indexes
Summary: In this tutorial, you will learn how to create multicolumn indexes which are indexes defined on more than one column of a table.
PostgreSQL Tutorial: NUMERIC Data Type
Summary: in this tutorial, you will learn about the PostgreSQL NUMERIC type for storing numeric data.
PostgreSQL Tutorial: Partial Index
Summary: in this tutorial, you will learn how to use the PostgreSQL partial index to improve the performance of the query while reducing the index size.
PostgreSQL Tutorial: REINDEX
Summary: In this tutorial, you will learn how to use the PostgreSQL REINDEX statement to rebuild one or more indexes.
PostgreSQL Tutorial: RENAME COLUMN: Renaming a column
Summary: in this tutorial, you will learn how to use the PostgreSQL RENAME COLUMN clause in the ALTER TABLE statement to rename one or more columns of a table.