Listing Flex Tables
You can determine which tables in your database are flex tables by querying the is_flextable
column of the v_catalog.tables
system table. For example, use a query such as the following to see all tables with a true (t
) value in the is_flextable
column:
=> 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)