Chapter 5: Tables and Data
This chapter covers a range of general recipes for your tables and for working with the data they contain. Many of the recipes contain general advice, with specific PostgreSQL examples.
Some system administrators that I've met work only on the external aspects of a database server. What's actually in the database is someone else's problem.
Look after your data, and your database will look after you. Keep your data clean, and your queries will run faster and cause fewer application errors. You'll also gain many friends in the business. Getting called in the middle of the night to fix data problems just isn't cool.
In this chapter, we will cover the following recipes:
- Choosing good names for database objects
- Handling ...
Get PostgreSQL 14 Administration Cookbook 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.