Previous Topic

Next Topic

Book Contents

Book Index

PostgreSQL

The Database Explorer window provides the following support for PostgreSQL objects.

Tables

Display

Actions

List Displays

  • List of Tables/Views
  • List of Tables/Views with Description
  • List of Tables with Table Sizing
  • List of Tables with TOAST table

Details Display

  • Columns
  • Column Descriptions
  • Column Defaults
  • Column Statistics
  • Table Statistics
  • Table IO statistics
  • Primary Key Columns
  • Indexes
  • Check Constraints
  • Authorities on Table
  • Views on Table
  • Triggers
  • Referenced Tables (Foreign Keys)
  • Dependent Tables
  • Create / Alter / Drop Table
  • Create View on table
  • Create Primary Key / Index on Table
  • Create Foreign Key on Table
  • Create Trigger on Table
  • Create Check Constraint on Table
  • Generate DDL for Table and related indexes, keys, views, triggers, constraints
  • Compare Tables definitions
  • Manage table descriptions
  • Rename table/s

Views

Display

Actions
  • Columns
  • View Definition
  • Objects referenced by View
  • Views on View
  • Authorities on View
  • Create / Alter / Drop View
  • Generate DDL for View
  • Compare View definitions
  • Manage View descriptions

Materialized Views

Display

Actions
  • Columns
  • Definition of Materialized View
  • Objects referenced by Materialized View
  • Views on Materialized View
  • Authorities on Materialized View
  • Create / Alter / Drop Materialized View
  • Generate DDL for Materialized View
  • Manage Materialized View descriptions

Indexes

Display

Actions
  • Index Text
  • Index Statistics
  • Create / Drop Index
  • Generate DDL for Index
  • Manage Index descriptions

Tablespaces

Display

Actions
  • Tables in Tablespace
  • Indexes in Tablespace
  • Create Tablespace

Users / Roles

Display

Actions
  • Detail of User/Role
  • Members of Role
  • Roles this user/role belongs to
  • Table Authorities
  • Routine Authorities
  • Usage Authorities
  •  

Triggers

Display

Actions

List Displays

  • List of Triggers
  • List of Triggers with Events
  • List of Triggers with Descriptions
  • List of non-internal Triggers

Details Display

  • Trigger Details
  • Trigger Function
  • Create / Redefine / Drop Trigger
  • Compare Trigger definitions
  • Manage Trigger descriptions

Routines (Functions and Procedures)

Display

Actions
  • Routine Text
  • Routine Parameters
  • Details of Routine
  • Authorities on Routine
  • Create / Redefine / Drop Routine
  • Generate DDL for Routine
  • Compare Routine definitions
  • Manage Function descriptions

Sequences

Display

Actions
  • Details of Sequence
  • Columns using Sequence
  • Create / Alter / Drop Sequence
  • Generate DDL for Sequence