After you create a schema, you create tables to contain the schema's data.

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

You created a database and a schema, and are in the Console.

1

In the left pane, click the Schemas arrow to expand it.

2

Right-click the schema and select Create > Table.

3

Type the table name, fill factor, and comment.

4

Click Next.

5

Click Add to add a column.

a

Type the column name, and select the column type..

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

b

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

c

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

6

(Optional) In Constraints, select the type of constraint, Foreign key, Unique, or Check, that applies to the new column.

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

a

Click Create.

b

Enter the conditions for the constraint, and click OK.

c

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

7

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

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

8

Click Finish to create the table.

Data Director creates the table.