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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.