PostgreSQL schema objects

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 ...

Get Learning PostgreSQL 11 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.