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.

**Table 1** GV_INSTANCE columns
Name	Type	Description
inst_id	oid	OID of the current database.
instance_number	oid	OID of the current database.
instance_name	character varying(16)	Name of the current database.
host_name	character varying(64)	Not supported. Set it to NULL.
version	character varying(17)	Not supported. Set it to NULL.
version_legacy	character varying(17)	Not supported. Set it to NULL.
version_full	character varying(17)	Not supported. Set it to NULL.
startup_time	date	Not supported. Set it to NULL.
status	character varying(12)	Not supported. Set it to NULL.
parallel	character varying(3)	Not supported. Set it to NULL.
thread#	numeric	Not supported. Set it to NULL.
archiver	character varying(7)	Not supported. Set it to NULL.
log_switch_wait	character varying(15)	Not supported. Set it to NULL.
logins	character varying(10)	Not supported. Set it to NULL.
shutdown_pending	character varying(3)	Not supported. Set it to NULL.
database_status	character varying(17)	Not supported. Set it to NULL.
instance_role	character varying(18)	Not supported. Set it to NULL.
active_state	character varying(9)	Not supported. Set it to NULL.
blocked	character varying(3)	Not supported. Set it to NULL.
con_id	numeric	Not supported. Set it to NULL.
instance_mode	character varying(11)	Not supported. Set it to NULL.
edition	character varying(7)	Not supported. Set it to NULL.
family	character varying(80)	Not supported. Set it to NULL.
database_type	character varying(15)	Not supported. Set it to NULL.