Ask a Question
Report a Bug
This page in other versions:
Warning: This documentation is for a pre-release version of pgAdmin 4
Use the Cast dialog to define a cast. A cast specifies how to convert a value
from one data type to another.
The Cast dialog organizes the development of a cast through the following
dialog tabs: General and Definition. The SQL tab displays the SQL code
generated by dialog selections.
Use the fields in the General tab to identify the cast:
Click the Definition tab to continue.
Use the fields in the Definition tab to define parameters:
Click the SQL tab to continue.
Your entries in the Cast dialog generate a SQL command (see an example below).
Use the SQL tab for review; revisit or switch tabs to make any changes to the
The following is an example of the sql command generated by user selections in
the Cast dialog:
The cast uses a function named int4(bigint) to convert a biginteger data type
to an integer.