Index

A

aggregates
commenting, Aggregates
creating, Aggregates
dropping, Aggregates
requires a state transition function, Aggregates
ANALYZE command, Analyze
Ask For Confirmations, The Menu Bar

C

check constraints
overview, Check Constraints
cluster
adding, Adding a New Cluster
editing, Editing an Existing Cluster
initializing, Clusters
removing, Removing a Cluster
column
adding to a table, Columns
commenting, Columns
renaming, Columns
setting default, Columns
setting statistics, Columns
columns
creating, Defining Columns
confirmation requests
controlling, The Menu Bar
connections
configuring, Configuring a Connection to a Database
constraints
column, Column Constraints
commenting, Foreign Key (FK) Constraints
dropping, Foreign Key (FK) Constraints
overview, Constraints
table, Table Constraints
Copy Configuration
enabling, Troubleshooting Visual Explain

D

data types
commenting, Data Types
creating, Data Types
dropping, Data Types
database
analyzing, Analyze
commenting, Creating a Database
creating, Creating a Database
vacuuming, Vacuum
database connections
configuring, Configuring a Connection to a Database
deleting, Deleting a Connection to a Database
database objects
dropping, Dropping Database Objects
database password
configuring, Configuring Visual Explain's Operation
database passwords
saving, Configuring Visual Explain's Operation
databases
commenting, Databases
creating, Databases
dropping, Databases
debugging
logging to SQL window, The Menu Bar
showing log window, The Menu Bar
Delete Configuration
enabling, Troubleshooting Visual Explain

E

Edit Configuration
enabling, Troubleshooting Visual Explain
EXPLAIN ANALYZE
configuring, Configuring Visual Explain's Operation
enabling, Configuring Visual Explain's Operation
requires PostgreSQL 7.2, Configuring Visual Explain's Operation

F

foreign key constraints
overview, Foreign Key (FK) Constraints
functions
commenting, Creating a Function Written in C
creating in C, Creating a Function Written in C
creating in SQL, Functions
dropping, Creating a Function Written in C
replacing, Creating a Function Written in C

G

groups
altering, Groups
creating, Creating Groups, Groups
dropping, Groups

I

icons
configuring, Configuring Visual Explain's Operation
indexes
altering owner, Indexes
commenting, Indexes
creating, Indexes
dropping, Indexes
renaming, Indexes

K

keyboard focus, Column Constraints

L

languages
creating, Creating a New Language
dropping, Creating a Language with Manage Supported Languages
lock files
and RHDB Administrator, Startup Problems
and Visual Explain, Troubleshooting Visual Explain
Log SQL Data, The Menu Bar
log window
showing, The Menu Bar

M

multiple copies
running, Startup Problems, Troubleshooting Visual Explain

N

navigation
hyperlinks, Navigating RHDB Administrator
keyboard, The Tree View and View Pane
menu bar, The Menu Bar
tool bar, Navigating RHDB Administrator
nickname
assigning to a connection, Configuring a Connection to a Database

O

objects
dropping, Dropping Database Objects
operator
creating, Creating an Operator
OPERATOR commands
managing, Operators
operators
commenting, Creating an Operator
dropping, Creating an Operator

P

primary key constraints
overview, Primary Key Constraints
privileges
managing, Privileges
specifying, Privileges

R

RHDB Administrator
navigation, Using RHDB Administrator, The Menu Bar
overview, RHDB Administrator
running multiple copies, Startup Problems
starting, Starting RHDB Administrator
rules
commenting, Rules
creating, Rules
dropping, Rules

S

sequences
altering owner, Sequences
commenting, Sequences
dropping, Sequences
renaming, Sequences
Show System Objects, The Menu Bar
SQL commands
executing, Troubleshooting Visual Explain
running, Running and Storing SQL Commands
storing, Running and Storing SQL Commands
SQL Log Window, The Menu Bar
system objects
showing, The Menu Bar

T

table
adding column, Creating a Table
altering owner, Privileges
analyzing, ANALYZE TABLE
commenting, Privileges
creating, Creating a Table
dropping, Privileges
renaming, Privileges
vacuuming, VACUUM TABLE
tables
creating, Tables
options, Options
tool tips
displaying, Configuring Visual Explain's Operation
enabling, Configuring Visual Explain's Operation
require JRE v.1.4, Configuring Visual Explain's Operation
trigger
commenting, Triggers
dropping, Triggers
triggers
creating, Triggers

U

unique constraints
overview, Unique Constraints
users
altering, Users
creating, Creating Users and Groups, Users
dropping, Users

V

VACUUM command, Vacuum
views
altering owner, Views
commenting, Views
creating, Views
dropping, Views
renaming, Views
Visual Explain
configuration, Configuring Visual Explain's Operation
configuring, Configuring Visual Explain
installing, Installing the Graphical Tools on a Client Machine
overview, Visual Explain
running, Using Visual Explain
running multiple copies, Troubleshooting Visual Explain
starting, Starting Visual Explain