After you create a schema, you create tables to contain the schema's data. Create tables from the Data Director Manage & Monitor tab.

You are a DBA or application developer setting up a database.

You created a database and a schema.

1

Log in to Data Director as a user with database privileges and click the Manage & Monitor tab.

2

In the left pane, click the arrow next to your database name to expand it.

3

Right-click the schema and select Create > Table.

The following tabs appear.

Basic Settings

Columns

Constraints

Auto Vacuum Settings

4

In the Basic Settings tab, enter information such as the table name, whether the name is case-sensitive, and fill factor.

5

You can now configure columns or exit the wizard.

Click Next to configure columns.

Click Finish to create the table.

6

(Optional) In the Columns tab, click Add to add a column, and complete the column fields.

a

Type the column name.

b

Select the column type.

Depending on the column type, you can specify a length or precision, and you can specify a default value for the column.

c

If users must enter a value for the column, select the Not Null check box.

d

If the column is a primary key, select the Primary Key check box.

e

Click Next to continue, or click Finish to create the column.

7

(Optional) In the Constraints tab, specify constraints that apply to the new column.

a

Use the drop-down menu to select the type of constraint: Foreign key, Unique, or Check.

You can create foreign key constraints only if the schema has more than one table.

b

Click Create to specify the constraint.

c

Enter the conditions for the constraint, and click OK.

Data Director creates the constraint.

d

Click Next to continue, or click Finish to create the column.

8

(Optional) In the Auto Vacuum Settings tab, specify settings for removing stale data from your table,

The default settings work well for most environments. For information about auto vacuum, see the documentation on the Postgres.org site.

9

Click Finish to finish table creation.

Data Director creates the table.