PostgreSQL - Red Hat Edition: Graphical Tools Guide
Prev

Index

A

Administrator

Menu Bar, The Menu Bar

navigation, The Menu Bar, The Navigation Bar

Navigation Bar, The Navigation Bar

paths, Navigation Bar Paths

new features, New Features

overview, Introducing the Graphical Tools, Administrator

overview of example database, Administrator Reference

running multiple copies, Problems During Operation

starting, Starting Administrator

Status Bar, The Status Bar

supported operations, Administrator

Toolbar, The Toolbar

troubleshooting, Troubleshooting Administrator

tutorial, Tutorial

using, Using Administrator

aggregates

commenting, Aggregates

creating, Aggregates

dropping, Aggregates

requires a state transition function, Aggregates

ANALYZE command, Analyze

Ask For Confirmations, The Menu Bar

auto-quote identifiers

controlling in Administrator, The Menu Bar

B

backend version

viewing, Adding a Cluster

backup

incompatible options, Incompatible Options

of a database, Backing up a Database

of a database cluster, Backing up a Database Cluster

of a table, Backing up a Table

C

casts

creating, Casts

dropping, Casts

check constraints

adding, Check Constraints

cluster

adding, Adding a Cluster, Adding a Cluster

adding to Administrator, The Menu Bar

assigning an engine to, Assigning a Database Engine to a Database Cluster

browsing information, Browsing Information about Database Clusters

browsing the log file, Viewing a Database Cluster Log File

creating, Creating a Database Cluster

deleting, Deleting a Database Cluster

editing locations for, Editing Database Cluster Locations

editing run-time options, Editing Database Cluster Run Time Options

editing the configuration, Editing Database Cluster Configuration

initializing, Initializing a Database Cluster

reconfiguring, Reconfiguring a Cluster

removing, Removing a Cluster

restarting the engine, Restarting a Database Cluster's Engine

starting the engine, Starting a Database Cluster's Engine

stopping the engine, Stopping a Database Cluster's Engine

column

adding to a table, Creating a Table, Columns

altering, ALTER COLUMN

set default value, ALTER COLUMN
set NULL handling, ALTER COLUMN
set statistics, ALTER COLUMN
set storage mode, ALTER COLUMN

commenting, Columns

creating, Defining Columns

dropping, Columns

renaming, Columns

confirmation requests

controlling in Administrator, The Menu Bar

connection

configuring in Visual Explain, Configuring a Connection

connections

configuring with Visual Explain, Configuring and Modifying a Database Connection

constraints

check, Check Constraints

column, Column Constraints

commenting, Foreign Key Constraints

dropping, Foreign Key Constraints

foreign key, Foreign Key Constraints

overview, Constraints

primary key, Primary Key Constraints

table, Table Constraints

unique, Unique Constraints

Control Center

assigning an engine to a cluster, Assigning a Database Engine to a Database Cluster

browsing a cluster's information, Browsing Information about Database Clusters

browsing a cluster's log file, Viewing a Database Cluster Log File

browsing an engine's information, Browsing Information about Database Engines

creating a new cluster, Creating a Database Cluster

deleting a cluster and its data, Deleting a Database Cluster

Detail Area, The Detail Area

editing a cluster's HBA settings, Editing Database Cluster Host-Based Authentication (HBA) Settings

editing a cluster's log settings, Editing Database Cluster Log Settings

editing a cluster's run-time options, Editing Database Cluster Run Time Options

editing locations for a cluster, Editing Database Cluster Locations

editing the cluster configuration, Editing Database Cluster Configuration

initializing a cluster, Initializing a Database Cluster

making a new engine available, Making a Database Engine Available

Menu Bar, The Menu Bar

navigation, The Menu Bar

overview, Introducing the Graphical Tools, Control Center

prerequisites, Control Center Prerequisites

refreshing the data, Refreshing the Displayed Data

restarting a cluster's engine, Restarting a Database Cluster's Engine

running regression tests on a cluster, Running Regression Tests on a Database Cluster

starting a cluster's engine, Starting a Database Cluster's Engine

starting with rhdb-cc, Starting Control Center

Status Bar, The Status Bar

stopping a cluster's engine, Stopping a Database Cluster's Engine

Summary Area, The Summary Area

terminology, Terminology

Toolbar, The Toolbar

Transcript Window, The Transcript Window

tutorial, Tutorial

conversions

creating, Conversions

Copy Configuration

enabling in Visual Explain, Problems During Operation

D

data types

commenting, Data Types

creating, Data Types

dropping, Data Types

Data Viewer

configuration, The Menu Bar

database

altering variables, Databases

analyzing, Analyze

commenting, Creating a Database, Databases

connecting to, Connecting to a Database

creating, Creating a Database, Databases

dropping, Dropping Database Objects, Databases

vacuuming, Vacuum

database connections

configuring with Visual Explain, Configuring and Modifying a Database Connection

deleting in Visual Explain, Configuring and Modifying a Database Connection

database password

configuring in Visual Explain, Configuring and Modifying a Database Connection

saving in Visual Explain, Configuring and Modifying a Database Connection

debugging

logging to SQL window, The Menu Bar

showing log window, The Menu Bar

Delete Configuration

enabling in Visual Explain, Problems During Operation

document conventions, Document Conventions

domains

commenting, Domains

creating, Domains

dropping

commenting, Domains

E

Edit Configuration

enabling in Visual Explain, Problems During Operation

engine

browsing information, Browsing Information about Database Engines

making available, Making a Database Engine Available

restarting, Restarting a Database Cluster's Engine

starting, Starting a Database Cluster's Engine

stopping, Stopping a Database Cluster's Engine

EXPLAIN ANALYZE and Visual Explain

configuring, Configuring Preferences

enabling, Configuring Preferences

F

focus

Administrator

move with Tab key, The Tree View and View Pane
moving to Navigation Bar with Ctrl-g, Navigation Bar Paths
moving with keyboard, Column Constraints

foreign key constraints

overview, Foreign Key Constraints

functional index

creating, Indexes

functions

commenting, Creating a Function Written in C

creating in C

on a 7.3 backend, Creating a Function Written in C

creating in SQL, Functions

on a 7.3 backend, Creating a Function Written in SQL

dropping, Creating a Function Written in C

replacing, Creating a Function Written in C

G

groups

altering, Groups

creating, Creating Groups, Groups

dropping, Groups

H

HBA settings

editing, Editing Database Cluster Host-Based Authentication (HBA) Settings

I

icons

configuring in Visual Explain, Configuring Preferences

index

reindexing, Indexes

indexes

altering owner, Indexes

commenting, Indexes

creating, Indexes

dropping, Indexes

renaming, Indexes

K

key-binding error messages

in Visual Explain, Problems During Operation

L

languages

creating, Languages

dropping, Manage Supported Languages

lock files

and Administrator, Problems During Operation

and Visual Explain, Problems During Operation

log file

controlling Control Center, Editing Database Cluster Log Settings

Log SQL Driver Data, The Menu Bar

log window

showing, The Menu Bar

M

Manage Cluster

Administrator function, The Menu Bar

multiple copies

running, Problems During Operation

multiple Visual Explain copies

running, Problems During Operation

N

navigation

Administrator

hyperlinks, Using Administrator
keyboard, The Tree View and View Pane
Menu Bar, The Menu Bar
Navigation Bar, The Navigation Bar
Status Bar, The Status Bar
Toolbar, The Toolbar
Tree View, The Tree View and View Pane
View Pane, The Tree View and View Pane

Control Center

Detail Area, The Detail Area
Menu Bar, The Menu Bar
Status Bar, The Status Bar
Summary Area, The Summary Area
Toolbar, The Toolbar

Visual Explain

Detail Pane, The View Pane and Detail Pane
Menu Bar, The Menu Bar
SQL Entry Area, The SQL Entry Area
Status Bar, The Status Bar
Toolbar, The Toolbar
View Pane, The View Pane and Detail Pane

nickname

for a connection in Visual Explain, Configuring and Modifying a Database Connection

O

objects

dropping, Dropping Database Objects

operator classes

creating, Operator Classes

dropping, Operator Classes

OPERATOR commands

managing, Operators

operators

commenting, Operators

creating, Operators

dropping, Operators

P

plan overview

showing, Manipulating the Visual Explain Display

planner options

setting, Setting Planner Options

primary key constraints

overview, Primary Key Constraints

privileges

managing, Privileges

specifying for tables, Privileges

psql

quick database access, Usability Enhancements

R

regression tests

running, Running Regression Tests on a Database Cluster

restore

a database, Restoring a Database

a function, Restoring a Function

a table, Restoring a Table

incompatible options, Incompatible Options

rules

commenting, Rules

creating, Rules

dropping, Rules

replacing, Rules

S

schema

creating, Creating a Schema

schemas

commenting, Schemas

creating, Schemas, Sequences

dropping, Schemas

sequences

altering owner, Sequences

commenting, Sequences

dropping, Sequences

renaming, Sequences

shell database access, Usability Enhancements

shells

launching, Launching psql Shells

Show Driver Log, The Menu Bar

SQL commands

executing in Visual Explain, Problems During Operation

running in Visual Explain, Running and Storing SQL Commands

storing in Visual Explain, Running and Storing SQL Commands

SQL queries in Visual Explain

reloading, Configuring Preferences

SQL query

submitting in Visual Explain, Entering a Query

T

table

adding column, Creating a Table

altering owner, Privileges

analyzing, Analyze Table

backup, Privileges

clustering, Privileges

commenting, Privileges

creating, Creating a Table, Tables

dropping, Privileges

options, Options

reindexing, Privileges

renaming, Privileges

vacuuming, Vacuum Table

viewing data, Viewing Table Data

table data

viewing, Viewing Table Data

tool tips in Visual Explain

displaying, Configuring Preferences

Transcript Window

displaying in Control Center, The Transcript Window

trigger

commenting, Triggers

creating, Triggers

dropping, Triggers

renaming, Triggers

troubleshooting

Administrator

case-sensitivity problems, Case-Sensitivity Problems
running multiple copies, Problems During Operation
unable to start, Troubleshooting Administrator

Visual Explain

configuration options are disabled, Problems During Operation
EXPLAIN button is disabled, Problems During Operation
key-binding error messages, Problems During Operation
running multiple copies, Problems During Operation
SQL does not execute, Problems During Operation

U

unique constraints

creating, Unique Constraints

overview, Unique Constraints

users

altering, Users

creating, Creating Users and Groups, Users

dropping, Users

V

VACUUM command, Vacuum

view data

criteria and options, Selection Criteria And Ordering Options

data display, Data Display

overview, View Data

page options and status, Page Options And Status Information

views

altering owner, Views

commenting, Views

creating, Views

dropping, Views

renaming, Views

replacing, Views

Visual Explain

configuring, Visual Explain Reference

detail pane, The View Pane and Detail Pane

Menu Bar, The Menu Bar

navigation, The Menu Bar

new features, New Features

optimizable commands, Visual Explain

overview, Introducing the Graphical Tools, Visual Explain

prerequisites, Visual Explain Prerequisites

rotating display, Manipulating the Visual Explain Display

running multiple copies, Problems During Operation

running SQL commands, Running and Storing SQL Commands

SQL entry area, The SQL Entry Area

starting, Starting Visual Explain

Status Bar, The Status Bar

Toolbar, The Toolbar

troubleshooting, Troubleshooting Visual Explain

tutorial, Tutorial

using, Using Visual Explain

view pane, The View Pane and Detail Pane