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: Compare Two Tables
Summary: in this tutorial, you will learn various ways to compare two tables in PostgreSQL.
PostgreSQL Tutorial: Copy Database
Summary: in this tutorial, you will learn how to copy a PostgreSQL database on the same server or from a server to another.
PostgreSQL Tutorial: Get Table, Database, Indexes, Tablespace, and Value Size
Summary: in this tutorial, you will learn how to get the size of the databases, tables, indexes, tablespace using some handy functions.
PostgreSQL Tutorial: ABS Function
Summary: The PostgreSQL ABS() function returns the absolute value of a number.
PostgreSQL Tutorial: CEIL Function
Summary: The PostgreSQL CEIL() function returns a number rounded up to the next whole number.
PostgreSQL Tutorial: CTE
Summary: in this tutorial, you will learn how to use the PostgreSQL CTE (common table expressions) to simplify complex queries.
PostgreSQL Tutorial: CUME_DIST Function
Summary: In this tutorial, you will learn how to use the PostgreSQL CUME_DIST() function to calculate the cumulative distribution of a value within a set of values.
PostgreSQL Tutorial: DENSE_RANK Function
Summary: In this tutorial, you are going to learn how to use the PostgreSQL DENSE_RANK() function to assign a rank to each row within a partition of a result set, with no gaps in ranking values.
PostgreSQL Tutorial: FIRST_VALUE Function
Summary: In this tutorial, you will learn how to use the PostgreSQL FIRST_VALUE() function to return the first value in a sorted partition of a result set.