ALL_ALL_TABLES v17

The ALL_ALL_TABLES view provides information about the tables the current user can access.

NameTypeDescription
ownerTEXTUser name of the table’s owner.
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 isn't specified, then default tablespace PG_DEFAULT.
degreeCHARACTER VARYING(10)Number of threads per instance to scan a table, or DEFAULT.
statusCHARACTER VARYING (5)Included only for compatibility. Always set to VALID.
temporaryTEXTY if the table is temporary, N if the table is permanent.