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

In this chapter, we will cover the following:

  • Writing a script that either all succeeds or all fails
  • Writing a psql script that exits on first error
  • Performing actions on many tables
  • Adding/removing columns on tables
  • Changing data type of a column
  • Adding/removing schemas
  • Moving objects between schemas
  • Adding/removing tablespaces
  • Moving objects between tablespaces
  • Accessing objects in other PostgreSQL databases
  • Making views updateable

Introduction

The Tables & Data chapter spent time looking at the contents of tables and various complexities. Now, we turn our attention to larger administration tasks that we will need to perform from time-to-time such as creating, moving things around, storing things neatly, and removing them ...

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