PostgreSQL Maestro online Help
Casts
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 |
or
| • | select the Casts list or any object from that list in the explorer tree; |
| • | select the Create New Cast... item from the popup menu |
or
| • | 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 |
or
| • | 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 |
or
| • | 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 |
or
| • | 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.
|
Partners
Download
Buy
