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

Subscribe to our news:
Partners
Testimonials
J Canepa: "There is a lot of software out there for managing PostgreSQL. Yours is simply the best! Great product".
Patric Michael: "Thank you for a wonderful product, and all the hard work you've obviously taken".

More

Add your opinion

PostgreSQL Maestro online Help

Prev Return to chapter overview Next

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.

 



Prev Return to chapter overview Next