Forget the Column Name in a System Table?

SarahLSarahL Administrator, Moderator, Employee, Registered User, VerticaExpert, CABuser, VerticaPartners

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.