Online Documentation for SQL Manager for PostgreSQL

Editing field definition


Field name

Enter a name for the new field, or modify the name of the field being edited. Note that the name of a field must be unique among all the field names in the table.

 

Field Editor - Editing field definition

 

Data type

Type

Here you can set the field type by selecting it from the drop-down list of the standard PostgreSQL data types.

 

Change by expression

Specify an expression that defines the value of the computed column.

 

Size

Specify the size value (for certain types). Check the CheckBox Unlimited option to use the maximum values set by PostgreSQL.

 

Precision

Specify precision for numeric data type field.

 

Set the number of array dimensions in the Number of array dimensions spinner control. This control is disabled if the field is not an array field.

 

Collation

Select field collation from the list.

 

Generated

Select the value for identity field. If ALWAYS is specified, a user-specified value is only accepted if the INSERT statement specifies OVERRIDING SYSTEM VALUE. If BY DEFAULT is specified, then the user-specified value takes precedence.

 

Storage

You can change the storage type to PLAIN, EXTENDED, EXTERNAL or MAIN.

 

Field flags

CheckBox Not Null

Check this option to specify that the values for the column should never contain a null value.

 

CheckBox Primary key

Check this option to include the field into the primary key. Note that if you include a field to a primary key, you should also make it Not Null.

A table typically has a column or combination of columns that contain values that uniquely identify each row in the table. This column, or columns, is called the primary key (PK) of the table and enforces integrity of the table.

 

CheckBox Unique

Check this option to create a unique key on the field that provides entity integrity for a particular column or columns using a unique index.

 

The Statistics group enables collection of row-level statistics on database activity.

Number of statistic details

Allows setting the level of row-level statistics on database activity accumulation.

 

Use the Default Value and the Description tabs of Field Editor to set values taken by default and optional text as a description for the field.