The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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.

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!

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.