PostgreSQL - Database Specific Support

DbVisualizer Logo
DbVisualizer 6.0
July 2007
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
Comment SchemaInfo
Tables
Create TableReferences, Tables
Table
Alter Table, Comment Table, Create Index, Drop Table, Empty Table, Import Table Data, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATEColumns, DDL, Data, Grants, Indexes, Info, Navigator, Primary Key, References, Row Count, Row Id
Views
References, Views
View
Comment View, Drop View, Rename View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATEColumns, DDL, Data, Indexes, Info, Row Count
Indexes
Indexes
Index
Comment Index, Drop Index, Rebuild Index, Rename IndexDDL, Info
Triggers
Triggers
Trigger
Disable Trigger, Drop Trigger, Enable Trigger, Rename TriggerInfo, Source
Functions
Create FunctionFunctions
Function
Drop Function, Rename FunctionInfo, Source
Sequences
Create SequenceSequences
Sequence
Comment Function, Drop SequenceInfo
Domains
Domains
Domain
Drop DomainInfo
Aggregates
Aggregates
Aggregate
Drop Aggregate, Rename AggregateInfo
Operators
Operators
Operator
Info
Types
Types
Type
Drop TypeInfo
DBA
DBA
Users
Users
User
Info
Groups
Groups
Group
Info
Settings
Settings
Locks
Locks
Sessions
Sessions




Copyright © 2007 Onseven Software AB. All rights reserved.