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
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], 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
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 Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Comment Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor[1], Info
Image Image Function
 Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function Function Editor[1], Info
Image Image Partitions[2]
   Partitions
Image Image Partition
 Comment Partition, Create Index, Detach Partition, 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, Detach Partition, 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 Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Comment Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor[1], Info
Image Image Function
 Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function Function Editor[1], Info
Image Image Materialized Views[4]
   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 Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Comment Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor[1], Info
Image Image Function
 Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function Function Editor[1], Info
Image Image Procedures[5]
 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
 Create Domain Domains
Image Image Domain
 Comment Domain, Drop Domain DDL[6], Info
Image Image Aggregates
   Aggregates
Image Image Aggregate
 Drop Aggregate, Rename Aggregate Info
Image Image Operators
   Operators
Image Image Operator
   Info
Image Image Types
 Create Composite Type, Create Enum Type[7] Types
Image Image Foreign Servers[8]
   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 Object Privileges
   Object Grants
Image Image DBA Views
   DBA
Image Image Users[9]
 Create User Users
Image Image User
 Drop User Info
Image Image Groups[9]
 Create Group Groups
Image Image Group
 Drop Group Info
Image Image Roles[10]
 Create Role Roles
Image Image Role
 Drop Role, Grant Role, Revoke Role Direct Members, Info, Member Of
Image Image Settings
 Alter Setting[11], Reload Configuration, Reset All[11] Settings
Image Image Locks
   Locks
Image Image Sessions
   Sessions
Image Image Session
 Cancel Session, Terminate Session Most Recent SQL[12], Session
Image Image Tablespaces
 Create Tablespace Tablespaces
Image Image Tablespace
 Drop Tablespace Info
Image Image Event Triggers[4]
   Event Triggers
Image Image Event Trigger
 Drop Event Trigger Info
Image Image Jobs[13]
 Create Job Jobs
Image Image Job
 Alter Job, Drop Job, Enable/Disable Job Info, Run Log
Image Image Job Schedules
 Create Schedule Job Schedules
Image Image Job Schedule
 Alter Schedule, Drop Job Schedule, Enable/Disable Job Schedule Info
Image Image Job Steps
 Create Job Step Job Steps
Image Image 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