PostgreSQL - Database Specific Support

Introduction

In addition to the standard feature set in DbVisualizer this document briefly covers the database specific support in DbVisualizer for the PostgreSQL RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for a PostgreSQL database. The first column list the structure and the object types. The actions column lists all actions that are associated with the object types and the last column shows all viewers that appear when selecting an object in the tree.

The screenshots illustrates the visual representation of the objects tree.

Object Type Actions Viewers Databases   Databases Catalog     Schemas Create Schema Schemas Schema Export Schema, Comment Schema, Drop Schema Info Tables Import Table Data, Create Table References, Tables Table Export Table, Import Table Data, Create Trigger, Alter Table, Comment Table, Create Index, Drop Table, Empty Table, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator1, 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 DDL, Index Triggers   Triggers Trigger Comment Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info Views   Views View Comment View, Drop View, Rename View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL, Data, Indexes, Info, Row Count Indexes   Indexes Index Comment Index, Drop Index, Rebuild Index, Rename Index DDL, Index Triggers   Triggers Trigger Comment Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info Functions Create Function Functions Function Comment Function, Drop Function, Rename Function, Script: CALL Function Editor, Info Sequences Create Sequence Sequences Sequence Comment Sequence, Drop Sequence 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   Users User   Info Groups   Groups Group   Info Settings   Settings Locks   Locks Sessions   Sessions 1) DbVisualizer Personal

---