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

Subscribe to our news
Partners
Testimonials
Simon Pills: "Someone finally invented an intuitively used and easily customized PostgreSQL database administration tool! Keep up the good work. I will be in touch. I am able to do this horrendous work because your software enabled me to create a new database with all necessary objects in several minutes! I am sure that I have found what I really need".
Andrew Maclean: "I am really quite impressed with the software. You and your people are doing a wonderful job. I actually have spent a while researching PostgreSQL admin/code generators and yours seems to fit our needs nicely. Your interface is beautiful".

More

Add your opinion

PostgreSQL Maestro online Help

Prev Return to chapter overview Next

Specifying type properties

Specify type options according to your needs. The detailed description is given below.

 

 

Owner

Defines the owner of the new type.

 

Comment

The box allows you to set optional text to describe the new type.

 

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