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: Getting Started with PostgreSQL
This section helps you get started with PostgreSQL by showing you how to install PostgreSQL on Windows, Linux, and macOS. You also learn how to connect to PostgreSQL using the psql tool as well as how to load a sample database into the PostgreSQL for practicing.
PostgreSQL Tutorial: PostgreSQL vs. MySQL
Summary: MySQL and PostgreSQL offer many of the same features and capabilities, but there are many differences between these two open-source databases.
PostgreSQL Tutorial: Parallel VACUUM
Summary: In this tutorial, you will learn how parallel VACUUM works in PostgreSQL.
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: Convert Strings to Arrays
Summary: In this tutorial, you will learn how to use the PostgreSQL string_to_array() function to convert strings to arrays.
PostgreSQL Tutorial: Leverage expression indexes
Summary: In this tutorial, you will learn how to leverage expression indexes in PostgreSQL.
PostgreSQL Tutorial: PostgreSQL vs. Microsoft SQL Server
Summary: Consider a switch from a commercial to an open source database. Discover the key differences and similarities between PostgreSQL and SQL Server.
PostgreSQL Tutorial: Aggregate Functions
Summary: in this tutorial, you will learn how to use the PostgreSQL aggregate functions such as AVG(), COUNT(), MIN(), MAX(), and SUM().
PostgreSQL Tutorial: Date Functions
The following page shows the most commonly used PostgreSQL date functions that allow you to manipulate date and time values effectively.