Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Iwan Kelaiah: "SQL Maestro products (Postgresql) have saved me a lot of time in designing, managing and generating reports and front-ends of Postgresql databases. Keep up the great work and thank you for such great products.".
Chris Passion: "I tried 3 different programs before yours and none would be so handy and helpful. PostgreSQL Maestro works great and couldn't be easier to install".

More

Add your opinion

PostgreSQL Maestro online Help

Prev Return to chapter overview Next

Create Type Wizard

Create Type Wizard guides you through the process of creating a new schema type.

 

The basic principles of Create Object Wizards in PostgreSQL Maestro are explained in a separate topic. Below you will find a description of wizard steps that are unique for the current object.

Type properties

At the top of the Properties tab define an Owner, and a Comment of the new type. The type name is represented here as it was set at the previous step.

 

Input Function

Enter the name of a function that converts data from the type external textual form to its internal form.

 

Output Function

Specify the name of a function that converts data from the type internal form to its external textual form.

 

Receive Function

The field contains the name of a function that converts data from the type external binary form to its internal form.

 

Send Function

The name of a function that converts data from the type internal form to its external binary form.

 

Analyze Function

Specify the name of a function that performs statistical analysis for the data type.

 

Internal Length

A numeric constant that specifies the length in bytes of the new type internal representation. The default assumption is that it is variable-length.

 

Default

The default value for the data type. If omitted, the default is null.

 

Element

The type being created is an array; specify the type of the array elements here.

 

Delimiter

The delimiter character to be used between values in arrays made of this type.

 

Alignment (char, int2, int4, or double)

Specify the storage alignment requirement of the data type. The default is int4.

 

Passed By Value

The optional flag indicates that values of this data type are passed by value rather than by reference.

 

Storage (Plain, External, Extended, or Main)

Specify the storage strategy for the data type. The default is Plain.

 

 



Prev Return to chapter overview Next