Database Reference
In-Depth Information
7
Database
Administration
In this chapter, we will cover the following:
F
Writing a script that either all succeeds or all fails
F
Writing a psql script that exits on first error
F
Performing actions on many tables
F
Adding/removing columns on tables
F
Changing data type of a column
F
Adding/removing schemas
F
Moving objects between schemas
F
Adding/removing tablespaces
F
Moving objects between tablespaces
F
Accessing objects in other PostgreSQL databases
F
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 when they're no longer required.