列出 Flex 表
您可以通过查询 v_catalog.tables
系统表的 is_flextable
列,确定数据库中的哪些表为 Flex 表。例如,使用下面的查询来查看 is_flextable
列中具有 true (t
) 值的所有表:
=> SELECT table_name, table_schema, is_flextable FROM v_catalog.tables;
table_name | table_schema | is_flextable
---------------------+--------------+-----------------
bake1 | public | t
bake1_keys | public | f
del | public | t
del_keys | public | f
delicious | public | t
delicious_keys | public | f
bake | public | t
bake_keys | public | f
appLog | public | t
appLog_keys | public | f
darkdata | public | t
darkdata_keys | public | f
(12 rows)