PostgreSQL Tutorial: REGEXP_MATCHES Function
Summary: The PostgreSQL REGEXP_MATCHES() function matches a regular expression against a string and returns matched substrings.
PostgreSQL Tutorial: REGEXP_REPLACE Function
Summary: In this tutorial, you will learn how to use the PostgreSQL REGEXP_REPLACE() function to replace strings that match a regular expression.
PostgreSQL Tutorial: Delete Duplicate Rows
Summary: in this tutorial, you will learn how to use various techniques to delete duplicate rows in PostgreSQL.
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.