列出 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)