getTypeInfo()

TYPE_NAME = bigint

• AUTO_INCREMENT = false
• CASE_SENSITIVE = false
• CREATE_PARAMS = NULL
• DATA_TYPE = -5 (BIGINT)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = Bigint
• MAXIMUM_SCALE = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = 10
• PRECISION = 19
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = false

TYPE_NAME = boolean

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = false
• CREATE_PARAMS = NULL
• DATA_TYPE = 16 (BOOLEAN)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = Boolean
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 1
• SEARCHABLE = 2
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = character

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = true
• CREATE_PARAMS = length
• DATA_TYPE = 1 (CHAR)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = Character
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 4096
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = character varying ¹

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = true
• CREATE_PARAMS = max length
• DATA_TYPE = 12 (VARCHAR)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = Character varying
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 65535
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = date

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = false
• CREATE_PARAMS = NULL
• DATA_TYPE = 91 (DATE)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = {d'
• LITERAL_SUFFIX = '}
• LOCAL_TYPE_NAME = DATE
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 10
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = double precision

• AUTO_INCREMENT = false
• CASE_SENSITIVE = false
• CREATE_PARAMS = NULL
• DATA_TYPE = 8 (DOUBLE)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = Double precision
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = 2
• PRECISION = 53
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = false

TYPE_NAME = integer

• AUTO_INCREMENT = false
• CASE_SENSITIVE = false
• CREATE_PARAMS = NULL
• DATA_TYPE = 4 (INTEGER)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = Integer
• MAXIMUM_SCALE = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = 10
• PRECISION = 10
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = false

TYPE_NAME = numeric

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = false
• CREATE_PARAMS = precision, scale
• DATA_TYPE = 2 (NUMERIC)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = Numeric
• MAXIMUM_SCALE = 37

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 38
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = false

TYPE_NAME = real

• AUTO_INCREMENT = false
• CASE_SENSITIVE = false
• CREATE_PARAMS = precision
• DATA_TYPE = 7 (REAL)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = Real
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = 2
• PRECISION = 24
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = false

TYPE_NAME = smallint

• AUTO_INCREMENT = false
• CASE_SENSITIVE = false
• CREATE_PARAMS = NULL
• DATA_TYPE = 5 (SMALLINT)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = Smallint
• MAXIMUM_SCALE = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = 10
• PRECISION = 5
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = false

TYPE_NAME = text

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = true
• CREATE_PARAMS = NULL
• DATA_TYPE = -1 (LONGVARCHAR)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = Text
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 256
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = time

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = false
• CREATE_PARAMS = fractional_seconds_precision
• DATA_TYPE = 93 (TIME)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = {t'
• LITERAL_SUFFIX = '}
• LOCAL_TYPE_NAME = Time
• MAXIMUM_SCALE = 6

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 26
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = time with time zone

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = false
• CREATE_PARAMS = fractional_seconds_precision
• DATA_TYPE = 93 (TIMESTAMP)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = {t'
• LITERAL_SUFFIX = '}
• LOCAL_TYPE_NAME = Time with time zone
• MAXIMUM_SCALE = 6

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 32
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = timestamp

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = false
• CREATE_PARAMS = fractional_seconds_precision
• DATA_TYPE = 93 (TIMESTAMP)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = {ts'
• LITERAL_SUFFIX = '}
• LOCAL_TYPE_NAME = Timestamp
• MAXIMUM_SCALE = 6

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 26
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = timestamp with time zone

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = false
• CREATE_PARAMS = fractional_seconds_precision
• DATA_TYPE = 93 (TIMESTAMP)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = {ts'
• LITERAL_SUFFIX = '}
• LOCAL_TYPE_NAME = Timestamp with time zone
• MAXIMUM_SCALE = 6

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 34
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL