5.7.1. Creating a Schema ..............................................................................................70
5.7.2. The Public Schema .............................................................................................71
5.7.3. The Schema Search Path.....................................................................................71
5.7.4. Schemas and Privileges.......................................................................................72
5.7.5. The System Catalog Schema ..............................................................................73
5.7.6. Usage Patterns.....................................................................................................73
5.7.7. Portability............................................................................................................73
5.8. Inheritance .......................................................................................................................74
5.8.1. Caveats................................................................................................................77
5.9. Partitioning ......................................................................................................................77
5.9.1. Overview.............................................................................................................77
5.9.2. Implementing Partitioning ..................................................................................78
5.9.3. Managing Partitions............................................................................................81
5.9.4. Partitioning and Constraint Exclusion ................................................................82
5.9.5. Alternative Partitioning Methods........................................................................83
5.9.6. Caveats................................................................................................................84
5.10. Foreign Data ..................................................................................................................85
5.11. Other Database Objects .................................................................................................85
5.12. Dependency Tracking....................................................................................................86
6. Data Manipulation........................................................................................................................88
6.1. Inserting Data ..................................................................................................................88
6.2. Updating Data..................................................................................................................89
6.3. Deleting Data...................................................................................................................90
7. Queries .........................................................................................................................................91
7.1. Overview .........................................................................................................................91
7.2. Table Expressions ............................................................................................................91
7.2.1. The FROM Clause.................................................................................................92
7.2.1.1. Joined Tables ..........................................................................................92
7.2.1.2. Table and Column Aliases......................................................................96
7.2.1.3. Subqueries ..............................................................................................97
7.2.1.4. Table Functions ......................................................................................98
7.2.1.5. LATERAL Subqueries ..............................................................................99
7.2.2. The WHERE Clause.............................................................................................100
7.2.3. The GROUP BY and HAVING Clauses................................................................101
7.2.4. Window Function Processing ...........................................................................103
7.3. Select Lists.....................................................................................................................104
7.3.1. Select-List Items ...............................................................................................104
7.3.2. Column Labels..................................................................................................105
7.3.3. DISTINCT .........................................................................................................105
7.4. Combining Queries........................................................................................................106
7.5. Sorting Rows .................................................................................................................106
7.6. LIMIT and OFFSET........................................................................................................107
7.7. VALUES Lists .................................................................................................................108
7.8. WITH Queries (Common Table Expressions) ................................................................109
7.8.1. SELECT in WITH................................................................................................109
7.8.2. Data-Modifying Statements in WITH ................................................................113
8. Data Types..................................................................................................................................115
8.1. Numeric Types...............................................................................................................116
v
