Download aginity workbench for greenplum functionality overview

CONTENTS
1.
Overview ......................................................................................................................................... 4
2.
Database Connection Dialog Box...................................................................................................... 5
3.
Main Window of Aginity Workbench ............................................................................................... 8
3.1.
Object Browser ........................................................................................................................ 8
3.2.
SQL Editor .............................................................................................................................. 10
3.2.1.
Adding a New Tab in the SQL Editor ................................................................................ 10
3.2.2.
Accessing SQL Statement Management Functions .......................................................... 11
3.2.3.
Inserting a Object/Column Names into the SQL Editor .................................................... 11
3.3.
Result Set ............................................................................................................................... 11
3.3.1.
Managing Grid View ....................................................................................................... 12
3.3.2.
Exporting the Query Execution Result ............................................................................. 13
3.4.
Menu Bar and Toolbar............................................................................................................ 13
3.5.
Status Bar............................................................................................................................... 14
4.
File Menu ...................................................................................................................................... 15
5.
Edit Menu ...................................................................................................................................... 18
6.
Object Menu .................................................................................................................................. 23
7.
8.
6.1.
Functions Provided by the Object Menu ................................................................................. 23
6.2.
Viewing Database Space......................................................................................................... 27
Tools Menu.................................................................................................................................... 30
7.1.
Importing Data to the Database ............................................................................................. 37
7.2.
Using a 3-rd Party File Diff Tool in Workbench ........................................................................ 40
7.3.
Using Database Highlighting ................................................................................................... 42
Query Menu .................................................................................................................................. 44
8.1 Using Parameter Substitution ...................................................................................................... 49
CONFIDENTIAL AND PROPRIETARY, AGINITY LLC.
DISTRIBUTE WITHOUT PRIOR AUTHORIZATION.
DO NOT
2