Data Types(1)

Numeric Types

Table 1 lists all available types.

Table 1 Integer types

Table 2 Arbitrary precision types

Table 3 Serial integers

Table 4 Floating point types

Boolean Types

Table 5 Boolean types

Character Types

Table 6 lists the character data types supported by openGauss.

Table 6 Character types

In openGauss, there are two other fixed-length character types, as shown in Table 7. The name type exists only for the storage of identifiers in the internal system catalogs and is not intended for general users. Its length is currently defined as 64 bytes (63 usable characters plus a terminator). The type “char” only uses one byte of storage. It is internally used in the system catalogs as a simplistic enumeration type.

Table 7 Special character types