PostgreSQL - Database Specific Support

 DbVisualizer Logo
DbVisualizer 6.5
October 2008 		http://www.dbvis.com
support@dbvis.com

[ Master documentation index ]

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

Schemas
Schema
Export Schema, Comment Schema Info
Tables
Create Table References, Tables
Table
Import Table Data, Create Trigger, Alter Table, Create Index, Comment Table, Drop Table, Empty Table, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator, Columns, DDL, Data, Grants, Indexes, Info, Primary Key, Row Count, Row Id
Columns

Columns
Column

Column
Indexes

Indexes
Index
Comment Index, Drop Index, Rebuild Index, Rename Index DDL, Index, Info
Triggers

Triggers
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, Info
Triggers

Triggers
Trigger
Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
Functions
Create Function Functions
Function
Drop Function, Rename Function Function Editor, Info
Sequences
Create Sequence Sequences
Sequence
Comment Function, Drop Sequence Info
Domains

Domains
Domain
Drop Domain Info
Aggregates

Aggregates
Aggregate
Drop Aggregate, Rename Aggregate Info
Operators

Operators
Operator

Info
Types

Types
Type
Drop Type Info
DBA

DBA
Users

Users
User

Info
Groups

Groups
Group

Info
Settings

Settings
Locks

Locks
Sessions

Sessions




Copyright © 2008 Onseven Software AB. All rights reserved.