Summary

In this chapter, we went through the concept of tablespaces (containers for other objects). We also covered views and tables, especially temporary tables, and concepts specific to PostgreSQL, such as databases, search_path, and schemas. We also saw how privileges and access controls are managed.

In the next chapter, we will cover transactions, and we will see how concurrency is managed in PostgreSQL.

Get PostgreSQL for Data Architects 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.