Updated on 2025-05-29 GMT+08:00

PGobject

Table 1 Common PGobject methods

Method

Return Type

Description

throws

Support JDBC4 (Yes/No)

Support Unplanned ALT (Yes/No)

getStruct()

Object[]

Obtains the subtype names of the composite type and sorts them according to the creation sequence.

-

Yes

Yes

getValue()

String

Obtains the string value of the composite type.

-

Yes

Yes

getArrayValue()

String[]

Obtains the array values of the composite type and sorts the values according to the sequence of columns of the composite type.

-

Yes

Yes

getAttributes()

Object[]

Obtains the array values of the composite type. If the columns are of the table or array type, PgArray is returned. If the columns are of the composite type, PGobject is returned. For other types, a string value is returned.

SQLException

Yes

Yes