V_INSTANCE

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

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