Note: The following options depend on the field type you are chosen. The primary key constraint is checked only at the end of the transaction. Note: Support from PostgreSQL 9.0 or later. The primary key constraint can be deferred.

The fillfactor storage parameter of the primary key constraint's index. The tablespace of the primary key constraint's index. None of the fields that are part of the primary key can contain a null value.Īdd a new field with modification as one of the existing fields. Note: Be careful when shortening the field length as losing data might be caused.Ĭheck this box to not allow the NULL values for the field.Ī Primary Key is a single field or combination of fields that uniquely defines a record. Use the Length edit box to define the length of the field and use Decimals edit box to define the number of digits after the decimal point (the scale) for Floating Point data type.

The Type drop-down list defines the type of the field data. Note that the name of the field must be unique among all the field names in the table. Use the Name edit box to set the field name. Note: Only available when creating a new table.

Navicat pgsql