Customer Testimonial:

This software is phenomenal! I've used many database tools over the years but none have been as impressive as DbVisualizer. It's unique, ...

Scott Beeson - Missouri Health Connection

PostgreSQL

Database Specific Support

The following table show the database specific support 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 Type Actions Viewers
Databases
Create Database Databases
Catalog
Drop Database  
Schemas
Create Schema Schemas
Schema
Export Schema, Comment Schema, Drop Schema Info
Tables
Create Table, Import Table Data References, Tables
Table
Alter Table, Create Trigger, Export Table, Import Table Data, Comment Table, Create Index, Drop Table, Empty Table, Rename Table, Script: Script Table Navigator1, References, Columns, DDL, Data, Grants, Indexes, Info, Primary Key, Row Count, Row Id
Columns
  Columns
Column
Comment Column Column
Indexes
  Indexes
Index
Comment Index, Drop Index, Rebuild Index, Rename Index, Script: Script Index DDL, Index
Triggers
  Triggers
Trigger
Export Trigger, Comment Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
Partitions2
  Partitions
Partition
Comment Partition, Create Index, Detach Partition, Drop Partition, Empty Partition, Rename Partition Indexes, Info
PartitionIndexes
  Indexes
Index
Comment Index, Drop Index, Rebuild Index, Rename Index, Script: Script Index DDL, Index
SubPartitions
  Partitions
Partition
Comment Partition, Create Index, Detach Partition, Drop Partition, Empty Partition, Rename Partition Indexes, Info
PartitionIndexes
  Indexes
Index
Comment Index, Drop Index, Rebuild Index, Rename Index, Script: Script Index DDL, Index
ForeignTables3
  Foreign Tables
ForeignTable
Comment Table, Drop Table, Script: Script Table Columns, Data, Grants, Info, Row Count
Columns
  Columns
Column
Comment Column Column
Views
  Views
View
Export View, Comment View, Drop View, Rename View, Script: Script View Columns, DDL, Data, Grants, Indexes, Info, Row Count
Columns
  Columns
Column
Comment Column Column
MaterializedViews4
  Materialized Views
MaterializedView
Comment Materialized View, Drop Materialized View, Refresh Materialized View, Script: Script Materialized View Columns, Data, Indexes, Info, Row Count, Select SQL
Columns
  Columns
Column
Comment Column Column
Indexes
  Indexes
Index
Comment Index, Drop Index, Rebuild Index, Rename Index, Script: Script Index DDL, Index
Indexes
  Indexes
Index
Comment Index, Drop Index, Rebuild Index, Rename Index, Script: Script Index DDL, Index
Triggers
  Triggers
Trigger
Export Trigger, Comment Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
Functions
Create Function Functions
Function
Export Function, Comment Function, Drop Function, Rename Function, Script: Script Function Function Editor, Info
Sequences
Create Sequence Sequences
Sequence
Comment Sequence, Drop Sequence, Script: Script Sequence DDL, Info
Domains
  Domains
Domain
Drop Domain Info
Aggregates
  Aggregates
Aggregate
Drop Aggregate, Rename Aggregate Info
Operators
  Operators
Operator
  Info
Types
  Types
Type
Comment Type, Drop Type Info
DBA
  DBA
Users
Create User Users
User
Drop User Info
Groups
Create Group Groups
Group
Drop Group Info
Settings
Alter Setting5, Reload Configuration, Reset All5 Settings
Locks
  Locks
Sessions
  Sessions
Tablespaces
Create Tablespace Tablespaces
Tablespace
Drop Tablespace Info
ForeignServers6
  Foreign Servers
ForeignServer
Drop Foreign Server Info
UserMappings
  User Mappings
UserMapping
Drop User Mapping Info
EventTriggers4
  Event Triggers
EventTrigger
Drop Event Trigger Info
Jobs7
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) #util.isDatabaseVersionGTE(10,0)
3) Version 9.1 and later
4) Version 9.3 and later
5) Version 9.4 and later
6) Version 8.4 and later
7) Requires pgAgent in the database

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.

Close