SQL Maestro Group / Products / PostgreSQL / PostgreSQL Maestro / Documentation

PostgreSQL Maestro online Help

A cast specifies how a conversion between two data types is to be performed. To be able to create a cast, you must own the source or the target data type. To create a binary-compatible cast, you must be a superuser. (This restriction is made because an erroneous binary-compatible cast conversion can easily crash the server.)

New casts are created within Create Cast Wizard. In order to run the wizard you should either

•	select the Object \| Create Database Object... main menu item;

•	select the Cast icon in the Create Database Object dialog

•	select the Casts list or any object from that list in the explorer tree;

•	select the Create New Cast... item from the popup menu

•	open the database in Database Editor and the Casts tab there;

•	press the Insert key or select the Create New Cast... item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

To create a new cast with the same properties as one of the existing casts has:

•	select the Object \| Duplicate Database Object... main menu item;

•	follow the instructions of Duplicate Object Wizard.

Casts can be edited within Cast Editor. In order to run the editor you should either

•	select the cast for editing in the explorer tree (type the first letters of the cast name for quick search);

•	select the Edit Cast ... item from the popup menu

•	open the database in Database Editor and the Casts tab there;

•	select the cast to edit;

•	press the Enter key or select the Edit Cast item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

You can change the name of the cast using the Rename Cast dialog. To open the dialog you should either

•	select the cast to rename in the explorer tree;

•	select the Rename Cast item from the popup menu

•	open the database in Database Editor and the Casts tab there;

•	select the cast to rename;

•	select the Rename Cast item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

To drop a cast:

•	select the cast to drop in the explorer tree;

•	select the Drop Cast item from the popup menu

•	open the database in Database Editor and the Casts tab there;

•	select the cast to drop;

•	press the Delete key or select the Drop Cast item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

and confirm dropping in the dialog window.