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 the PG_CATALOG and SYS schemas.

**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. 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.