PostgreSQL Base and Composite Type Domains

PowerDesigner supports the following special PostgreSQL data types:


  • Base Type

  • 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.


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com