USER_ALL_TABLES v13

The USER_ALL_TABLES view provides information about all tables owned by the current user.

NameTypeDescription
schema_nameTEXTName of the schema in which the table belongs.
table_nameTEXTName of the table.
tablespace_nameTEXTName of the tablespace in which the table resides. If the tablespace name is not specified, then default tablespace PG_DEFAULT.
degreeCHARACTER VARYING(10)Number of threads per instance to scan a table, or DEFAULT.
statusCHARACTER VARYING(5)Included for compatibility only; always set to VALID.
temporaryTEXTY if the table is temporary; N if the table is permanent.