10.69 USER_TAB_PARTITIONS

Table of Contents Previous Next


10 Expanded Catalog Views : 10.69 USER_TAB_PARTITIONS

The USER_TAB_PARTITIONS view provides information about all of the partitions that are owned by the current user.
YES if the table is subpartitioned; NO if the table is not subpartitioned.
1명 for the first partition; 2명 for the second partition, etc.
Same as pg_class.reltuples.
Same as pg_class.relpages.

10 Expanded Catalog Views : 10.69 USER_TAB_PARTITIONS

Table of Contents Previous Next