Database Designer for PostgreSQL allows to manage the following diagram objects:
Databases
Tables
Columns
Constraints
Indexes
Triggers
Rules
Stored Procedures and Functions
Views
Schemas
Domains and User Defined Types
References and Foreign Keys
Roles
Tablespaces
Sequences
Privileges