| Object Type |
Actions |
Viewers |
|
|
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], Create Trigger, 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
|
|
|
|
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
|
|
|
|
Triggers
|
|
|
Triggers
|
|
|
|
Trigger
|
|
Export Trigger[1], Comment Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger
|
Trigger Editor[1], Info
|
|
|
|
Function
|
|
Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function
|
Function Editor[1], Info
|
|
|
|
Partitions[2]
|
|
|
Partitions
|
|
|
|
Partition
|
|
Comment Partition, Create Index, Detach Partition, 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, Detach Partition, 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
|
|
Script: Script Table, Comment Table, Drop Table
|
Data, Columns, 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[4]
|
|
|
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
|
|
|
|
Triggers
|
|
|
Triggers
|
|
|
|
Trigger
|
|
Export Trigger[1], Comment Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger
|
Trigger Editor[1], Info
|
|
|
|
Function
|
|
Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function
|
Function Editor[1], Info
|
|
|
|
Procedures[5]
|
|
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
|
|
|
|
DBA
|
|
|
DBA
|
|
|
|
Users
|
|
Create User
|
Users
|
|
|
|
User
|
|
Drop User
|
Info
|
|
|
|
Groups
|
|
Create Group
|
Groups
|
|
|
|
Group
|
|
Drop Group
|
Info
|
|
|
|
Settings
|
|
Alter Setting[6], Reload Configuration, Reset All[6]
|
Settings
|
|
|
|
Locks
|
|
|
Locks
|
|
|
|
Sessions
|
|
|
Sessions
|
|
|
|
Session
|
|
Cancel Session, Terminate Session
|
Most Recent SQL[7], Session
|
|
|
|
Tablespaces
|
|
Create Tablespace
|
Tablespaces
|
|
|
|
Tablespace
|
|
Drop Tablespace
|
Info
|
|
|
|
ForeignServers[8]
|
|
|
Foreign Servers
|
|
|
|
ForeignServer
|
|
Drop Foreign Server
|
Info
|
|
|
|
UserMappings
|
|
|
User Mappings
|
|
|
|
UserMapping
|
|
Drop User Mapping
|
Info
|
|
|
|
EventTriggers[4]
|
|
|
Event Triggers
|
|
|
|
EventTrigger
|
|
Drop Event Trigger
|
Info
|
|
|
|
Jobs[9]
|
|
Create Job
|
Jobs
|
|
|
|
Job
|
|
Alter Job, Drop Job, Enable/Disable Job
|
Info, Run Log
|
|
|
|
JobSchedules
|
|
Create Schedule
|
Job Schedules
|
|
|
|
JobSchedule
|
|
Alter Schedule, Drop Job Schedule, Enable/Disable Job Schedule
|
Info
|
|
|
|
JobSteps
|
|
Create Job Step
|
Job Steps
|
|
|
|
JobStep
|
|
Alter Job Step, Drop Job Step, Enable/Disable Job Step
|
Info, Run Log
|
[1]
DbVisualizer Pro
[2]
Version 10.0 and later
[3]
Version 9.1 and later
[4]
Version 9.3 and later
[5]
Version 11.0 and later
[6]
Version 9.4 and later
[7]
Version 9.2 and later
[8]
Version 8.4 and later
[9]
Requires pgAgent in the database
|
