Tablespaces Wizard (PostgreSQL)
Go Up to PostgreSQL Object Wizards
This wizard lets you build and submit a simple CREATE TABLESPACE statement, registering a new, cluster-wide tablespace.
To create a new tablespace using a wizard:
- Open a creation wizard for a tablespace. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - Check Constraints (PostgreSQL) - Properties.
- Definition panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Tablespaces (PostgreSQL) - Properties
When creating or editing a tablespace, this tab/panel lets you work with the following settings:
Setting | Description |
---|---|
Table Schema and Table Name |
Identify the table for which the constraint is being created. |
Name |
Lets you type the name of the tablespace. |
Owner |
Lets you select the name of the user who will own the tablespace. |
Location |
Lets you provide a LOCATION parameter clause, identifying the directory used for the tablespace. |
random_page_code and seq_page_cost |
When either of these settings are assigned values, the generated CREATE TABLESPACE DDL is followed by an ALTER TABLESPACE statement that lets you override the RANDOM_PAGE_COST and SEQ_PAGE_COST configuration parameters. |