Module 8 - GUI Tools

Module Objectives

Overview

Features

Download PEM Client

Installing PEM Client

PEM Client - License Agreement

PEM Client - Installation Directory

PEM Client - Finish Installation

Demo - Installing PEM Client

Open Postgres Enterprise Manager Client

PEM Client First Look

Register A Database Cluster

Common Connection Problems

Changing A Server's Registration

Viewing Data

Filtering and Sorting Data

Query Tool

Query Tool - Change Connection

Query Tool - Data Output

Query Tool - Graphical Query Builder

Query Tool - Explain

Query Tool - Messages

Query Tool - History

Databases

Creating a Database

Schemas

Tables

Tables - Adding Columns/Constraints

Tables - Indexes

Tables - Maintenance

Tablespaces

Roles

Server Status

Demo - PEM Client

Module Summary

Lab Exercise - 1

Lab Exercise - 1 (continued)