PostgreSQL Tutorial: UNIQUE Index
Summary: In this tutorial, you will learn how to create a PostgreSQL UNIQUE index to ensure the uniqueness of values in one or more columns.
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: BETWEEN
Summary: in this tutorial, you will learn how to use the PostgreSQL BETWEEN operator to match a value against a range of values.
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.
PostgreSQL Tutorial: CHECK Constraint
Summary: in this tutorial, you will learn about the PostgreSQL CHECK constraints and how to use them to constrain values in columns of a table based on a boolean expression.
PostgreSQL Tutorial: COUNT Function
Summary: In this tutorial, you will learn how to use the PostgreSQL COUNT() function to count the number of rows in a table.
PostgreSQL Tutorial: CREATE DATABASE
Summary: In this tutorial, you will learn how to use the PostgreSQL CREATE DATABASE statement to create new databases in the PostgreSQL database server.
PostgreSQL Tutorial: CREATE ROLE
Summary: In this tutorial, you will learn about the PostgreSQL roles and how to use the CREATE ROLE statement to create new roles.