Working with data in PostgreSQL databases

We discussed the topics of setting up a PostgreSQL server or cluster of servers, now we will talk about the data itself.

We discussed a lot about the ways of how to model data, and manipulate it in a database, and in this section, we will do a short recap and point to the topics you might need to take a closer look.

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