GaussDB-GV_INSTANCE

40 阅读1分钟

GaussDB-GV_INSTANCE

GV_INSTANCE displays information about the current database instance. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the PG_CATALOG and SYS schemas.

NameTypeDescription
inst_idoidOID of the current database.
instance_numberoidOID of the current database.
instance_namecharacter varying(16)Name of the current database.
host_namecharacter varying(64)Not supported. Set it to NULL.
versioncharacter varying(17)Not supported. Set it to NULL.
version_legacycharacter varying(17)Not supported. Set it to NULL.
version_fullcharacter varying(17)Not supported. Set it to NULL.
startup_timedateNot supported. Set it to NULL.
statuscharacter varying(12)Not supported. Set it to NULL.
parallelcharacter varying(3)Not supported. Set it to NULL.
thread#numericNot supported. Set it to NULL.
archivercharacter varying(7)Not supported. Set it to NULL.
log_switch_waitcharacter varying(15)Not supported. Set it to NULL.
loginscharacter varying(10)Not supported. Set it to NULL.
shutdown_pendingcharacter varying(3)Not supported. Set it to NULL.
database_statuscharacter varying(17)Not supported. Set it to NULL.
instance_rolecharacter varying(18)Not supported. Set it to NULL.
active_statecharacter varying(9)Not supported. Set it to NULL.
blockedcharacter varying(3)Not supported. Set it to NULL.
con_idnumericNot supported. Set it to NULL.
instance_modecharacter varying(11)Not supported. Set it to NULL.
editioncharacter varying(7)Not supported. Set it to NULL.
familycharacter varying(80)Not supported. Set it to NULL.
database_typecharacter varying(15)Not supported. Set it to NULL.

更多详情请参考GaussDB 文档中心:doc.hcs.huawei.com/db/zh-cn/ga…