Online Documentation for SQL Manager for PostgreSQL

Creating/editing base type


The Base Type tab of Base Type Editor allows you to view/edit the base type properties.

 

Name

Select a schema and enter a name for the new base type, or view the name of the base type being edited.

 

Base Type Editor - Editing base type definition

 

 

Synonym

Set the type synonym (available for older server versions).

 

Input function

Use the drop-down list to select the function that will convert data from the type's external textual form to its internal form.

 

Output function

Use the drop-down list to select the function that will convert data from the type's internal form to its external textual form.

 

Internal length

This value specifies the length (in bytes) of the new type's internal representation. Use the spinner control to set a value or check the CheckBox Variable option to apply variable-length (default assumption).

 

External length

This value specifies the length (in bytes) of the new type's external representation. Use the spinner control to set a value or check the CheckBox Variable option if the type length is unknown (for server version 7.3 and lower only).

 

Analyze function

Use the drop-down list to select the function that will perform statistical analysis for the data type.

 

Receive function

Use the drop-down list to select the function that will convert data from the type's external binary form to its internal form.

 

Send function

Use the drop-down list to select the function that will convert data from the type's internal form to its external binary form.

 

Element

If the type being created is an array, use the drop-down list to specify the type of the array elements.

 

Default

If necessary, specify the default value for the data type. By default the NULL value is applied.

 

Alignment

Use the drop-down list to select the storage alignment requirement of the data type: char, int2, int4, or double.

 

Delimiter

If necessary, specify the delimiter character to be used between values in arrays made of this type.

 

Storage

Use the drop-down list to select the storage strategy for the data type: PLAIN, MAIN, EXTERNAL, EXTENDED.

 

CheckBox Passed by value

This option indicates that values of this data type are passed by value rather than by reference.