Previous Topic: Define PostgreSQL TriggersNext Topic: Define PostgreSQL User-Defined Types

Creating Models › Target Servers for Physical Models › Database Property Editors › PostgreSQL Physical Property Editors › PostgreSQL Support Summary › Define PostgreSQL Tablespaces

Define PostgreSQL Tablespaces

Use the PostgreSQL Tablespace Editor to define a tablespace in PostgreSQL physical model.

To define a PostgreSQL tablespace

  1. In the Model Explorer, right-click Tablespaces and click New.

    An instance of Tablespace is created.

  2. Right-click the instance and click Properties.

    The PostgreSQL Tablespace Editor opens.

  3. In the navigation grid, select the tablespace that you want to define and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a tablespace. Use the Enter filter text box to filter a very large list of tablespaces to quickly locate the one that you want to define.

    Name

    Specifies the name of the table. Change the name of the table in this field.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  4. On the PostgreSQL tab, work with the following options:
    Owner

    Specifies the role or user that owns the tablespace. Select the owner from the drop-down list or click New New icon in property editors to create a new object to create one.

    Location

    Specifies the directory that will be used for the tablespace. The directory should be empty and must be owned by the PostgreSQL system user. Specify the directory in the absolute path name format.

    Options

    Specifies tablespace parameters to be set or reset.

  5. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  6. (Optional) Click the Where Used tab to view where the object is used within the model.
  7. (Optional) Click the UDP tab to work with user-defined properties for the object.
  8. (Optional) Click the Notes tab to view and edit user notes.
  9. (Optional) Click the Extended Notes tab to view or edit user notes.
  10. Click Close.

    The tablespace is defined and the PostgreSQL Tablespace Editor closes.

For more information, refer to PostgreSQL documentation.