Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Forget the Column Name in a System Table?

Jim Knicely authored this tip.

If you are like me, you are constantly forgetting the column names from our system tables. Use this simple trick to get the column names.


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!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.