PostgreSQL - Database Specific Support

DbVisualizer Logo
DbVisualizer 5.1
October 2006
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
Schema
Tables
Create Table References, Tables
Table
Create Index, Drop Table, Empty Table, Import Table Data, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL, Data, Grants, Indexes, Info, Primary Key, References, Row Count, Row Id
Views
References, Views
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
Drop Index, Rebuild Index, Rename Index DDL, Info
Triggers
Triggers
Trigger
Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Info, Source
Functions
Create Function Functions
Function
Drop Function, Rename Function Info, Source
Sequences
Create Sequence Sequences
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
Drop Type Info
DBA
DBA
Users
Users
User
Info
Groups
Groups
Group
Info
Settings
Settings
Locks
Locks
Sessions
Sessions




Copyright © 2006 Onseven Software AB. All rights reserved.