From Chapter 3, PostgreSQL Basic Building Blocks, we learned about the base hierarchy of PostgreSQL objects: databases, roles, and tablespaces. Tables, the main objects that we use to define a data model, were introduced there. We started working on the car portal database—a sample database supposed to be used by a hypothetical car web-portal application. This database was used as a base for code examples throughout this book. Chapter 4, PostgreSQL Advanced Building Blocks introduced other data objects available in PostgreSQL, such as views, indexes, and functions. In these two chapters, we started learning about SQL and data definition language (DDL), which is used to create and modify those data objects.
We mentioned ...
