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
Constraint Column
   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
Indexes
   Indexes
Index
 Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
Partitions
   Partitions
Partition
 Comment Partition, Create Index, Detach Partition, Drop Partition, Empty Partition, Rename Partition Indexes, Info
Indexes
   Indexes
Index
 Script: Script Index, Comment Index, Drop Index, Rebuild Index, Rename Index DDL[1], Index
Foreign Tables[3]
   Foreign Tables
Foreign Table
 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
Materialized Views[4]
   Materialized Views
Materialized View
 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
 Create Domain Domains
Domain
 Comment Domain, Drop Domain DDL[6], Info
Aggregates
   Aggregates
Aggregate
 Drop Aggregate, Rename Aggregate Info
Operators
   Operators
Operator
   Info
Types
 Create Composite Type, Create Enum Type[7] Types
Foreign Servers[8]
   Foreign Servers
Foreign Server
 Drop Foreign Server Info
Foreign Tables
   Foreign Tables
Foreign Table
 Export Table[1], Script: Script Table, Comment Table, Drop Table Data, Columns, DDL[1], Grants, Info, Row Count
Columns
   Columns
Column
 Comment Column Column
User Mappings
   User Mappings
User Mapping
 Drop User Mapping Info
Object Privileges
   Object Grants
DBA Views
   DBA
Users[9]
 Create User Users
User
 Drop User Info
Groups[9]
 Create Group Groups
Group
 Drop Group Info
Roles[10]
 Create Role Roles
Role
 Drop Role, Grant Role, Revoke Role Direct Members, Info, Member Of
Settings
 Alter Setting[11], Reload Configuration, Reset All[11] Settings
Locks
   Locks
Sessions
   Sessions
Session
 Cancel Session, Terminate Session Most Recent SQL[12], Session
Tablespaces
 Create Tablespace Tablespaces
Tablespace
 Drop Tablespace Info
Event Triggers[4]
   Event Triggers
Event Trigger
 Drop Event Trigger Info
Jobs[13]
 Create Job Jobs
Job
 Alter Job, Drop Job, Enable/Disable Job Info, Run Log
Job Schedules
 Create Schedule Job Schedules
Job Schedule
 Alter Schedule, Drop Job Schedule, Enable/Disable Job Schedule Info
Job Steps
 Create Job Step Job Steps
Job Step
 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] drop-on-condition:#util.isDatabaseVersionLT(9,1)
[7] drop-on-condition:#util.isDatabaseVersionLT(8,3)
[8] Version 8.4 and later
[9] Version 8.0 and earlier
[10] Version 8.1 and later
[11] Version 9.4 and later
[12] Version 9.2 and later
[13] Requires pgAgent in the database