PostgreSQL
PostgreSQL Tested for version 8+
Overview JDBC Drivers Features Supported Objects Download

PostgreSQL

PostgreSQL object type support.

The following table shows the database specific support in DbVisualizer for PostgreSQL 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], 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
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
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
 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[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
ForeignServers[6]
   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
Privileges
   Object Grants
DBA
   DBA
Users[7]
 Create User Users
User
 Drop User Info
Groups[7]
 Create Group Groups
Group
 Drop Group Info
Roles[8]
 Create Role Roles
Role
 Drop Role, Grant Role, Revoke Role Direct Members, Info, Member Of
Settings
 Alter Setting[9], Reload Configuration, Reset All[9] Settings
Locks
   Locks
Sessions
   Sessions
Session
 Cancel Session, Terminate Session Most Recent SQL[10], Session
Tablespaces
 Create Tablespace Tablespaces
Tablespace
 Drop Tablespace Info
EventTriggers[4]
   Event Triggers
EventTrigger
 Drop Event Trigger Info
Jobs[11]
 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 8.4 and later
[7] Version 8.0 and earlier
[8] Version 8.1 and later
[9] Version 9.4 and later
[10] Version 9.2 and later
[11] Requires pgAgent in the database
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 ↗