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

ADM_TABLESPACES

ADM_TABLESPACES displays information about all tablespaces. 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. The logical structure features of GaussDB are different from those of the A database.

Table 1 ADM_TABLESPACES columns

Name

Type

Description

tablespace_name

character varying(64)

Tablespace name.

block_size

numeric

Not supported. The value is NULL.

initial_extent

numeric

Not supported. The value is NULL.

next_extent

numeric

Not supported. The value is NULL.

min_extents

numeric

Not supported. The value is NULL.

max_extents

numeric

Not supported. The value is NULL.

max_size

numeric

Not supported. The value is NULL.

pct_increase

numeric

Not supported. The value is NULL.

min_extlen

numeric

Not supported. The value is NULL.

contents

character varying(9)

Not supported. The value is NULL.

status

character varying(9)

Not supported. The value is ONLINE.

logging

character varying(9)

Not supported. The value is NULL.

force_logging

character varying(3)

Not supported. The value is NULL.

extent_management

character varying(10)

Not supported. The value is NULL.

allocation_type

character varying(9)

Not supported. The value is NULL.

plugged_in

character varying(3)

Not supported. The value is NULL.

segment_space_management

character varying(6)

Not supported. The value is NULL.

def_tab_compression

character varying(8)

Not supported. The value is NULL.

retention

character varying(11)

Not supported. The value is NULL.

bigfile

character varying(3)

Not supported. The value is NULL.

predicate_evaluation

character varying(7)

Not supported. The value is NULL.

encrypted

character varying(3)

Not supported. The value is NULL.

compress_for

character varying(30)

Not supported. The value is NULL.

def_inmemory

character varying(8)

Not supported. The value is NULL.

def_inmemory_priority

character varying(8)

Not supported. The value is NULL.

def_inmemory_distribute

character varying(15)

Not supported. The value is NULL.

def_inmemory_compression

character varying(17)

Not supported. The value is NULL.

def_inmemory_duplicate

character varying(13)

Not supported. The value is NULL.

shared

character varying(12)

Not supported. The value is NULL.

def_index_compression

character varying(8)

Not supported. The value is NULL.

index_compress_for

character varying(13)

Not supported. The value is NULL.

def_cellmemory

character varying(14)

Not supported. The value is NULL.

def_inmemory_service

character varying(12)

Not supported. The value is NULL.

def_inmemory_service_name

character varying(1000)

Not supported. The value is NULL.

lost_write_protect

character varying(7)

Not supported. The value is NULL.

chunk_tablespace

character varying(1)

Not supported. The value is NULL.