Forget the Column Name in a System Table?

[Deleted User]

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!