Updated on 2025-07-22 GMT+08:00

MY_TABLES

MY_TABLES displays information about the tables owned by the current user. This view exists in both PG_CATALOG and SYS schemas.

Table 1 MY_TABLES columns

Name

Type

Description

owner

character varying(64)

Table owner.

table_name

character varying(64)

Table name.

tablespace_name

character varying(64)

Tablespace name of the table.

dropped

character varying

Specifies whether the current record is deleted.

  • yes: deleted.
  • no: not deleted.

num_rows

numeric

Estimated number of rows in the table.

status

character varying(8)

Specifies whether the current record is valid.
  • valid: valid.

temporary

character(1)

Specifies whether the table is a temporary table.

  • y: The table is a temporary table.
  • n: The table is not a temporary table.