Updated on 2024-06-03 GMT+08:00

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

timestamp(0) without time zone

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.