ALL_TABLES v17

The ALL_TABLES view provides information on all user-defined tables.

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, the default tablespace PG_DEFAULT.
degreeCHARACTER VARYING(10)Number of threads per instance to scan a table, or DEFAULT.
statusCHARACTER VARYING(5)Whether or not the state of the table is valid. Included only for compatibility. Always set to VALID.
temporaryCHARACTER(1)Y if this is a temporary table, N if this isn't a temporary table.