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
Databases
Create Database Databases
Catalog
Drop Database References, Tables
Schemas
Create Schema Schemas
Schema
Export Schema[1], Comment Schema, Drop Schema, Rename Schema Info
Tables
Create Table[1], Import Table Data[1] References, Tables
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
Columns
  Columns
Column
Comment Column Column
Constraints
  Constraints
Constraint
Drop Constraint Columns, DDL, Info
ConstraintColumn
  Info
Indexes
  Indexes
Index
Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
Rules
  Rules
Rule
Drop Rule, Rename Rule DDL, Info
Partitions[2]
  Partitions
Partition
Comment Partition, Create Index, Drop Partition, Empty Partition, Rename Partition Indexes, Info
PartitionIndexes
  Indexes
Index
Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
SubPartitions
  Partitions
Partition
Comment Partition, Create Index, Drop Partition, Empty Partition, Rename Partition Indexes, Info
PartitionIndexes
  Indexes
Index
Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
ForeignTables[3]
  Foreign Tables
ForeignTable
Export Table[1], Script: Script Table, Comment Table, Drop Table Data, Columns, DDL[1], Grants, Info, Row Count
Columns
  Columns
Column
Comment Column Column
Views
  Views
View
Export View[1], Script: Script View, Comment View, Drop View, Rename View Data, Columns, DDL[1], Grants, Indexes, Info, Row Count
Columns
  Columns
Column
Comment Column Column
MaterializedViews[3]
  Materialized Views
MaterializedView
Script: Script Materialized View, Comment Materialized View, Drop Materialized View, Refresh Materialized View Data, Columns, Indexes, Info, Row Count, Select SQL
Columns
  Columns
Column
Comment Column Column
Indexes
  Indexes
Index
Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
Indexes
  Indexes
Index
Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
Procedures[4]
Create Procedure Procedures
Procedure
Export Procedure[1], Script: Script Procedure, Comment Procedure, Drop Procedure, Rename Procedure Procedure Editor[1], Info
Functions
Create Function Functions
Function
Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function Function Editor[1], Info
Rules
  Rules
Rule
Drop Rule, Rename Rule DDL, Info
Sequences
Create Sequence Sequences
Sequence
Script: Script Sequence, Comment Sequence, Drop Sequence DDL[1], Info
Domains
  Domains
Domain
Drop Domain Info
Aggregates
  Aggregates
Aggregate
Drop Aggregate, Rename Aggregate Info
Operators
  Operators
Operator
  Info
Types
  Types
ForeignServers[3]
  Foreign Servers
ForeignServer
Drop Foreign Server Info
ForeignTables
  Foreign Tables
ForeignTable
Export Table[1], Script: Script Table, Comment Table, Drop Table Data, Columns, DDL[1], Grants, Info, Row Count
Columns
  Columns
Column
Comment Column Column
UserMappings
  User Mappings
UserMapping
Drop User Mapping Info
DBA
  DBA
Users
Create User Users
User
Drop User Info
Settings
Reload Configuration Settings
Locks
  Locks
Sessions
  Sessions
Session
Cancel Session, Terminate Session Most Recent SQL, Session
Tablespaces
Create Tablespace Tablespaces
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
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗