Chapter 14 DBMS-Specific Features

PostgreSQL base and composite type domains

PowerDesigner supports the following special PostgreSQL data types:

• Base Type
• Composite Type

To create a base or composite type:

1. Select Model→Domains to open the List of Domains
2. Click the Add a Row tool to create a new domain, and then click the Properties tool to open its property sheet.
3. Select either BaseType or CompositeType from the Stereotype list and click Apply .
4. An additional tab called either Base Type or Composite Type will be displayed, allowing you to specify type-specific extended attributes. See the relevant section in the "PostgreSQL extended attributes" section, for details of these properties.

Copyright (C) 2005. Sybase Inc. All rights reserved.