Vertica Quick Tip: Forget the Column Name of a System Table?

Posted May 2, 2018 by Soniya Shah, Information Developer

This blog post was authored by Jim Knicely. If you are like me I am constantly forgetting the column names from our system tables. Use this simple trick to get the column names. Example: dbadmin=> SELECT * FROM v_catalog.tables limit 0; table_schema_id | table_schema | table_id | table_name | owner_id | owner_name | is_temp_table | is_system_table | force_outer | is_flextable | has_aggregate_projection | system_table_creator | partition_expression | create_time | table_definition | recover_priority | storage_mode | is_shared | partition_group_expression -----------------+--------------+----------+------------+----------+------------+---------------+-----------------+-------------+--------------+--------------------------+----------------------+----------------------+-------------+------------------+------------------+--------------+-----------+---------------------------- (0 rows) Have Fun!