Updated on 2024-05-07 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 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.