39.1. Creating a Table #
In the navigation panel, go to Databases.
(Optional) To display system databases, turn on Show system databases.
Click the name of the database.
Click the name of the schema.
In the top-right corner of the page, click Create table.
Specify parameters of the new table (parameters marked with an asterisk are required):
Name.
Tablespace: The tablespace where the table will be created.
Columns: Columns of the created table.
To add a column:
Click Add +.
Specify parameters of the new column (parameters marked with an asterisk are required):
Name.
Type: The type of the column data.
NOT NULL: Specifies whether the column accepts
NULLvalues.Default value: The default value of the column.
Primary key: Specifies whether the column can contain only unique (non-repeating) values different from
NULL.To add a primary key storage parameter, click Add + and specify the required parameters:
Name: The name of the primary key storage parameter.
Possible values:
Value: The value of the primary key storage parameter.
Unique key: Specifies whether the column can contain only unique values.
To add a unique key storage parameter, click Add + and specify the required parameters:
Name: The name of the unique key storage parameter.
Possible values:
Value: The value of the unique key storage parameter.
Check expression: The constraint of the column.
Compression method: The compression method for the column.
Possible values:
pglz
lz4
Click Save.
Storage parameters: Storage parameters of the table.
To add a storage parameter:
Click Add +.
Select the parameter.
Specify the value.
UNLOGGED: Specifies whether the created table is unlogged.
lock_timeout, s: Abort any statement that waits longer than the specified time while attempting to acquire a lock on a table, index, row, or other database object. The time limit applies separately to each lock acquisition attempt.
For more information about this parameter, refer to the official Postgres Pro documentation.
Click Save.