MY_TABLESPACES

MY_TABLESPACES displays the description of tablespaces that store objects owned by users. By default, it is accessible to all users. This view exists in the PG_CATALOG and SYS schemas. The logical structure features of the GaussDB are different from those of the A database.

**Table 1** MY_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)	Tablespace status. The default 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.
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.