Greenplum
Greenplum Tested for version 6.13.0+
Overview JDBC Drivers Features Supported Objects Download

Greenplum

Greenplum object type support.

The following table shows the database specific support in DbVisualizer for Greenplum organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object TypeActionsViewers
Image Image Databases
 Create Database Databases
Image Image Catalog
 Drop Database References, Tables
Image Image Schemas
 Create Schema Schemas
Image Image Schema
 Export Schema[1], Comment Schema, Drop Schema, Rename Schema Info
Image Image Tables
 Create Table[1], Import Table Data[1] References, Tables
Image Image Table
 Alter Table[1], Export Table[1], Import Table Data[1], Script: Script Table, Comment Table, Create Index, Drop Table, Empty Table, Rename Table Navigator[1], References, Data, Columns, DDL[1], Grants, Indexes, Info, Primary Key, Row Count, Row Id
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Constraints
   Constraints
Image Image Constraint
 Drop Constraint Columns, DDL, Info
Image Image Constraint Column
   Info
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
Image Image Rules
   Rules
Image Image Rule
 Drop Rule, Rename Rule DDL, Info
Image Image Partitions[2]
   Partitions
Image Image Partition
 Comment Partition, Create Index, Drop Partition, Empty Partition, Rename Partition Indexes, Info
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
Image Image Partitions
   Partitions
Image Image Partition
 Comment Partition, Create Index, Drop Partition, Empty Partition, Rename Partition Indexes, Info
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
Image Image Foreign Tables[3]
   Foreign Tables
Image Image Foreign Table
 Export Table[1], Script: Script Table, Comment Table, Drop Table Data, Columns, DDL[1], Grants, Info, Row Count
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Views
   Views
Image Image View
 Export View[1], Script: Script View, Comment View, Drop View, Rename View Data, Columns, DDL[1], Grants, Indexes, Info, Row Count
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Materialized Views[3]
   Materialized Views
Image Image Materialized View
 Script: Script Materialized View, Comment Materialized View, Drop Materialized View, Refresh Materialized View Data, Columns, Indexes, Info, Row Count, Select SQL
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
Image Image Procedures[4]
 Create Procedure Procedures
Image Image Procedure
 Export Procedure[1], Script: Script Procedure, Comment Procedure, Drop Procedure, Rename Procedure Procedure Editor[1], Info
Image Image Functions
 Create Function Functions
Image Image Function
 Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function Function Editor[1], Info
Image Image Rules
   Rules
Image Image Rule
 Drop Rule, Rename Rule DDL, Info
Image Image Sequences
 Create Sequence Sequences
Image Image Sequence
 Script: Script Sequence, Comment Sequence, Drop Sequence DDL[1], Info
Image Image Domains
   Domains
Image Image Domain
 Drop Domain Info
Image Image Aggregates
   Aggregates
Image Image Aggregate
 Drop Aggregate, Rename Aggregate Info
Image Image Operators
   Operators
Image Image Operator
   Info
Image Image Types
   Types
Image Image Foreign Servers[3]
   Foreign Servers
Image Image Foreign Server
 Drop Foreign Server Info
Image Image Foreign Tables
   Foreign Tables
Image Image Foreign Table
 Export Table[1], Script: Script Table, Comment Table, Drop Table Data, Columns, DDL[1], Grants, Info, Row Count
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image User Mappings
   User Mappings
Image Image User Mapping
 Drop User Mapping Info
Image Image DBA Views
   DBA
Image Image Users
 Create User Users
Image Image User
 Drop User Info
Image Image Settings
 Reload Configuration Settings
Image Image Locks
   Locks
Image Image Sessions
   Sessions
Image Image Session
 Cancel Session, Terminate Session Most Recent SQL, Session
Image Image Tablespaces
 Create Tablespace Tablespaces
Image Image Tablespace
 Drop Tablespace Info
[1] DbVisualizer Pro
[2] Version 4.3 and later
[3] Version 6.0 and later
[4] Version 7.0 and later