O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Tables & Data

In this chapter, we will cover the following:

  • Choosing good names for database objects
  • Handling objects with quoted names
  • Enforcing same name, same definition for columns
  • Identifying and removing duplicate rows
  • Preventing duplicate rows
  • Finding a unique key for a set of data
  • Generating test data
  • Randomly sampling data
  • Loading data from a spreadsheet
  • Loading data from flat files

Introduction

This chapter covers a range of general recipes for your tables and working with the data they contain. Many of the recipes contain general advice, though with specific PostgreSQL examples.

Some system administrators I've met work only on the external aspects of the database server. What's actually in the database is someone else's problem.

Look after ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required